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