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

Number of Nodes by IOS

I've just added this resource to the Home page and noticed that the number of devices for at least of the IOS releases are incorrect a number of the IOS releases are definitely showing double the number of devices with that IOS release eg 4 * 12.2(33)SXH2a is only 2 actual devices, 8 * 12.2(33)SXH1 is only actually 4 devices.

Does this mean all the devices are showing double the number on that release of IOS?

How can I change it so it shows the correct numbers?

Thanks

IOS.jpg

Find more posts tagged with

Accepted answers

All comments

lchance

my own IOS counts are accurate.

i wonder if yours are not accurate because you are using a trial copy of Solarwinds?

just a guess...

cheers.

savell

I wouldn't have thought that a trial version would have any impact upon something like this.

If you are keen to research the cause before logging a case, you can run profiler on the SQL server and capture the SQL statement issued to produce this table (I'm assuming it's just a fairly straight forward count on the Nodes table). You can then execute and modify this yourself - firstly to determine if the SQL returns the same data as that presented in the table, and then by removing the count, determine which nodes are identified as having this level of IOS.

Doing this can then help you eliminate an issue with what you think is running in your Network vs a possible Orion bug.

Sav.

lchance

savell -

is this what you mean by capture? (...and hey - that's a great tip by the way - my first time to make use of the SQL Profiler...learn something every day...)

of course, i'm including Vendor Icon and Machine Type, but should JONCHILL get similar results?

SELECT
Nodes.VendorIcon AS Vendor_Icon, COUNT(Nodes.IOSVersion) AS COUNT_of_IOS_Version, Nodes.IOSVersion AS IOS_Version, Nodes.MachineType AS Machine_Type
FROM
Nodes

GROUP BY Nodes.VendorIcon, Nodes.IOSVersion, Nodes.MachineType
ORDER BY 2 DESC

Thanks again for the SQL Profiler TIP...and good luck to you JonChill.

jonchill

Thanks for the info, I'm not running an eval its a full licensed copy so not quite sure why it shows the eval on the screen captures its not there when viewing normally.

That worked a treat the output from this matches what the website says so I'll do some further investigation, how come my 2960's only show up at Cisco and not there correct model number like the rest of the switches.