SQL Query : All Computers Missing a Specific KB Update

If you identify a software update which has been applied to a limited number of your devices, this query can be used to identify those where the KB is missing. select sys.name0 [Computername], osd.OSLanguage00 [OS Language], osd.Caption00 [OS Name] from v_updateinfo ui inner join v_UpdateComplianceStatus ucs on ucs.ci_id=ui.ci_id join v_CICategories_All catall2 on catall2.CI_ID=UCS.CI_ID join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID and catinfo2.CategoryTypeName=’UpdateClassification’ join v_R_System sys on sys.resourceid=ucs.resourceid join Operating_System_DATA osd on sys.ResourceID = osd.MachineID and ucs.status=’2′ — required AND ui.articleid=’3012973′ order by sys.name0 Sample Output  

Read More

SQL Query : Systems With Hardware Scan > 60 Days ago

You can identify devices which have not checked in for some time, or those with potentially faulty SCCM clients using this query.  SELECT a.ResourceID, a.Netbios_name0, b.LastHWScan FROM v_R_System a INNER JOIN v_GS_WORKSTATION_STATUS b ON a.ResourceID = b.ResourceID WHERE b.LastHWScan <= Dateadd(day, -60, getdate()) order by LastHWScan desc Sample Output    

Read More

MDT : OSD Error Messages

These are just a few of the error messages I’ve seen during the MDT boot phase of OS build. 0x80040005 Error retrieving policy (check for expired cert on boot media or retry) 0x80070490 Unable to find disk partition to write to – clean disk with diskpart 0x8007000F Failed to prepare the system partition for staging – wrong build media? 0x80070005 Check date and time 0x80070035 Network path not found 0x80070057 Set variable for format and partition disk to OSDisk 0x80280803 TPM not enabled 0x80072EE7 Unknown host (network?) 0x80091007 downloaded package…

Read More

WMI : Useful WMIC Queries

The wmic command can be used to interrogate the local WMI repository.  The following queries return hardware related information. Check total RAM wmic MEMORYCHIP get BankLabel,DeviceLocator,Capacity,Tag Check computer model / service tag Wmic csproduct list /format Check CPU Wmic cpu get name There are many other parameters for this command listed here … https://ss64.com/nt/wmic.html  

Read More

MDT : MDT Log Files

The log save locations move around depending on what stage of the OS build we are looking at.  This is a breakdown of the log locations during a MDT install task sequence: 1. Before the Image is applied to the machine: X:\MININT\SMSOSD\OSDLOGS 2. After the system drive has been formatted: C:\MININT\SMSOSD\OSDLOGS 3. After Deployment: %WINDIR%\TEMP\DeploymentLogs The logs of most interest for troubleshooting a failed install will be: BDD.LOG – This is an aggregated log of all the MDT Logs. SMSTS.LOG – This log would be used to troubleshoot Task Sequence…

Read More

SCCM 2012 : Software Updates Process

This is a high-level view of the Windows Update process from a ConfigMgr clients view utilizing a SUP (Software Update Point). The Software Update process from the ConfigMgr client After refreshing machine policy, kick off the Software Update Scan. We can then see the Software Update Scan Cycle has started via the WUAHandler.log (C:\Windows\CCM\Logs\WUAHandler.log) The Windows Update Handler initiates the Windows Update service against the ConfigMgr SUP. (C:\Windows\WindowsUpdate.log) After the scan is completed, we then run the Software Update Deployment Evaluation Cycle. Use the UpdatesDeployment.log to view this process (C:\Windows\CCM\Logs\UpdatesDeployment.log)…

Read More