Web-based Server Usage Report
Based almost entirely on the Server Usage - Avg, Total, Peak - Mem and CPU Load ReportWriter Report by km96svt
KMSigma, Any chance we can get this exported into a .xls file. My Asset Management folks like the report and have requested an excel format.
Don't you have this option?
Thanks for providing the Web Report Version. I didn't realize I could do it in SWQL.
No worries - thanks for the original report. I've been trying to re-write any Legacy Reports that I find that are interesting as they come along. :-)
I see it. Thanks,
Since the developers are not helping us with better reporting I appreciate you guys stepping up to the plate!!!
How can I change this report to use a certain date range? I'd like a report show all of these: weeks, months, two months.
Also, how can I run this for a small subset of servers?
Change the WHERE clause to read: "WHERE [CPU].DateTime >= GETUTCDATE() - 30" for the last 30 days or "WHERE [CPU].DateTime >= GETUTCDATE() - 7" for the last 7 days.
If you want to change which devices, you can also add that to the WHERE clause. Example: "WHERE [CPU].DateTime >= GETUTCDATE() - 30 AND Caption LIKE 'EAST%'" to show the last 30 days and only devices that start with "EAST"
how do i filter by specific date or specific timeframe if needed? thx
To filter for a SPECIFIC time (January of 2020) you would use [CPU].DateTime >= '01/01/2020' AND [CPU].DateTime < '02/01/2020'
The above example [GETUTCDATE() - 30] shows the last 30 days (today (UTC date) "minus" 30 days).
Addendum: You can also add "times" to the comparisons [CPU].DateTime >= '01/01/2020 09:00:00' AND [CPU].DateTime < '01/01/2020 17:00:00' (Between 9 AM and 5 PM on January 1.)
