ok I think I have it figured out... here's what I got select volumeusage.volume_name from volumeusage,volumes where volumeusage.node_name='nodename' and volumeusage.filespace_name='filespacename' and volumeusage.stgpool_name='stgpoolname' and volumes.last_write_date>'yyyy-mm-dd' and volumeusage.volume_name=volumes.volume_name
This will list the volumes that nodename/filespacename is on in storage pool stgpoolname that was written after a certain date(yyyy-mm-dd). Cheers! -----Original Message----- From: Peter Ford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 12:20 PM To: [EMAIL PROTECTED] Subject: Re: Tape question > -----Original Message----- > From: Remeta, Mark [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 11, 2003 9:14 AM > To: [EMAIL PROTECTED] > Subject: Tape question > > > I know this has been covered before but I can't find it. Does > anyone have a > sql query that will tell me what tapes a particular nodes > particular archive > is on? select volume_name,filespace_name from volumeusage where node_name='<NODE NAME>' Throwing in the file space name allows you to see what specific file space is stored on each tape. Hope this helps. Peter Peter Ford System Engineer Stentor, Inc. 5000 Marina Blvd, Brisbane, CA 94005-1811 Main Phone: 650-228-5555 Fax: 650 228-5566 http://www.stentor.com [EMAIL PROTECTED] Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.