• Article Type: General
• Product: Aleph
• Product Version: 17.01

Description:
As part of the upgrade process, we have been asked to provide information on the number of bib, item and ADM records. The bibs and ADMs are easy to find. How do we determine the number of items in our Aleph database? T

Resolution:
This SQL will give you the number of items:

s+ xxx50 <where xxx50 is your ADM library>

SQL-xxx50> select count(*) from z30;

• Article last edited: 10/8/2013