Re: Tape question
2003-02-11 15:39:46
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:PFord AT STENTOR DOT COM]
Sent: Tuesday, February 11, 2003 12:20 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Tape question
> -----Original Message-----
> From: Remeta, Mark [mailto:MRemeta AT SELIGMANDATA DOT COM]
> Sent: Tuesday, February 11, 2003 9:14 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
pford AT stentor DOT com
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.
|
|
|