Hello Timothy,
I am using next scripts:
define script F3_Node_Backup_Copy_Groups description="<Node> Active backup copy
groups for node"
update script F3_Node_Backup_Copy_Groups \
"select b.node_name, a.domain_name, a.class_name as Management_Class,
a.destination as Destination_Pool, \
a.verexists as MAX_Versions, a.verdeleted as Max_Deleted, a.retextra as
Days_Inactive, a.retonly Days_Last_Deleted \
from bu_copygroups a, backups b \
where a.class_name = b.class_name and a.set_name = 'ACTIVE' and b.node_name =
upper('\$1') \
group by b.node_name, a.domain_name, a.class_name, a.destination, a.verexists,
a.verdeleted, a.retextra, a.retonly"
define script F4_Node_Archive_Copy_Groups description="<Node> Active archive
copy groups for node"
update script F4_Node_Archive_Copy_Groups \
"select b.node_name, a.domain_name, a.class_name as Management_Class,
a.destination as Destination_Pool, a.retver as Retention \
from ar_copygroups a, backups b \
where a.class_name = b.class_name and a.set_name = 'ACTIVE' and b.node_name =
upper('\$1') \
group by b.node_name, a.domain_name, a.class_name, a.destination, a.retver"
If you are ready to wait some time (sometimes huge), run <script name> <node
name> to see complete information about management class and copy group used by
node.
Regards,
Grigori
________________________________________
From: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Timothy Hughes [Timothy.Hughes AT OIT.STATE.NJ DOT US]
Sent: Thursday, January 28, 2010 7:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL Query find nodes associated with management class
Hi all,
I am trying to find all nodes that are associated with a particular
management class, does anyone have a SQL statement that will produce
this information?
Thanks
Please consider the environment before printing this Email.
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are not the
named recipient(s), please delete this email after notifying the sender
immediately. BKME cannot guarantee the integrity of this communication and
accepts no liability for any damage caused by this email or its attachments due
to viruses, any other defects, interception or unauthorized modification. The
information, views, opinions and comments of this message are those of the
individual and not necessarily endorsed by BKME."
|