Is there a way to sort devices by IOS?

swamplife

I know there are reports that will allow you to find out what IOS is on a device. What I would like to know is, if there is a way to sort devices just by IOS? I would like to know what IOS is out there and how many devices its on. Possibly a widget, something similar to "End of support devices" or "Total nodes by type" widget.

kwimmer

You can certainly sort Nodes by IOS Version.

SELECT NodeID, IPAddress, Caption, Description, NodeDescription, SysName, Vendor, IOSImage, IOSVersion, MachineType, IP, DetailsUrl, DisplayName, Uri

FROM Orion.Nodes

WHERE vendor = 'Cisco'

Order BY IOSVersion