This script will give you what is exactly happening on all your tape drives when run. If you run it at regualr intervals (like every 15 mins for 24x7) you get a more complete picture. Output can be inputted into a spreadsheet (space delimited). It is a very old script I tested it on NBU 7.6/ RHE it still works.
#!/bin/ksh
# Jim McDonald, Sydney
# Run this periodically to get as picture of the drive usage, suggest every 15 mins by cron.
# Output is modified from /usr/openv/volmgr/bin/vmoprcmd -h $MEDIA_SERVER -dp ad
# column 1 = Date
# column 2 = Time
# column 3 = Drive Number
# column 4 = External Media ID
# column 5 = Media server name (may be abbreviated)
# column 6 = Is the drive shared [ Yes/No ]
nbu_master=short_hostname_of_master
rpt_dir=/data/stats/tape_drives
log=$rpt_dir/nbu_drive_usage
list_drives(){
media_server_list=$(/usr/openv/netbackup/bin/admincmd/bpstulist | awk ' {print $3 }' | sort -u )
for media_server in $media_server_list ; do
/usr/openv/volmgr/bin/vmoprcmd -h $media_server -dp ad 2> /dev/null | \
grep -v "DRIVE STATUS" | grep -v "Drv DriveName RecMID" | \
awk ' NF > 7 { printf"%s %s %s %s\n",$1,$3,$7,$8 }'
done
}
list_drives | grep -v $nbu_master | sort -u | \
awk -v now="$(date +%R)" -v today="$(date +%D)" '{ printf"%s %s %s \n", today,now,$0 }' >> $log
# END
SLconsole will not give you much. Suggest StorageTek Tape Analytics see https://blogs.oracle.com/eSTEP/entry/announcing_storagetek_tape_analytics_2
It will cost you roughly about the same as a tape drive.
