Voyager to Alma Migration Query: Duplicate OCLC Numbers (Pass-through query)
When you migrate from Voyager to Alma, it may be helpful to identify and review duplicate OCLC numbers. This pass-through query uses the BIB_INDEX table to identify normalized OCLC numbers (the '0350' index) which occur more than once.
Note that this query can't be run as is as a "normal" Prepackaged Reports Access query, but must be used as a pass-through query.
The query has two parts but is run as a single query.
select
bib_id
, display_heading
from bib_index
where index_code = '0350'
and normal_heading in (
select normal_heading
from bib_index
where index_code = '0350'
and normal_heading like 'OCOLC %'
group by normal_heading
having count(*) > 1
)
order by normal_heading, bib_id
;
For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.