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.
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.