> -----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]
