Please bear in mind that you have about 10 to 15 seconds to carry out this procedure before chrome may crash again . Seen in Google Chrome 108.0.5359.73,108.0.5359.94,108.0.5359.95
Continue reading…MEMCM – Scripts stuck at creating client jobs
Pretty much as it says really, I had this issue and was able to solve it with help from MS Premier Support. also covers Client Notifications not running and CMPivot not returning any live data.
MEMCM – Find Content Only Deployed Directly to a Distribution Point
So you want to remove a SCCM Distribution Point, but you are not sure if there is any content on there that is only distributed to it, rather that to the Distribution Point Group , do I have a SQL query for you!
Continue reading…CMPIVOT 101
CMPivot is a tool in MEMCM (SCCM) that is under-rated or misunderstood by people. Its power is amazing, due to the fact it can live query machines in a collection, that are online, but also where devices are offline, use last known information from the MEMCM database
It uses the Kusto Query Language, so if you are familiar with basic SQL queries you can use this cheatsheet here https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/sqlcheatsheet
If you are familiar with PowerShell then you recognise the Pipe operator | taking the output from one “cmdlet” and piping it to the next “cmdlet”
The following example shows how you can use two queries and join them and then only select the columns you want. So were are getting the Firmware information from each device where secureboot is false

then joining that information to the computersystem information

Then we are projecting the resultant object to only deliver 5 columns -device,Manufacturer,Model,Secureboot,UEFI.
Project is similar to SELECT in SQL or Select-Object in PowerSshell
Firmware | where SecureBoot == false | join (computersystem )| project device,Manufacturer,Model,Secureboot,UEFI
Here are some links on how to use the admin service to code these queries using powershell.
You can call CMPivot from the ConfigMgr Admin Service.
https://www.asquaredozen.com/2019/02/12/the-system-center-configuration-manager-adminservice-guide/
Here’s a post that goes into how you can query CMPivot over CMG. https://www.asquaredozen.com/2019/06/18/configmgr-1906-technical-preview-testing-cmpivot-over-cmg-using-adminservice/
Adam has a bunch of (somewhat working) scripts that you can see examples of usage for AdminService
https://github.com/AdamGrossTX/PowershellScripts/tree/master/ConfigMgr/AdminService
Enabling Flash Player after 12th January 2021
To enable flash you need to configure the flash player via a config file.
Continue reading…Powershell – Parameter switching on command line
So you want to have the parameters for your command line change depending on the parameters you select
MEMCM 1910 – Windows 7 ESU update causes Client to fail WARNING: Failed to evaluate Installed rule hr = 80041010
Rolling out the Windows 7 ESU went pretty well for the majority of the 3,000 Win7 Clients we had (ever decreasing with a Windows 10 rollout).
Suddenly in MEMCM 1910 (SCCM) I had an increase in non compliant Windows 7 devices and KB4575903 was not installing.
DHCP – Powershell – Migrate DHCP Scope Leases
This simple script shows you how to migrate a scopes leases from one DHCP server to another,disable the old scope and enable the new one Continue reading…
SCCM – Office 2016 updates install , but Windows 10 OS ones do not
You know how it is, Windows 7 is going EOL, you have had a bit of Windows 10 in play, starting at 1511 and upgraded last year to 1703 and you looking at rolling out 1809 and getting off Windows 7 before January 2020. You have thousands of Windows 7 devices and 50 – 100 Windows 10 mobile devices that you have been piloting with Windows 10, they are well less that the margin of error for devices with faulty Windows Update or SCCM Clients
So now your starting to roll out more devices and your finding that Windows Updates on Windows 10 is not working. Why?
SCCM – How do I Setup SCCM Properly for Windows Updates
Ok so how does the new dangled Dual Scan functions work. For what matter – how does Microsoft Updates work in Windows 10 1607 and higher??