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
from nodes n
select CoreNodeID, devicetemplate, ConnectionProfile
) NCM on NCM.CoreNodeID=n.NodeID