Re: [ADSM-L] SQL Query find nodes associated with management class
2010-01-29 09:48:58
Thanks for All your replies! I was able to come up with SQL query to
display the nodes and their Management Classes
Best Regards!
Richard Sims wrote:
On Jan 28, 2010, at 11:16 AM, Timothy Hughes wrote:
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?
A frequently asked question: see the ADSM-L archives for the many responses.
Nodes are not assigned to management classes: individual file system objects
are, where such binding can vary by Include spec and TSM directory processing
rules. The SQL query to scan millions of files to determine this fully is
infeasible. The only realistic thing to do is to sample a few representative
files.
Richard Sims
|
|
|