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
As the other chaps here mentioned you should still be able to use the Manage Nodes page to view all Nodes licensed in NCM regardless of the Vendor / Machine Type.
To be fair, if you have devices that can be backed up via NCM why are you not monitoring them via SNMP in the first instance? If there is a particular reason, then I would assume those devices are in the minority on your network, and as such you could use a Custom Property to identify them.
Cheers
David
Right, but how can he only look at Cisco devices? The only way he can populate vendor or machine types would be SNMP (AFAIK).
You are correct, the steps needed to identify things haven't taken place. Network discovery should probably come first if you've established your standard beforehand smttysmth02gt . Literally you're asking solarwinds to identify things that you've not given enough info.
Should you not have a solution there, a good scripted NMAP is a fast way to build that list, but still the wrong way.
Step 1: identify all devices for SNMP
Step 2: monitor all devices for SNMP
Step 3: this thread.
Right on....sounds like we are all in agreement then.
