#SCCM
-
Mar 15, 2018
SCCM WSUS Update Failed with 0x80244022
When I checked the error code, it said HTTP error 503 from WUAHandler.log, it turned out that the Wsuspool was stopped in IIS, and I have to changed the "Private Memory Limit" to 4194304....
-
Jun 28, 2017
SCCM SQL Report for All Office Users
Here is the sccm sql report statement to finding out all office users, I have used "Microsoft Office Professional" as the keyword, you can change to any software title you want :) SELECT DISTINCT TOP...
-
Jun 23, 2017
SCCM Package for Tableau & Tableau Reader
Installation command line: TableauReader 64bit 10 3 1.exe /quiet /norestart AUTOUPDATE=0 ACCEPTEULA=1 Detection method: File exist and version equal: C:\Program Files\Tableau\Tableau Reader 10.3\bin
-
May 18, 2017
Cannot Install SCCM client - Setup was unable to compile Sql CE
It turns out the solution is easy : Just delete everything under C:\Windows\CCM
-
May 12, 2017
Another way to check Update Installed via Powershell
I have to check if machine has MS March update installed, and SCCM cannot make my job simpler :( So I created a new compliance rule to check the result, here is the code: $error.clear() try {...
-
Apr 5, 2017
More Accurate SCCM Software Metering Report
I found out that the sccm table view v\ MonthlyUsageSummary is not really accurate, actually v\ GS\ CCM\ RECENTLY\ USED\ APPS.LastUsedTime0 is the best accurate one to determine user's application...
-
Mar 31, 2017
My Automated Powershell Script for SCCM Patching Process
we are slowing moving every machine to SCCM patching lately, and I have to move 100 machines each week, so I created this automated powershell script to run weekly. 1.My first script is to move...
-
Mar 31, 2017
SCCM Visio / Project Uninstaller Package
It was such a pain to create a sccm visio/project package for this ! I tried a few different ways of msi uninstall via the product code, all failed. then I started using the setup /uninstall ,...
-
Feb 17, 2017
Find A File with Random Characters and Send Email by SCCM Compliance Rule
Here is my Powershell script for Finding a file with random characters in the end, if the system find the file, it will email to our alert mailbox as well. This is done by SCCM Compliance Rule: File...