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
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
I didn’t Microsoft is so bad at WSUS….the issue was KB3159706 was recently installed on our SCCM WSUS Server…and everything broke after that… https://www.sepago.de/blog/2016/04/22/wsus-service-stopped-do-not-install-kb3148812-on-configuration-manager-or-wsus … Read more
Saw this issue when I logged into the WSUS database via management studio: SUSDB(Recovery Pending). When I checked SoftwareDistribution.log with my WSUS, then I realized that … Read more
We often got complaints from users that application catalog not working on chrome or Mac. Well, it didn’t! But people always ask about that…so I … Read more
Cisco IP Communicator has MSI file, but it needs command-line switches to finish the installation, otherwise it will prompt user to type in those information, … Read more
WSUS Server: C:\Program Files\Update Services\LogFiles\SoftwareDistribution.log SCCM: D:\Program Files\Microsoft Configuration Manager\Logs\WSUSCtrl.log and wsyncmr.log Client: C:\Windows\WindowsUpdate.log C:\Windows\CCM\WUAHandler.log C:\Windows\CCM\UpdateDeployment.og
When I tried to testing SCCM WSUS Software patching, and checked the WUAhandler.log, it showed “OnSearch Complete – Failed to end search job. Error = … Read more
We have some issues with our WSUS, so I uninstalled it under “Add roles and features” in Server Manager, but it always failed with post installation … Read more
Here is a powershell command for creating a SCCM deployment Start-CMApplicationDeployment -CollectionName “Collection Name” -Name “Softwarename” -DeployAction Install -DeployPurpose Available -UserNotification DisplayAll -AvaliableDate (Get-Date) … Read more