Comments
-
The report builder allows you to choose which servers you want to include. As for the SQL query i couldn't tell you without seeing your setup, but it would likely just be another line to the WHERE statement.
-
The report manager gives you built in charts and gauges to build a report. I just used that. Reports > All Reports > Report Manager > Create New Report Add Content > Charts > Average CPU Load Add Content > Gauges > Average CPU Load & Memory Utilization – Pie Gauges Then I added my own table content and pasted in the SQL…
-
This fixed my issue. Thank you!
-
Works as advertised, many thanks!
-
What I ended up doing was first creating the CPU / Memory portion of the report using the Gauges and Charts they provide in the custom report builder. Then added my own Custom Table [SQL Query] at the bottom to handle the Disk/Volume information. Its working nicely. SELECT N.NodeID AS 'Node ID' ,N.Caption AS 'Server Name'…