Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Find the number of our authority records in Voyager?

    Find the number of our authority records in Voyager?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local

    Question

    How to find the total number of authority records in Voyager?

    Answer

    For each authority record in the database, there is one row in the table AUTH_MASTER. Query for total number of rows in this table to retrieve the number of authority records.

    1. Open Prepackaged Reports
    2. Create new query in SQL view.
    3. Enter query for number of rows in table (see Additional Information)

    Additional Information

    Query for number of rows in AUTH_MASTER:

    select count(*)
    from AUTH_MASTER;


    Note that a similar query can be run on BIB_MASTER to retrieve number of bibliographic records in database.

    The following can be copied/pasted into your Prepackaged Access Reports:

    SELECT Count(AUTH_MASTER.AUTH_ID) AS CountOfAUTH_ID
    FROM AUTH_MASTER;
    

    Article last edited: 06-Sep-2017

    View article in the Exlibris Knowledge Center
    1. Back to top
      • Find the number of bibliographic records (BIB, MFHD, etc.) in Voyager
      • Finding information about our Voyager database required for implementation of EBSCO Discovery Service
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved