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.
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
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.
The command SELECT * FROM System_DISC WHERE [Name0] like ‘%ServerName%’ is giving me an error Invalid object name ‘System_DISC’
Any idea why this is not working for me as it is for you?