SCCM a simple but yet very complex solution. It can be very confusing time to time.

A issue has been reported to me and asked for help. Basically Client stopped reporting back to SCCM Server after the power outage and dirty shutdown of servers.

Client is active but not reporting to SCCM Server.

As per usual I checked all log files, client getting AD site, finding MP fine, Telnet to SCCM ok and lot more troubleshooting steps. Even tried WMI repair and client uninstalls and installs again. Nothing worked until the solution below:

1. Uninstall the Client cleanly
2. Remove Client Details from SQL DB itself – Query provided below
3. Wait 15 Minutes
4. Install Client Again
5. Wait 30 minutes
6. Do SCCM Client Repair or Re-install again
7. Wait another 10 minutes
8. Perform Machine Policy, User Policy and Inventory cycles to confirm.

Now you should have working client again

——————————————————————————————————————————

Uninstall the SCCM Client via following command line:

cd c:\windows\ccmsetup

ccmsetup.exe /uninstall

To Fully uninstall the Client including the WMI repair, I used the following script:

Remove SCCM Client

or perform following steps manually.

1. CCMSetup /uninstall
2. Remove c:\windows\ccm directory
3. Remove c:\windows\ccmsetup directory
4. Remove c:\windows\ccmcache directory
5. Remove c:\windows\smscfg.ini
6. Remove c:\windows\sms*.mif (if present)
7. Delete Registry Key – HKLM\software\Microsoft\ccm registry keys
8. Delete Registry Key – HKLM\software\Microsoft\CCMSETUP registry keys
9. Delete Registry Key – HKLM\software\Microsoft\SMS registry keys

To delete duplicate GUID’s, use below SQL commands.

Note: Replace “ServerName” with your Server.

SELECT * FROM System_DISC WHERE [Name0] like ‘%ServerName%’

DECLARE @ServerName VARCHAR(50)

SET @Name = ‘ServerName’

DELETE FROM SYSTEM_DISC WHERE Name0 = @ServerName

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

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

DELETE FROM System_AUX_Info WHERE Netbios_Name0 = @ServerName

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