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:dthorneycroft AT LACSD DOT ORG]
Sent: Tuesday, June 22, 2004 9:16 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
dthorneycroft AT lacsd DOT org



-----Original Message-----
From: Christopher Zahorak [mailto:chris AT UWINDSOR DOT CA]
Sent: Tuesday, June 22, 2004 6:44 AM
To: ADSM-L AT VM.MARIST DOT EDU
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: chris AT uwindsor DOT ca