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

Cisco IOS Report

osberg

Hi guys,

I need some help with my Cisco IOS report.

I have modified the one there is in SW, so I can get some graph on what devices is running what ios version.

But I am seeing a small issue that I hope you guys can help me with.

I found this SQL script here in the forum

SELECT N.IOSVersion, DD.Date, SUM (CASE WHEN Mult = 0 THEN -1 ELSE 1 END) AS Count

FROM Nodes N

-- ${ToTime} - bug has to be there

cross join (

SELECT DATEADD(mi,-30, GETDATE()) AS Date, 0 as Mult

UNION all

SELECT GETDATE() AS Date, 1 as Mult

UNION ALL

SELECT DATEADD(mi,30, GETDATE()) AS Date, 0 as Mult

) AS DD

GROUP BY IOSVersion, DD.Date, DD.Mult

ORDER BY DD.Date

and that is ok, but if you look here in my graph list it shows around 160 devices there dont have a ios version.

How can I get this fixed so my IOS report will work as intended.

Hope someone can help me out here.

Frank

Find more posts tagged with

Accepted answers

All comments

cnorborg

Interesting approach. I've always generated the raw data through a query like this (which is SWQL but could easily be modified to SQL) and popped it into Excel and generated a Pivot table or Pivot chart to see what I wanted...

SELECT MachineType, IOSVersion, SysName, IPAddress

FROM Orion.Nodes

WHERE (NOT(IOSVersion = '') AND (Vendor LIKE '%Cisco%'))

GROUP BY MachineType, IOSVersion, SysName, IPAddress

ORDER BY MachineType, IOSVersion, IPAddress

Looks like your query is somehow trying to graph your IOS version on a time graph? Don't really understand it much, but more power to you if you can get it to work!!

osberg

Hi Craig,

Thanks for your reply here.

See here is the issue, you put the info into Excel, and that is not how to do it in my head

It would be the right way to have a option here in SW that you can do this. And would be great if someone with more skills to SQL could help me out here, so we can make this a feature in SW, I bet that I am not the only one there would like this function

osberg

Hi all,

Anybody here there might can help with the SQL part, so it dont look into a time graph etc.Hoping some great SQL sharks are in here