Hi,
I am a Network guy not a SQL-guy, so hopefully one of you guru's can help me out with creating a report, or preferably a chart that will display the percentage of devices running what we are considering the current or standard version of IOS vs the total number of devices. I have written 2 really basic queries based on some examples I have found on the board but thats about as far as I have got. I would like to combine these into a single query and then divide Nodes_On_Standard_IOS by All_Nodes to get the percentage.
Ideally I am looking to built a chart that could be displayed on a dash showing the current % of of complaint devices and show a trend line over time say we start at 30% and as upgrades are completed the chart would show a trend moving upwards as the percentage climbs. There will be many more models of switches and routers but to keep things simple I just included a couple in the example below.
Thanks in advance!
SELECT COUNT(NodeID) AS 'All_Nodes'
FROM Nodes
WHERE ( (Nodes.Vendor = 'Cisco' ))
SELECT COUNT(NodeID) AS 'Nodes_On_Standard_IOS'
FROM Nodes
WHERE ( (Nodes.Vendor = 'Cisco' ))
AND (MachineType LIKE 'Catalyst 3560X%' AND IOSVersion LIKE '15.2(4)E10%')
OR (MachineType LIKE 'Catalyst 37xx Stack' AND IOSVersion LIKE '15.2(4)E10%')