When migrating from Voyager to Alma it may be helpful to identify and review duplicate patron records identified by having duplicate patron barcodes.

The following query, which can be run using Voyager Prepackaged Access Reports, provides a count of duplicate patron barcodes, regadless whether or not the barcode is active.

SELECT PATRON_BARCODE.PATRON_BARCODE, Count(PATRON_BARCODE.PATRON_BARCODE_ID) AS CountOfPATRON_BARCODE_ID
FROM PATRON_BARCODE INNER JOIN PATRON ON PATRON_BARCODE.PATRON_ID = PATRON.PATRON_ID
WHERE (((PATRON.DB_ID)="0" Or (PATRON.DB_ID) Is Null))
GROUP BY PATRON_BARCODE.PATRON_BARCODE
HAVING (((Count(PATRON_BARCODE.PATRON_BARCODE_ID))>1))
ORDER BY PATRON_BARCODE.PATRON_BARCODE;

This next query filters on active barcodes (BARCODE_STATUS is 1)

SELECT PATRON_BARCODE.PATRON_BARCODE, Count(PATRON_BARCODE.PATRON_BARCODE_ID) AS CountOfPATRON_BARCODE_ID
FROM PATRON_BARCODE INNER JOIN PATRON ON PATRON_BARCODE.PATRON_ID = PATRON.PATRON_ID
WHERE (((PATRON_BARCODE.BARCODE_STATUS)="1")
AND ((PATRON.DB_ID)="0" Or
(PATRON.DB_ID) Is Null))
GROUP BY PATRON_BARCODE.PATRON_BARCODE
HAVING (((Count(PATRON_BARCODE.PATRON_BARCODE_ID))>1))
ORDER BY PATRON_BARCODE.PATRON_BARCODE;

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
 
Posted as is. If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.