SQL Query find nodes associated with management class

[dhess62]

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?

 

[mantsm]

I hope this would help you ..

Select a.node_name from nodes a,mgmtclasses b where b.class_name='<MGMTCLASSNAME>

The below will give you a full detail of all the nodes and associated mgmt classes.

select a.node_name,b.class_name from nodes a,mgmtclasses b order by class_name

Regards,
Mani

 

[prasath]

Mani,

Is your SQL query correct. It seems to be show me all the nodes on my TSM even though all nodes are not associated to that management class.

 

[jiefeng]

Mani,

Is your SQL query correct. It seems to be show me all the nodes on my TSM even though all nodes are not associated to that management class.

select NODE_NAME,CLASS_NAME from backups where CLASS_NAME='mgmt_name'
select NODE_NAME,CLASS_NAME from archives where CLASS_NAME='mgmt_name'

Hope this can help you.

 

[prasath]

select NODE_NAME,CLASS_NAME from backups where CLASS_NAME='mgmt_name'
select NODE_NAME,CLASS_NAME from archives where CLASS_NAME='mgmt_name'

Hope this can help you.

backups table is a big one,I'm wary of running the query as I fear it may crash TSM DB.
Have you tried running this before.
FYI, my TSM DB size is 800 GB on v6.2.