Fix WPAD Vulnerability by Changing Host File with SCCM
It was a bit more diffcult than I thought, originally I was using compliance settings, but then it didn’t work so well. So I go … Read more
SCCM
Rapid7 Insight Agent Update Fix Discover Script
# Rapid7 Insight Agent Update Fix Discover Script # Rui Qiu # v1.1 # 4/3/2018 $folder = “C:\Program Files\Rapid7\Endpoint Agent” if (test-path $folder) { $content … Read more
Issues Installing Shavlik (Ivanti Patch)
I didn’t realize a simple issue can cause a big issue with Shavlik: When launching the installer from Shavlik, you have to “Unblock” the file … Read more
How to Set up SCCM SSRS Email Notification
First go to your SQL Reporting server, and launch “Reporting Services Configuration Manager”: It is best to use an internal SMTP server. And once you … Read more
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 … Read more
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 … Read more
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
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
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 … Read more
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 usage … Read more