SCCM Archives - Page 3 of 12

SCCM Query for Browsers

August 28, 2020 by me

Here are my SCCM queries for all the browsers. Firefox SCCM Query Chrome SCCM Query: Edge Legacy: Edge Chromium IE For IE it is a … Read more

Automated Patching for Amazon Workspaces via SCCM and Powershell – Day 1

September 30, 2019 by me

Do you have hundreds of Amazon Workspaces to patch monthly? and you are so tired of manually power them on to patch, and only reboot … Read more

How to Find Out If SCCM Rebooted Your Machine?

June 6, 2019 by me

Open event viewer, “Windows Logs” – “System”, and filter your logs with event ID 1074.

DNS Management Tool Missing in RSAT Windows 10 1809 – SCCM Package

May 13, 2019 by me

If you upgraded to Windows 10 1809, and re-installed RSAT, but the DNS Management tool is missing from RSAT, you can use this Powershell Script … Read more

SCCM Shockwave Uninstaller

April 29, 2019 by me

Here is my script to uninstall shockwave 12.2 and 12.3. Haven’t tested on other versions though: # Shockwave Uninstaller # Rui Qiu # 4/29/2019 #Check … Read more

Powershell Script to Find Primary User from McAFee ePo and Feed Data into SCCM Device Affinity

November 26, 2018 by me

Here is my powershell script to get primary user data from McAfee ePo database, then use Add-CMUserAffinityToDevice to import them into SCCM, and remove any … Read more

SCCM Report for User Device Affinity

April 29, 2021October 29, 2018 by me

Updated: Here is a better sccm query for creating a device collection based on primary users: https://adminsccm.com/2018/10/07/creating-device-collections-based-on-users-and-vice-versa/ SELECT SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client, … Read more

+ More

SCCM