Thanks in advance
Steve Copper
-Original Message-
From: Julian Armendariz [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 14:56
To: [EMAIL PROTECTED]
Subject: Re: how to identify ofsite tapes for specific node
This email and any files transmitted have been checked by the
MessageL
: [EMAIL PROTECTED]
Subject: Re: how to identify ofsite tapes for specific node
This email and any files transmitted have been checked by the
MessageLabs Virus Scanning Service for the presence of computer
viruses.
Please exercise caution when receiving any attachment(s) from
unknown
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
t
Senior Storage Administrator
Selective Insurance
[EMAIL PROTECTED]
(973) 948-1306
-Original Message-
From: Zosimo Noriega (ADNOC IS&T) [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:39 PM
To: [EMAIL PROTECTED]
Subject: how to identify ofsite tapes for specific node
h
You could try something like this:
select volume_name
from volumes
where volume_name in
(select distinct volume_name
from contents
where node_name='STORMAN')
and stgpool_name='COPYPOOL'
and access='OFFSITE'
(This is one long comman
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
