To all,
I've created a query to list nodes which aren't NCM licensed by Vendor. I have a huge environment with a lot of network discovery, so I'm not the one cleaning up the results. Therefore I want to enable people to quantify when nodes are added that aren't in NCM.
Add this to a report or to a custom query widget.
--Query to filter NCM unlicensed nodes based on vendor criteria
SELECT CN.OrionNode.Vendor
, CN.OrionNode.Caption --node name from OrionNode table
--commented , CN.OrionNode.CustomProperties.Region
--remove the "--commented" part to filter by a custom property named Region and/or define your own
FROM Cirrus.NCMNodeLicenseStatus CN --create a name to identify this table (CN)
WHERE LicensedByNCM = 'No' AND
(CN.OrionNode.Vendor LIKE 'Cisco'
Or CN.OrionNode.Vendor LIKE 'Palo%'
OR CN.OrionNode.Vendor LIKE 'Brocade%'
OR CN.OrionNode.Vendor LIKE 'Riverbed%'
OR CN.OrionNode.Vendor LIKE 'Citrix%')
So I added a custom property just so you can list one if you feel is appropriate alongside this as an index. I want to specifically highlight LicensedByNCM = No. Not LicensedByNCM != Yes, because then you'll pick up nodes with a "never" status.