At times, a computer name may need to be reused on the same computer or another computer. This type of automatic merge can have several implications.
ITMS 8.x
In versions of ITMS greater than 7.x, there is a core automatic process, which cannot be disabled, that will merge two computers that have the same name.domain, FQDN or MAC Address, which are considered Resource Type Merge Keys. The process takes place when the new computer name is introduced into the SMP and the Guid of the original computer will take precedence, and the new computer will not receive a new Guid but instead inherit the existing Guid.
Since the automatic merge cannot be disabled, there are two possible options. One is best practice when possible and the other is a workaround.
Note 1: If this is a Hierarchy, please run the updated Stored Procedure on all SMP databases. The status would need to be changed at the Child SMP level. Since best practice states that Asset Management should not be installed on a Child SMP, the only Status' to choose from would be "Active" and "Retired".
Note 2: For all duplicate computers, it is recommended to review the "Computers with Duplicate Name" report often to determine if there are any duplicate computers that should actually be merged due to a computer reimage/rebuild.