What’s New In Config Manager 1806?

The latest update for Configuration Manager current branch is now available as an in-console update. You can update to 1806 on sites that currently run version 1706, 1710, or 1802. Microsoft have released a summary of the additions in the following article which includes Site Infrastructure changes, Content and Client Management updates, Compliance Settings, Application and OS Management along with a whole list of others. CLICK HERE I hope you find it useful.      

Read More

Monitoring A Test Task Sequence

A great way to monitor a new task sequence is by using a custom Status Message query which grabs all the exit codes from every step of the TS and reports them out to the console. All you need is the following query and the Deployment ID for your task sequence. select  SMS_StatusMessage.*,   SMS_StatMsgInsStrings.*,   SMS_StatMsgAttributes.*,   SMS_StatMsgAttributes.AttributeTime   from SMS_StatusMessage   left join SMS_StatMsgInsStrings   on SMS_StatMsgInsStrings.RecordID = SMS_StatusMessage.RecordID   left join SMS_StatMsgAttributes   on SMS_StatMsgAttributes.RecordID = SMS_StatusMessage.RecordID   where SMS_StatMsgAttributes.AttributeID = 401 and SMS_StatMsgAttributes.AttributeValue = “ABC20001” and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by SMS_StatMsgAttributes.AttributeTime DESC Create a new Status Message Query from the Monitoring tab as follows. Give the query a new name, eg,…

Read More

Windows 10 In-place Upgrade Fails with 0xC1900208

This error appeared during the first phase of an in-place upgrade from Windows 8.1 to Windows 10.  The error refers to the Windows 10 setup.exe exit code and was found in the smsts.log file. Windows Setup failed with hexadecimal exit code 0xC1900208 (decimal 3247440392) According to Prajwal’s article on this error, the cause could be an incompatible app installed on the old operating system.  The approach to check this is to mount the Windows 10 ISO in Windows 8.1 for example, and run a custom setup command.  I tried the…

Read More

SCCM Peer Cache Slows Down OSD Build

After suffering a great deal of pain with slow OSD today, I have found a particular Client Setting to be the culprit! In Client Settings > Client Cache Settings, using “Enable Configuration Manager client in full OS to share content” seems like a great idea – but it actually kicks in during OSD! When the Task Sequence is in Windows (i.e. rebooted from WinPE) the device being built will search for content on other clients and make it SUPER SLOW!! This article has a bit more database type detail (https://sccmisevil.wordpress.com/2017/07/31/the-strange-case-of-peer-cache-not-getting-disabled/)…

Read More

DISM : Misc. WIM Management Commands

DISM.exe (Deployment Image Servicing and Management) is a command-line tool that can be used to service a Windows image or to prepare a Windows Preinstallation Environment (Windows PE) image.  DISM can be used to service a Windows image (.wim) or a virtual hard disk (.vhd or .vhdx). Clean old mountpoints • Dism /cleanup-wim Mount-Image • Dism /Mount-Image /ImageFile:C:\DISM\myimage.wim /index:1 /MountDir:C:\DISM\offline Add-Package • Dism /Add-Package /Image:C:\test\offline\Windows /PackagePath:C:\MSU\Windows10-KBxxxxxxx-x64.msu /LogPath:AddPackage.log Add Driver • DISM /Image:C:\test\offline /Add-Driver /Driver:C:\test\PS2x64 /recurse • DISM /Image:C:\test\offline /Add-Driver /Driver:C:\test\PS2x64\.inf Unmount-Image • Dism /unmount-image /mountdir:c:\test\offline /commit Enable Windows Feature •…

Read More

SQL Query : All Win10 Machines with User Details / OS Ver / OS LangID

Use this query to list all Windows 10 devices including the user, the OS version and the OS language ID. SELECT DISTINCT dbo.v_R_System.Name0 AS MachineName,     dbo.v_R_System.User_Domain0 AS UserDomain,     dbo.v_R_System.User_Name0 AS UserName,     dbo.vSMS_R_System.operatingSystemVersion0 AS OSVersion,     dbo.v_GS_OPERATING_SYSTEM.OSLanguage0 FROM dbo.v_R_System     INNER JOIN dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID     INNER JOIN dbo.v_GS_OPERATING_SYSTEM on dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID     INNER JOIN dbo.vSMS_R_System ON dbo.v_R_System.Name0 = dbo.vSMS_R_System.Name0 WHERE vSMS_R_System.Operating_System_Name_and0 like ‘%Workstation 10%’ order by v_R_System.Name0 Sample Output

Read More

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