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

How can I obtain the switch model number?

Is there an easy way to find out the specific model of a switch?

Id like to be able to view a rack that has say 10 switches and see which ones are PoE, indicated by the PS part of this model number.

I can only see Cisco Catalyst 29xxstack, which is useless, when I want to see WS-C2960X-24PS-L

Living in hope... but not holding my breath!

model.JPG

Find more posts tagged with

Accepted answers

All comments

sean.martinez

On any Summary Page, Add a Widget Named Custom Table

Select Datasource, then Advanced Database. Enter the below for SWQL:

SELECT N.IP_Address as [IP Address], N.Caption AS [Node Name], N.CPUCount, WeekDiff(N.LastBoot, GetDate()) AS [Uptime in Weeks], N.HardwareHealthInfos.Model ,N.IOSVersion, N.IOSImage

FROM Orion.Nodes N

where N.HardwareHealthInfos.Model is not null

ORDER BY N.IP_Address

Once you Select Submit, it will ask which Columns you want to select on the Table. You only wanted the Node Name and Model, but I added Image Version and Image Name from another post I was looking at a few minutes ago.

superfly

If you've got NCM, this data is collected and can be shown easily enough in a report.

sk3l3t0r

Using the SWQL code as that puts the info on the gui which is preferable to running reports.

My only question is that is is possible to group these rather than it show a huge list of all of the switches? We group switches in relation to their rack number or physical location, so id like to view it this way then select a group to see the above query relating to the switches within that group.

sk3l3t0r

Hmmm.. spoke too soon, seems I cant display all of the nodes, and you cant even select pages! We have 500 switches, so was hoping it may have split them into pages.. but no!

sk3l3t0r

Looks like I might have to revert to using reports as the query wont display all thenodes...

I do wish we had more control over what columns was displayed in some of the views.

SW is such a frustrating product at times, well, actually most of the time!