Hey all, I need to get some numbers off my switches. Basically I need to know the number of switches I have, and the number of ports being used on the switch.
I have Ciscoworks LMS but it sucks and you can't get anything out of it. Does anyone know how to make a custom report in Orion to get this info?
Basically I need to know the number of switches I have, and the number of ports being used on the switch.
How are you determining if a port is being used or not? By link status or by interface counters?
it appears if you don't have every interface selected in your node's RESOURCES LIST within Orion System Manager then it doesn't get counted.
but here's what I tried and got a count (i'm not sure you can get only switches, unless maybe your node naming scheme was in line for switches then it could be used for the filter)
Nodes.Caption AS NodeName, Nodes.MachineType AS Machine_Type, COUNT(Interfaces.InterfaceIndex) AS COUNT_of_Interface_Index
Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
(Interfaces.AdminStatus = 0) OR
(Interfaces.AdminStatus = 1) OR
(Interfaces.AdminStatus = 2) OR
(Interfaces.AdminStatus = 3) OR
(Interfaces.AdminStatus = 4) OR
(Interfaces.AdminStatus = 5)
GROUP BY Nodes.Caption, Nodes.MachineType
ORDER BY 3 DESC
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.