I have been running some reports in SW that counts the total number of ports in my environment and also the total number of currently active ports.
However, I noticed that of the 1400 devices, 100 of them do not show any data. So I decided to do some SWQL testing and when I run the command:
SELECT COUNT(InterfaceDescription) AS NumPorts, N.Caption
FROM NCM.Interfaces I JOIN Orion.Nodes N ON (I.Node.CoreNodeID = N.NodeID)
WHERE ((InterfaceTypeName like 'EthernetCsmacd'))
GROUP BY N.NodeID, N.Caption
ORDER BY NumPorts DESC
This returns the Node name that I want as well as the number of interfaces of the Ethernet type.
So the output looks like:
NumPorts Caption
288 *Device Name Here*
Some devices however of the same switch types(Cisco) 3850, 4510, 9410 are not polling any data, so when I run a query to test a specific device:
SELECT COUNT(InterfaceDescription) AS NumPorts, N.Caption
FROM NCM.Interfaces I JOIN Orion.Nodes N ON (I.Node.CoreNodeID = N.NodeID)
WHERE N.Caption like 'Name-9410'
GROUP BY N.NodeID, N.Caption
ORDER BY NumPorts DESC
NumPorts Caption
And nothing shows at all. I have 100 devices out of 1400 that show nothing. This is throwing off my counts and I am not sure how to fix the polling or whatever is causing it to not show the interfaces on these devices.
Any help in this regard would be greatly appreciated.
Thanks so much.