This morning I saw an interesting tweet from Sandy Zeng with a Log Analytics workbook she'd created for W10 feature updates based on Update Compliance data. I'd been meaning to create a similar report for that myself in PowerBI for some time, so I took inspiration from her tweet and got to work on something! … Continue reading PowerBI Reports for Windows 10 Feature Update Compliance
Category: Software Updates
Creating ADR Deployments in SCCM with PowerShell
Today I needed to create a number of deployments for Software Update Automatic Deployment Rules in SCCM, so I turned to PowerShell and used the New-CMAutoDeploymentRuleDeployment cmdlet available in the ConfigurationManager module. It works well enough, however there are a couple of options that the cmdlet cannot set, namely: If software updates are not available … Continue reading Creating ADR Deployments in SCCM with PowerShell
ConfigMgr OS Upgrade TS W10 1709 Does Not Care About Windows Edition
Today I ran a ConfigMgr OS Upgrade task sequence configured to use the Enterprise edition of Windows 10 1709 on a workstation that had Windows 10 Pro 1703 installed. Since the VLC media for 1709 contains the various editions in different indexes, you are supposed to choose the relevant one in the Upgrade Operating System … Continue reading ConfigMgr OS Upgrade TS W10 1709 Does Not Care About Windows Edition
Find the Compliance State for Software Updates on Remote Computers with PowerShell
Since the recent WannaCrypt ransomware attacks, many organisations have wanted to get the patch status of their systems to see if they are protected. Several reports and SQL queries for ConfigMgr were quickly posted online to help enterprises identify at-risk machines. But what for those who don't use ConfigMgr, or what if you want to … Continue reading Find the Compliance State for Software Updates on Remote Computers with PowerShell
Parse the WindowsUpdate.log on Local and Remote Computers with PowerShell
The WindowsUpdate.log, which logs activities of the Windows Update client, is not the easiest of log files to parse through but it's handy one for finding details about update installation successes and failures. To make searching this log file easier both on the local computer, a remote computer (where PS remoting is enabled) or groups of computers, I … Continue reading Parse the WindowsUpdate.log on Local and Remote Computers with PowerShell
Calculate the Size of Multiple Packages in ConfigMgr with PowerShell
Have you ever wanted to select a group of applications or packages in ConfigMgr and find out the total size of the content files for all those packages? Or maybe you have your packages organised into folders in the ConfigMgr console, and you want to find out the total content size of all the packages … Continue reading Calculate the Size of Multiple Packages in ConfigMgr with PowerShell
WSUS Database Maintenance for SQL Express
To perform database maintenance (defragmentation, re-indexing) on a WSUS database that is installed using SQL Express, I use the following solution. Because SQL Express has no SQL Server Agent, you cannot create jobs or maintenance plans, but we can use Powershell with a Scheduled Task to perform regular maintenance. I am using SQL Express 2012. Download … Continue reading WSUS Database Maintenance for SQL Express
WSUS Server Cleanup Report
There are a few scripts out there that will perform a cleanup of your WSUS server/s, but here's my contribution 🙂 It uses the Invoke-WSUSServerCleanup cmdlet only available in Windows Server 2012 / Windows 8 onwards, so for previous versions try something like Kaido Järvemets' script. This script will perform the WSUS cleanup for any … Continue reading WSUS Server Cleanup Report
Deploying KB3025945 Using the ConfigMgr Package Model
We recently had some reports of IE9 crashing after installing a MS patch KB3008923 released December 9th, 2014. A few days ago on January 22nd, 2015 MS released an update that fixes the issue, KB3025945. Unfortunately at the time of writing, the update is not available on WSUS, so it must be manually downloaded and deployed. I decided … Continue reading Deploying KB3025945 Using the ConfigMgr Package Model
Dealing with ‘multiple-reboot’ patches during OSD
If you are incorporating some patching process during your OS Deployments, you've undoubtedly come across the issue where some patches released by Microsoft cause multiple reboots. These additional reboots are unhandled by the task sequence, which causes it to quit with little explanation. This is documented in the following MS KB article, where MS also maintains … Continue reading Dealing with ‘multiple-reboot’ patches during OSD