Tuesday, December 11, 2018

A Community Driven One-Stop-Shop for ConfigMgr Resources

/u/ExeqZ on Reddit posted a Google Document intended to serve as a community-driven, one-stop-shop for ConfigMgr resources. The SCCM Community is one of the most charitable in sharing knowledge, but there's just so much of it, having a one-stop-shop for all of these resources is a great idea, so I wanted to do my part in sharing the Doc wherever I can. I expect that this document will evolve over time, certainly it's in its early stages currently, but I look forward to its future!

Summary of Servers Built in the last month.

Here's a SQL query that I wrote which will provide a summary of servers that have been built in the last month. Our team uses this in a dashboard in our Cireson portal that provides an easy way to tell when we might need to raise some red flags.

It's one of the first SQL queries I've ever written, so if you have any feedback for me, please let me know below, or on twitter!