Maintenance View - Device Stats - Cisco

I built a handful of "Maintenance - Device Stats" pages, each tweaked a tiny bit to accommodate the different vendors and where/how they like to store the device data. For these maintenance pages, each vendor has at least 3 different sections which our Engineers and Analysts can quickly  and easily search and sort to find the info they need.

The person planning the firmware upgrades can easily see how many different versions, and/or models, of equipment need to be upgraded, as well as uptimes, last login status, and most recent NCM config backup timestamps.

The attached SWQL query pertains to the (1) widget shown in the screenshot below. If you'd like to enable the search option, you will need to uncomment the search/where section at the end and paste it into the search area when editing the widget. Other than that, there is a custom property included (Area), which I have commented out. I figured I'd leave it in there in case anyone wanted to add more data, then they'd have a jumping off point to make things easier.

Widget (1) - Device Stats: You are here

Widget (2) - Device Model Counts: https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2909

Widget (3) - Device Model & Firmware Counts: https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2910

 

 

While I cannot remember where all the various pieces of this query originated, I do know it was from folks in this community, so I'll just credit THWACK. (Which is basically what I'll need to say for anything and everything I post...)

 

 

Thank you,

-Will

Anonymous