If you just want the count of scratch tapes, and only have one library, you
can run "select count(*) from libvolumes where status='Scratch'" to see how
many scratch tapes you have.
Nick Cassimatis
[EMAIL PROTECTED]
He who laughs last has a good backup.
Mark Bertrand
<[EMAIL PROTECTED]
UNWIRED.COM> To
Sent by: "ADSM: [EMAIL PROTECTED]
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: no status of empty when
querying volume
06/22/2004 11:18
AM
Please respond to
"ADSM: Dist Stor
Manager"
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
<<inline: graycol.gif>>
<<inline: pic21973.gif>>
<<inline: ecblank.gif>>
