If you have Report Designer as part of your subscription to WMS or Tipasa, you'll see Report Launch Pad when you select Reports under the Analytics tab. From there, you will be able to do the following. Please see the note at the end if you don't have Report Designer.
This report can be used in several ways by adjusting the query filters and result objects.
BE AWARE Serials / Periodicals can have a LHR holding with no barcodes on their record, recording all their issues. So ensure you use a filter to remove these types of records from this report.
To locate the OCLC numbers of items that have LHRs but do not have Item Barcodes do the following:
The following fields should be included in the query results to make sure you retrieve a unique LHR row:
LHR Control Number
LHR Item Barcode
LHR Basic Unit Enumeration and Chronology
LHR Index Enumeration and Chronology
LHR Supplement Enumeration and Chronology
LHR Item Textual Holdings
Alternatively, if you do not have Report Designer, you can follow the instructions to Create a Local Holdings report using query collections to export your local holdings records to a MARC file and then use a program like MarcEdit to extract the relevant fields to an Excel spreadsheet. Then you can identify which records do not have anything in the barcode field. Make sure that you're receiving local holdings records, which can be done when creating the query collection, under MARC Records > Customize Records > Local Holdings Records.