[SQL] Servers Built in the Last 30 Days
in code on Code, Sql, Query
This SQL query, when ran against your ConfigMgr Database, will summarize all server objects built in the last 30 days.
I wrote this SQL query to present a summary of server objects that were built in the last 30 days. We use this in a dashboard that allows us to easily determine hardware capacity consumption over a rolling period of time.
The SQL Query
Here’s the gist on github; this is one of the first SQL queries I’ve ever written, so I would love feedback on it! You can always reach me @tstolswo on Twitter.
What Next?
My plan is to get into SSRS and turn this into a worthwhile report at some point – the meat and potatoes are done, I just need to make it look pretty.
