I use this SQL script to get the volumes used by a specific node in a specific
storagepool.
select distinct node_name,volume_name from volumeusage where node_name=upper('$1') and
stgpool_name=upper('$2')
You can either run this from a command line and replace the $1 with the node name and
$2 with the storage pool or add the script to the server and type "run name_of_script
nodename storagepool". You can type the names either upper or lower case.
Julian Armendariz
System Support Analyst - UNIX
H.B. Fuller
>>> [EMAIL PROTECTED] 03/04/02 09:39PM >>>
hi guys,
please help me to identify offsite tapes belong to a specific node. i have
a problem on my onsite tapes for specific node but i could not easily
identify which offsite tapes belong to that node from my offsite location.
Do you have a SQL scripts or commands to get done this tasks?
your help is really appreciated..... thanks,
Zosi Noriega
ADNOC - UAE
