Script to List All nodes with mgmt class, schedule and retention

darbronnoco

ADSM.ORG Member
Joined
Mar 25, 2014
Messages
17
Reaction score
0
Points
0
PREDATAR Control23

Hi I am looking to find a script or SQL select command to run to collect and export a list of all nodes with the mgmt class, schedule, and the retention it is tied to. Bonus points if you know a way to get include exluce lists from each node. Thanks for your help.
 
PREDATAR Control23

select n.node_name as Node, n.domain_name as "Domain", cast((m.set_name) as char (7)) as Set, m.class_name as MgmtClass, cast((m.defaultmc) as char (6)) as Deflt, cast((verexists) as char(8)) as "VerEx", cast((verdeleted) as char(8)) as "VerDel", cast((retextra) as char(8)) as "RetEx", cast((retonly) as char(8)) as "Retonly" from nodes as n, mgmtclasses as m, bu_copygroups as c where n.domain_name=m.domain_name and m.domain_name=c.domain_name and m.set_name=c.set_name and m.class_name=c.class_name and m.set_name='ACTIVE' and m.defaultmc='Yes'
 
PREDATAR Control23

select n.node_name as Node, n.domain_name as "Domain", cast((m.set_name) as char (7)) as Set, m.class_name as MgmtClass, cast((m.defaultmc) as char (6)) as Deflt, cast((verexists) as char(8)) as "VerEx", cast((verdeleted) as char(8)) as "VerDel", cast((retextra) as char(8)) as "RetEx", cast((retonly) as char(8)) as "Retonly" from nodes as n, mgmtclasses as m, bu_copygroups as c where n.domain_name=m.domain_name and m.domain_name=c.domain_name and m.set_name=c.set_name and m.class_name=c.class_name and m.set_name='ACTIVE' and m.defaultmc='Yes'



This is excellent sir!! For bonus points is there any way to add the start time of the backup? Thanks so much!
 
PREDATAR Control23

shoot it looks like the mgmt. class isn't reporting the results correctly. Everything is showing as DAILY. From the looks of it the default mgmt class is whats showing instead of what is assigned to the node. Any idea on how to correct that portion. Thanks
 
PREDATAR Control23

Mgmt class shows correct on my test.

I modified the select statement from Bobwilliz to get backup start time as requested:

select n.node_name as Node, n.domain_name as "Domain", cast((m.set_name) as char (7)) as Set, m.class_name as MgmtClass, cast((m.defaultmc) as char (6)) as "Default", cast((verexists) as char(8)) as "VerEx", cast((verdeleted) as char(8)) as "VerDel", cast((retextra) as char(8)) as "RetEx", cast((retonly) as char(8)) as "Retonly", cs.starttime as "StartT" from nodes as n, mgmtclasses as m, bu_copygroups as c, client_schedules as cs, associations as a where n.domain_name=m.domain_name and m.domain_name=c.domain_name and c.domain_name=cs.domain_name and cs.domain_name=a.domain_name and n.node_name=a.node_name and m.set_name=c.set_name and m.class_name=c.class_name and m.set_name='ACTIVE' and m.defaultmc='Yes'
 
PREDATAR Control23

I think this line could possibly be the issue with the mgmt class MgmtClass, cast((m.defaultmc) as char (6)) as "Default",
 
PREDATAR Control23

Would it be possible to also add in a sum(logical_mb) from occupancy in that query? I'm not entirely sure where to add that part. Any help would be appreciated.
 
Top