Duplicate mxguid's in SIM

[Tony Cresswell]

I have 2 servers which whenever I discover them they get the same mxguid in the SIM database. This means that they overwrite each other and only one ever exists in SIM. Strangely though, whichever one exists in SIM has the IP addresses of BOTH servers.
I've tried clearing out the entries from the devices table in the database but they always get discovered with the same mxguid.
Does anyone know of a SIM database checker or a resolutino to this problem?

Thanks

Tony Cresswell

[Peter Narkotsky_1]

I had that problem once long time ago and basically it took me tracing most of the relationships between tables inside SIM DB to clean that up. Unfortunately I didn't write down all the steps at that point.... but it is more then one table that you have to clean up in order to solve this. Sorry...

[Haridas]

If the server that you are adding have same GUID (Globally unique identifier) as in a existing device, then the ipaddress will be appended.

The most common cause is from using drive imaging software, such as Altiris. When imaging systems, a globally unique identifier is used by the Web Agents and HP Systems Insight Manager for identification purposes. On Windows systems, this problem can be avoided by deleting the registry key entry, HKEY_LOCAL_MACHINE\Software\Compaq\CIMAgent\GUID, from the registry before creating the image. For systems that have already been imaged, stop the foundation agents, remove the key, and restart the agents. A new discovery corrects the problem.

[Tony Cresswell]

I've actually found the problem, silly really but might catch someone (like me) out!

The 3 servers that were all overwriting each other in SIM were all DL380's and all (for some unknown reason) had their Serial Numbers set in the System Partition utility set to the same value!

SIM obviously saw them as the same server even though they had different names, ip addresses and DNS entries!

[Tony Cresswell]

See above fix