Find the number of our authority records in Voyager?

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