darbronnoco
ADSM.ORG Member
- Joined
- Mar 25, 2014
- Messages
- 17
- Reaction score
- 0
- Points
- 0
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 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'