dhess62
ADSM.ORG Member
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?
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
select NODE_NAME,CLASS_NAME from backups where CLASS_NAME='mgmt_name'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.