Inspired by this post on TechNet and trying to help out someone on the WinAdmins Discord, I took a bit of a dive into the v_Update_ComplianceStatus view and how it compares to v_Update_ComplianceStatusAll. The v_Update_ComplianceStatus & v_UpdateComplianceStatus Views I cover these views together because they are the …

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.

Quick post today because I couldn't find this error anywhere online. I'm running Configuration Manager 2002 and was exporting an application and was getting this error thrown in Powershell: Export-CMApplication : The specified server cannot perform the requested operation. After some digging around, I realized it was …

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 wrote the following script to inventory the administrative users of my Configuration Manager (SCCM) environment as they relate to Active Directory. The end result is a list of users who no longer exist in Active Directory, users who are in Active Directory but disabled, and users who are granted rights in multiple …

A recently had a requirement to bundle a number of applications together into a few different task sequences to make available to a user collection. After a bit of research, I discovered that this is a pretty common question, and that there is no built-in method to make this available. Below, I'll walk through how I …

If you're trying to automate the deployment of the SCCM Console through Configuration Manager, you may find that running it quietly throws something like this in AppEnforce.log: Process 9976 terminated with exitcode: 6 For some reason, Microsoft has decided not to define a default installation path when running the …

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 wrote the following function to rerun an advertisement on a remote client computer using either the AdvertisementID or the PackageID. Like all sample code found online, please run through a test environment first, and use at your own risk! 1<# 2 …

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 …