DX Unified Infrastructure Management

Expand all | Collapse all

How To Identify Dynamic and Static Group Membership

  • 1.  How To Identify Dynamic and Static Group Membership

    Broadcom Employee
    Posted Dec 22, 2016 04:23 AM

    Hi Community,

     

    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.

     

    Many thanks

    Michael



  • 2.  Re: How To Identify Dynamic and Static Group Membership

    Posted Dec 22, 2016 12:24 PM

    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