Re: [ADSM-L] SQL Query find nodes associated with management class
2010-01-28 11:30:01
The only way I know to get that directly is from the backups table.
Running a select against the backups table for all nodes on a server is
not a good thing...believe me (don't ask).
If you want to do it, make the select as precise as possible and run it
for one node at a time.
select distinct node_name, filespace_name, class_name from backups where
node_name='NODENAMEXYZ' and filespace_id=x (or
filespace_name='whateveryerlookinfer') and type='FILE' and
state='ACTIVE'
Wanda advised me to limit such queries with index key paramaters as much
as possible to keep the select processing as light as possible.
George Huebschman
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Timothy Hughes
Sent: Thursday, January 28, 2010 11:16 AM
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
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive
or action-oriented messages to us via electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|
|
|