I can't take credit for this. I believe someone on the list came up with it or I used Excel with ODBC to come up with it (I stink at select queries), I put it into a script I call scratch_query. First it gives the number of scratch tapes then it list them.
Select library_name, count(*) from libvolumes where status='Scratch' group by library_name SELECT LIBVOLUMES.LIBRARY_NAME, LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS,LIBVOLUMES.HOME_ELEMENT FROM LIBVOLUMES LIBVOLUMES WHERE (LIBVOLUMES.STATUS='Scratch') ORDER BY LIBVOLUMES.VOLUME_NAME Hope it helps. Mark Bertrand -----Original Message----- From: Doug Thorneycroft [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 9:16 AM To: [EMAIL PROTECTED] Subject: Re: no status of empty when querying volume Tivoli doesn't track scratch tapes. If the tapes are in a library, try q libvol <library name> This should give you a list of all tapes in the library and wheather they are private or scratch. Doug Thorneycroft County Sanitation Districts of Los Angeles County (562) 699-7411 Ext. 1058 FAX (562) 699-6756 [EMAIL PROTECTED] -----Original Message----- From: Christopher Zahorak [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 6:44 AM To: [EMAIL PROTECTED] Subject: no status of empty when querying volume Hello, I'm very new to TSM. I have a question to why there are no tapes listed as empty. I have 90 tapes in my scratch list but when I do the following command: q volume status=empty , I get a returned message indicating the following: "ANR2034E QUERY VOLUME: No match found using this criteria." I then perform the following command: q volume - to list everything in my volumes and the status of the tapes are either FULL or FILLING. Thanks, Chris. Christopher S. Zahorak, BCS Senior Systems Programmer University of Windsor IT Services, Rm 203 401 Sunset Avenue Windsor, Ontario N9B 3P4 P: (519)253-3000 ext. 2762 F: (519)973-7083 email: [EMAIL PROTECTED]
