Is there anyone that has a report that show all Cisco devices that does not have NCM enabled?
Hi seluton I don't have one pre-built, but I quickly made one and I think this will work. There might be a better way to do this, and I will check! However for now I have simply done a report on all Cisco Nodes where the Connection Profile is empty and that has worked for me.
Hope that helps. Will come back to you if I find something a little cleaner. You could use SWQL but this seems to do the job.
And as I posted it I found the following KB:
Create an NCM report that shows the licensed nodes - SolarWinds Worldwide, LLC. Help and Support
Use the following:
SELECT np.NodeID, nd.SysName, nd.IP_Address, CASE WHEN np.NodeID IS NULL THEN 'Not Licensed' ELSE 'Licensed' END as StatusFROM NCM_NodeProperties as npRIGHT JOIN NodesData as nd on np.CoreNodeID = nd.NodeID
Although I'm not sure this is really what you're after I might have changed it to this:
SELECT nd.Caption, np.NodeID, nd.SysName, nd.IP_Address, CASE WHEN np.NodeID IS NULL THEN 'Not Licensed' ELSE 'Licensed' END as Status, nd.VendorFROM NCM_NodeProperties as npRIGHT JOIN NodesData as nd on np.CoreNodeID = nd.NodeIDWHERE nd.Vendor = 'Cisco'Order by Status desc
Then you can see both Licensed and Not Licensed
- David Smith
Kenson - SolarWinds Authorized Partner
Training, Licenses & Professional Services
- LinkedIn
- Twitter
- Facebook
From the Manage Nodes Page you can add a column titled 'NCM - Licensed'. At the top, just to the right of your column headers there are two(2) Greater Than(>>) Signs.
Click those to bring up a list of available columns to add to your Manage Node Page Display. It will read either yes, or no. Just in case you want to do this without a report.
-CharlesH
Loop1 Systems: SolarWinds Training and Professional Services
Good Point Thanks cahunt
I´m so sorry for not getting back to you on this.
The report is awsome and exactly what I needed, so thanks alot.
// Tommy
The only problem I have run into when auditing things like this is nodes that were never setup for SNMP, and are only polling via ICMP. There is no way to tell what the device is unless you have custom properties or a caption that you can query....sin e the vendor and machine type aren't going to populate. So my work around is to use other custom reports to root out all of my networking equipment that isn't polling via SNMP.
This was the first idea that came in my mind also, vendor for category under managed nodes and then sort by yes/no for NCM licensed.
Your welcome
