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, … Read more
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 … Read more
Casper NetSUS Not Working on CentOS 7
I thought there is something wrong with my config, it turned out that the Casper NetSUS cannot config well with CentOS. modify /lib/systemd/system/tftp.service ExecStart=/usr/sbin/in.tftpd … Read more
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 … Read more
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 … Read more
How to find CORRECT pending reboot machines
https://blogs.technet.microsoft.com/smartinez/2014/06/27/reboot-pending-report-how-to-create-the-report/
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 … Read more
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_System AS SMS_R_System WHERE (Client0 IS NULL) AND (Operating_System_Name_and0 NOT LIKE N’%OS X%’) AND (Operating_System_Name_and0 LIKE N’%Microsoft Windows NT Workstation%’) ORDER … Read more
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, … Read more
WordPress Update Failed – Wp-admin Blank
When you tried to log in your wp-admin from your wordpress after a update, and you got “upgrade.php?_wp_http_referer=%2Fwp-admin%2F”. Here is the super fast easy fix: … Read more