ADSM-L

Re: Query Scratch Volumes

2001-02-23 11:31:40
Subject: Re: Query Scratch Volumes
From: Jim Sarset <Jim.Sarset AT TORO DOT COM>
Date: Fri, 23 Feb 2001 10:31:47 -0600
select volume_name from libvolumes where status = 'Scratch' 
  will list all scratch volumes
  We use
select count(*) from libvolumes where status = 'Scratch'
  to get the number of scratch tape

jim.sarset AT toro DOT com

>>> shicks AT KUB DOT ORG 02/23/01 10:13AM >>>
 What would the syntax be for a query to only show scratch volumes?
<Prev in Thread] Current Thread [Next in Thread>