4fd81048-Brian / DirectRemove-SCVMHost

Script to manually remove an orphaned host or cluster from VMM
2 stars 2 forks source link

Left over entry in dbo.tbl_PMM_PhysicalMachine #1

Closed 4fd81048-Brian closed 3 years ago

4fd81048-Brian commented 3 years ago

Ran into errors adding the host back after deleting with the script.

Error (21201) Another machine with the same SMBIOS GUID is found.

Recommended Action An SMBIOS GUID should uniquely identify the machine. Provide the correct value or contact the machine manufacturer to help update the hardware with correct information.

-- Work around Find the UUID of the host:

C:>wmic csproduct get uuid UUID 4C4C4544-0053-3210-8059-C7C04F564E31

On the SQL Server in SQL Server Management Studio

select * from dbo.tbl_PMM_PhysicalMachine where SmBiosGuid = '4C4C4544-0053-3210-8059-C7C04F564E31'

Verified the entry was there, and then changed "select *" to "delete" and executed the query.

Now refreshing the host did not produce that error.

Reference: https://docs.microsoft.com/en-us/archive/blogs/nitinsingh/getting-error-another-machine-with-the-same-smbiosguid-is-found-while-adding-a-host-in-scvmm