This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Report: Node count by Operating System

My boss is asking for a report that shows the number of nodes by operating system. I might be over-thinking this, but I just can't get the results that I need. Does anyone have a SWQL or SQL query already built that fits or is close to this criteria?

I'll keep working on it in the meantime.

Thanks!

Top Replies

Parents

0 neomatrix1217 over 3 years ago

Someone might be able to write this SWQL better but here you go this was done as a table in the dashboards
SELECT Count (n.MachineType) as [OS],n.MachineType
FROM Orion.Nodes n
Group by MachineType
Cancel
Vote Up +1 Vote Down

Cancel
0 astayton over 1 year ago in reply to neomatrix1217

This looks great, but is there also a way to do this for a specific City, Datacenter or Group?
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 astayton over 1 year ago in reply to neomatrix1217

This looks great, but is there also a way to do this for a specific City, Datacenter or Group?
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data