#SCCM
-
Feb 17, 2017
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" }...
-
Jan 24, 2017
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 Space, Free Space, Free Space Percent( All in...
-
Jan 20, 2017
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,...
-
Jan 6, 2017
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:...
-
Dec 16, 2016
SCCM WSUS Error 80072EE2
We started using SCCM WSUS for workstation patches, but I always saw half machines success with half machines waiting for updates. It was always the typical error 80072EE2. on the logs from WSUS, you...
-
Dec 9, 2016
How to find CORRECT pending reboot machines
https://blogs.technet.microsoft.com/smartinez/2014/06/27/reboot pending report how to create the report/
-
Dec 9, 2016
SCCM Reports - Software Update Status
This SCCM report is really a complicated one, I used lots of views to do the information I need, such as : AD Site, Machine Name, Last Logon User, Last Update Scan, Last Logon Timestamp, Update...
-
Dec 9, 2016
SCCM Reports - No SCCM agent workstation client
select all SMS\ R\ System.Name0,SMS\ R\ System.Last\ Logon\ Timestamp0,SMS\ R\ System.Resource\ Domain\ OR\ Workgr0,SMS\ R\ System.Client0,SMS\ R\ System.Operating\ System\ Name\ and0 from vSMS\ R\...
-
Dec 9, 2016
SCCM Reports - Last Hardware Scan Over 37 Days
I am working on SCCM reports a lot lately, here is the SQL statement for Last Hardware Scan Over 37 Days SELECT dbo.v\ R\ System.AD\ Site\ Name0, dbo.v\ R\ System.Name0, dbo.v\ R\ System.User\ Name0,...