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 = NCM.COnnectionProfile),'<No Profile>') as Connection_Profile


    from nodes n

    join (

      select CoreNodeID, devicetemplate, ConnectionProfile

      from NCM_nodes

      ) NCM on NCM.CoreNodeID=n.NodeID



    Amit shah

    Loop1 Systems