Re: Need help with select command

2004-08-26 Thread Mark D. Rodriguez
Karla Ross wrote: I am trying to find the tapes needed to recover only the "active" backups of a client. I used the following select command and it gives me a list of all tapes for all backups of that client. How can I narrow the search to just "active" backups? select volume_name,filespace_name

Re: Need help with select command

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Karla Ross >I am trying to find the tapes needed to recover only the >"active" backups of a client. I used the following select >command and it gives me a list of all tapes for all backups of >that client. How can I narrow t

Need help with select command

2004-08-26 Thread Karla Ross
I am trying to find the tapes needed to recover only the "active" backups of a client. I used the following select command and it gives me a list of all tapes for all backups of that client. How can I narrow the search to just "active" backups? select volume_name,filespace_name from volumeusage