For what its worth, this is one of the reports that I run daily to check on
my tape usage.
You will probably have to change the device class.
This script is based on some code that a fellow ADSMer shared with me a
while ago.
I have developed a number of scripts and would be pleased to share.. a list
appears below...

All the best

Tony Morgan

----------------------------------------------------------------------------
-------------------
-------------------
/* Tony Morgan : Last Chg February 2002 : Tapes Report */
/* Tony Morgan : Last Chg February 2002 : Tapes Report */
select access as "Access (All Tapes)", count(*) as "# Tapes" from volumes
where devclass_name='DLT35C' group by access
select status as "Status (Tapes in Library)", count(*) as "# Tapes" from
libvolumes group by status
select stgpool_name as "StgPool Name", status as "Status", count(*) as "#
Tapes" from volumes  where devclass_name='DLT35C' group by stgpool_name,
status
select stgpool_name as "Private StgPools", count(*) as "# Empty Tapes" from
volumes where status='EMPTY' and devclass_name='DLT35C' group by
stgpool_name
select volume_name as "Empty Tapes", stgpool_name as "StgPool" from volumes
where status='EMPTY' and devclass_name='DLT35C'
select volume_name as "Scratch Tapes" from libvolumes where status='Scratch'
q vol dev=DLT35C
q mount
----------------------------------------------------------------------------
-------------------
-------------------
Script Name: ALLOCC
Script Name: ALLOCC
Description: Occupancy File Statistics by Node Name

Script Name: BACKUP_STATUS
Description: Query Last Backup status

Script Name: CACHE
Description: Cache Statistics

Script Name: CHECKIN
Description: Checkin all labellled tapes in the mailbox

Script Name: DB
Description: Database Info

Script Name: DBBACKUP
Description: Backup DB on request to Disk

Script Name: DBBACKUP_TAPE
Description: Backup DB on request to Tape

Script Name: DBCHECK_DAILY
Description: Check DB Report

Script Name: FILESPACE
Description: Filespace Check

Script Name: FILE_STATS
Description: Occupancy File Statistics by Node Name

Script Name: LOST_FILE
Description: Find what volume a file is on

Script Name: MOUNTS
Description: Count Weekly Tape Mounts

Script Name: OCC_REP
Description: Occupancy File Statistics by Node Name

Script Name: S01T
Description: List sessions since yesterday

Script Name: SCRIPTS
Description: List all command scripts - This report!

Script Name: SESSIONS
Description: List sessions since yesterday

Script Name: SLOTS
Description: What Tape is in each Slot? (Adic Scalar100)

Script Name: SUMMARY
Description: Summary Report

Script Name: TAPES
Description: Query Known Tapes

Script Name: TAPES_2
Description: ServerTapePool % of Capacity In Use

Script Name: TAPLAB
Description: Label all unknown tapes by barcode