select count(*) from libvolumes where status='Scratch'

-----------------------------------
Bruce Kamp
Network Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
------------------------------------


-----Original Message-----
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 7:43 AM
To: [EMAIL PROTECTED]
Subject: q libv


hi!
does anyone know how to query the library volumes and see the amount of
scratch tapes there wthout having to plough through the whole list of all
volumes?

thnx,
Michelle

Reply via email to