Mark

Try this one name of script vol_node: run vol_node  'SYSTEM_1' 'SCA_PC'

select volume_name, stgpool_name, filespace_name from volumeusage where
node_name='$1' and stgpool_name='$2'

Regards Robert Ouzen
Haifa University
Israel


-----Original Message-----
From: Remeta, Mark [mailto:MRemeta AT SELIGMANDATA DOT COM]
Sent: Tuesday, February 11, 2003 7:14 PM
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?

Thanks in advance,

Mark Remeta


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.