Is there a report or SQL query in SLM or any other method that can be used to show all discovered nodes that are not members of any static or dynamic groups.
Need to know what nodes do not have a monitoring profile.
select ccs.name, ccs.ip, ccs.cs_id, ccs.cs_key, ccs.origin, ccs.os_description, ccs.create_TIme, ccs.domain, ccs.dedicated, ccsa.cs_attr_value as OS
from cm_computer_system ccs
LEFT OUTER JOIN cm_group_member cgm ON cgm.cs_id = ccs.cs_id
LEFT OUTER JOIN cm_computer_system_attr ccsa ON ccsa.cs_id = ccs.cs_id and cs_attr_key = 'PrimaryOSType'
LEFT OUTER JOIN cm_group cg ON cg.grp_id = cgm.grp_id
where cg.grp_id is null
ORDER BY ccs.name