Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    How can we determine the number of items in our database?

    1. Last updated
    2. Save as PDF
    • 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