Notes from the Field: Some Windows 10 are not Reporting to SCCM Server

Problem:

Windows 10 Desktops & Laptops that was re-imaged through SCCM OSD were not receiving all the Required applications and updates even after countless running of the M.U.A.S.S in the Configuration Manager Properties.

Troubleshooting steps:

You can see that the clients are active however they are not present / or are not being seen by SCCM even after doing the following :

• Uninstall / Re-install SCCM Client
• Run CCMRepair
• Even re-imaging the machine again

Looking into the Database

That’s where it gets interesting, for some reason these affected Windows 10 machines are having multiple entries in the database. Below is the actual screenshot of one client having 5 GUIDS

Resolution

It was needed to remove those client from the different tables, in order to do that we need to run the the following from the SQL Query where Hostname is the Windows 10 client’s hostname (e.g., CLT0001) that is having multiple entries in the database.

DECLARE @Hostname VARCHAR(50)

SET @Name = ‘Hostname’

DELETE FROM SYSTEM_DISC WHERE Name0 = @Hostname

DELETE FROM ClientKeyData WHERE SMSID IN (SELECT SMS_Unique_Identifier0 FROM SYSTEM_DISC WHERE Name0 =@Hostname )

DELETE FROM MachineIdGroupXRef WHERE MachineID IN (SELECT ItemKey FROM SYSTEM_DISC WHERE Name0 = @Hostname )

DELETE FROM System_AUX_Info WHERE Netbios_Name0 = @Hostname

DELETE FROM ImportedMachineIdentity WHERE ItemKey IN (SELECT ItemKey FROM SYSTEM_DISC WHERE Name0 = @Hostname )

Repeat same steps for the rest of the affected Windows 10 machines. These machines will automatically report back in SCCM in a few minutes, but you can also force it by running M.U.A.S.S.

Here’s a simulation from my lab:

After deleting CLT01 from the database it will also be removed from SCCM

After a while CLT01 shows up

In CLT01 is forced to report back to SCCM

As a result it appeared back in the console.