NOTE: Wont show anything for a library that has no scratch tapes available, for that use TSM Studio
SELECT LIBRARY_NAME,COUNT(*) AS NUM_SCRATCH FROM LIBVOLUMES WHERE UPPER(STATUS)=’SCRATCH’ GROUP BY LIBRARY_NAME
Posted in: Helpful TSM SQL Commands
Spirit Software Solutions - TSM Administration and Reporting made easy
