slyaii

This is to add onto what Scott Schaaf mentioned. I wanted to share my experience in case people out there needs help. You can get a report that shows computers that might share the same GUID. I am using SCCM 1810. On the lower left, you will see "Monitoring". It's in between "Software Library" and "Administration" Now click on "Overview" then "Reporting". Click on "Reports". From the search area type in the word unique and search for it. You will see a report that is named "Computers that might share the same Configuration Manager Unique Identifier". Open that. That's is just the beginning, to completely give a unique SMS GUID, you need to do this. 1.Run the SQL 2.Stop SMS Agent Host service 3.Delete SMSCFG from C:\Windows 4.Delete the SMS Certificate 5.CCMSetup.exe /uninstall 6.CCMSetup.exe 1. Run the SQL Do this on the SQL server that SCCM is on. If you have multiple databases, select the SCCM database and do a "New Query" You run two queries. One query is to find the duplicate GUID based on the computer name. The second query is to delete the duplicate GUID based on the computer name. **I didn't write the queries and all credits goes to the person who wrote it** Run this query on the DB server. If you have dups, this will confirm it. Replace "ComputerName" with the problem device and execute. select * from System_DISC where Name0 like '%ComputerName%' In order to delete duplicate guids, run this. Replace "ComputerName" with the problem device. DECLARE @Name VARCHAR(25) SET @Name = 'ComputerName' DELETE FROM SYSTEM_DISC WHERE Name0 = @Name DELETE FROM ClientKeyData WHERE SMSID IN (SELECT SMS_Unique_Identifier0 FROM SYSTEM_DISC WHERE Name0 =@Name) DELETE FROM MachineIdGroupXRef WHERE MachineID IN (SELECT ItemKey FROM SYSTEM_DISC WHERE Name0 = @Name) DELETE FROM System_AUX_Info WHERE Netbios_Name0 = @Name DELETE FROM ImportedMachineIdentity WHERE ItemKey IN (SELECT ItemKey FROM SYSTEM_DISC WHERE Name0 = @Name) 2. Stop SMS Agent Host service Open a RUN command and type services.msc. Browse to SMS Agent Host and STOP the service. 3. Delete SMSCFG.ini from C:\Windows 4. Delete the SMS Certificate Open a RUN command and type MMC Go to File and select "Add/Remove Snap-in" Add the "Certificates" Click OK Radio check "Computer account" Clikc Next Radio check "Local Computer" Click Finish Click OK Scroll down to SMS >> Certificates. Delete the SMS Certificates 5. CCMSetup.exe /uninstall Open File Explorer and browse to C:\Windows\ccmsetup Open a command prompt and change directory cd C:\Windows\ccmsetup Type the following ccmsetup.exe /uninstall *Refresh your File Explorer and make sure that only two items exist. The two items are: Logs and ccmsetup.exe If you don’t see other items being deleted, make sure to run the command again and keep refreshing your File Explorer each time until you see the data being deleted. Remember, only two items should exist. Monitor the uninstallation of Configuration Manager from the Control Panel. Give it a few minutes and refresh the Control Panel. Make sure the Configuration Manager is gone. 6.CCMSetup.exe Make sure your File Explorer is still open. If not, browse to C:\Windows\ccmsetup Open a command prompt and change directory cd C:\Windows\ccmsetup Click Enter on your keyboard to move to the next line Type in the following and press Enter once done CCMSetup.exe *Monitor the C:\Windows\ccmsetup directory. You will start to see other items populating the directory. If you don’t, execute the command above again. You can view the SMSCFG.ini files to see the unique key in C:\Windows You can view in SCCM the status of the client. Give it a few minutes and it will turn green.