Report on NCM connection profile

Version 1

    While doing NCM configuration for a client, I needed a list of nodes which did not have a connection profile.  I like having every NCM node use a connection profile and a quick script gave me the info I wanted.  I'm sure we can group it and tweak it as needed.

     

    select n.caption as Node_Name, n.IP_Address, n.vendor as Vendor

    , isnull((select Name from NCM_ConnectionProfiles NCMp where NCMp.id = NCM.COnnectionProfile),'<No Profile>') as Connection_Profile

    ,NCM.DeviceTemplate

    from nodes n

    join (

      select CoreNodeID, devicetemplate, ConnectionProfile

      from NCM_nodes

      ) NCM on NCM.CoreNodeID=n.NodeID

     

    Thanks

    Amit shah

    Loop1 Systems