I'm going to show you how to use SQL Server Management Studio to get data from Configuration Manager. I want to thank Adam Cook and Adam Gross who both gave me the encouragement to finally put this together. For best SQL readability, make sure you're watching in HD.

The following short and sweet snippet of PowerShell will extract the list of admins from your SCCM environment and then get their email addresses. At the end, you can dump $email into a text file, or perhaps set it to your clipboard to paste into Outlook. 1# Script assumes you have CM Module Loaded 2# Script assumes …

I've written the following three PowerShell functions to build a mapping of Office 365 ProPlus version numbers (e.g. 16.0.10205.2009) to more reportable build numbers (e.g. 1806). I've created the following three functions to start: Get-Office365BuildToVersionMap Get-OfficeBuildListToCase Get-OfficeBuildListToSQLTable …

When it comes to data in SCCM, there is no shortage of what you can get access to, but where exactly do you find it? Below I'll outline three methods I've used in the past. First, the TechNet documentation. I'm going to be honest, I haven't actually looked here in quite some time. It's available, but since I've been …

I created the follow SQL query to create a batch file that uninstalls all known versions of a piece of software. Feel free to use and tweak as you see fit. You should build the query first to make sure you're only identifying the GUIDs for software you really want to uninstall. You'll need to setup SSMS to output as …

The following SQL should help identify the state of impacted systems. Please review thoroughly before relying on this information, while I believe the results should be accurate, you should do your own due diligence. Please let me know if you find any errors or have any suggestions to return better data. More …

The following query will allow you to search the view v_R_user in the Microsoft Configuration Manager database so that you can identify a manager and then find everyone who works for that manager all the way down the tree. I've found this useful in the past for joining with other information in the database to identify …

I recently wrote the following SQL Query to help identify which browsers are installed across our environment. A straight Add/Remove Programs (v_AddRemovePrograms) query didn't really return the data in such a way that made it easy to determine major version of Firefox or Chrome, and doesn't include Internet Explorer …

I wrote the following queries to find the video resolutions used by clients reporting into SCCM. They currently only look at Windows Workstations 6.x (excludes servers, and also anything older than Windows Vista or whatever v7 ends up being), and only those who have submitted a hardware inventory in the last 30 days. …