Re: How to find out what tape's a client data are on ?

[ALAN DAVENPORT]

--- Received from SIG.DVNPORT ALAN DAVENPORT                 03/01/01 1249p


You might want to re-write this a little using the "DISTINCT" SQL keyword.
This way you will not see each volume listed a number of times. One for each
file on the tape. Try this:

select distinct volume_name from volumeusage where
node_name='MEDRS2' order by volume_name

   Al

---- 03/01/01 1249p ---- Sent to       ---------------------------------------
  -> [EMAIL PROTECTED]

$RFC822.eml