Have you ever been in the situation where something unexpected happens on a users computer and people start pointing their fingers at the ConfigMgr admin and asking "has anyone deployed something with SCCM?" Well, I decided to write a PowerShell script to retrieve the execution history for ConfigMgr programs on a local or remote client. … Continue reading Get Program Execution History from a ConfigMgr Client with PowerShell
Category: Reporting
Get Previous and Scheduled Evaluation Times for ConfigMgr Compliance Baselines with PowerShell
I was testing a compliance baseline recently and wanted to verify if the schedule defined in the baseline deployment is actually honored on the client. I set the schedule to run every hour, but it was clear that it did not run every hour and that some randomization was being used. To review the most … Continue reading Get Previous and Scheduled Evaluation Times for ConfigMgr Compliance Baselines with PowerShell
HTML Report for SCCM Site Component Warnings and Errors
Just a quick one 🙂 If you're like me you are too lazy busy to regularly check the component status of an SCCM Site Server for any issues, so why not get PowerShell to do it for you? The code below will email an html-formatted report of any site components that are currently in an … Continue reading HTML Report for SCCM Site Component Warnings and Errors
Create Collections for SCCM Client Installation Failures by Error Code
Ok, so in a perfect SCCM world you would never have any SCCM client installation failures and this post would be totally unnecessary. But in the real world, you are very likely to have a number of systems that fail to install the SCCM client and the reasons can be many. To identify such systems, … Continue reading Create Collections for SCCM Client Installation Failures by Error Code
New Tool: Delivery Optimization Monitor
Delivery Optimization Monitor is a tool for viewing Delivery Optimization data on the local or a remote PC. It is based on the built-in Delivery Optimization UI in Windows 10/11 but allows you to view data graphically from remote computers as well. The tool uses the Delivery Optimization PowerShell cmdlets built in to Windows to … Continue reading New Tool: Delivery Optimization Monitor
Create Disk Usage Reports with PowerShell and WizTree
Recently I discovered a neat little utility called WizTree, which can be used to report on space used by files and folders on a drive. There are many utilities out there that can do that, but this one supports running on the command line which makes it very useful for scripting scenarios. It also works … Continue reading Create Disk Usage Reports with PowerShell and WizTree
PowerShell Template for HTML-Style Email Report with SQL Data
Long time since I wrote a blog - been uber busy - but found time to slip this one in! Working with ConfigMgr a lot I have a number of html-style email reports written in PowerShell that get data from the SCCM database and send it to me and other SCCM admins. Personally, I much … Continue reading PowerShell Template for HTML-Style Email Report with SQL Data
Getting Data from the Intune Data Warehouse with PowerShell
The Intune Data Warehouse is a great addition to the Microsoft Intune service allowing visibility of historical data for reporting, data and trend analysis for your Microsoft MDM environment. It comes with an OData feed that allows you to connect to the data with PowerBI, Microsoft’s reporting and data visualization service. The Data Warehouse RESTful API … Continue reading Getting Data from the Intune Data Warehouse with PowerShell
Query for 32-bit or 64-bit Versions of Microsoft Office with ConfigMgr
Quick post - I needed to query for 64-bit versions of Microsoft Office installed on our clients. Usually, the 32-bit version gets installed as this is Microsoft's recommendation due to add-in compatibility etc. But in some cases, the 64-bit version is required to take advantage of additional RAM. I couldn't find anything useful online to … Continue reading Query for 32-bit or 64-bit Versions of Microsoft Office with ConfigMgr
Inventory Local Administrator Privileges with PowerShell and ConfigMgr
Any security-conscious enterprise will want to have visibility of which users have local administrator privilege on any given system, and if you are an SCCM administrator then the job of gathering this information will likely be handed to you! However, this task may not be as simple as it seems. Gathering the membership of the … Continue reading Inventory Local Administrator Privileges with PowerShell and ConfigMgr