Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Custom Report for switch inventory

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?

Thanks

Chris

Find more posts tagged with

Accepted answers

All comments

aLTeReGo

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?

cshannahan

Just by link would be fine for now. Still no clue how to do it.

lchance

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)

SELECT
Nodes.Caption AS NodeName, Nodes.MachineType AS Machine_Type, COUNT(Interfaces.InterfaceIndex) AS COUNT_of_Interface_Index
FROM
Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
WHERE
(
(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

cshannahan

Thanks. I'm not too sure how to get this into Orion working though? How do you make it a report?