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
SCCM
93 posts
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,…
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 by SCCM: here is my…
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. …
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…
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.…
SCCM Compliance Rule for Finding Process Running
Here is my powershell script for finding if a  process is running with SCCM compliance rule. $process = Get-Process Process-name-xxx -ErrorAction SilentlyContinue if ($process) { Write-Host “Running” } else {Write-Host “Not…
SCCM Report for Disk Free Space Under 20%
Here is the SQL Â statement for my SCCM Report on disk free space under 20%, it will display the user machine AD Site, PC Name, Last Logon User, Total Disk…
SCCM Report – Software Metering Report for Last Usage Over 30 Days Ago
Here is my SQL Statement for SCCM Report – Software Metering Report for Last Usage Over 30 Days Ago SELECT DISTINCT TOP (100) PERCENT RV.AD_Site_Name0, v_R_User_1.description0, RV.Netbios_Name0, RV.User_Name0, MAX(MUS.LastUsage)…
SCCM Troubleshooting Guide
Here are some useful articles for SCCM troubleshooting: SCCM Issues by Category: http://arnavsharma.net/system-centre–more/basic-sccm-troubleshooting-made-easy PXE Boot: http://blog.jocha.se/tech/sccm-2012-troubleshooting-pxe How to read SCCM log files: https://www.swc.com/blog/microsoft-system-center/sccm-troubleshooting-101-log-files SCCM basic errors: https://prajwaldesai.com/sccm/sccm-troubleshooting/ SCCM log…