[SQL] Servers Built in the Last 30 Days

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.


© 2019. All rights reserved.

Powered by Hydejack v8.5.2