I'd like to know what is the target of a resource merge before running the resource merge. Knowing will help create the liste of exclusions. I can easily determine the list using Resource Name as the merge key, but I'm interested in the Computer Name/Domain. Does anyone know the table which contains the Computer Name/Domain data? I'm guessing it is inv_aex_ac_identification. If that is the table, I think I can use the following to identify duplicates before running the rule.
SELECT c1.Guid, c1.Name, id1.*
FROM vRM_Computer_Item c1
JOIN Inv_AeX_AC_Identification id1 ON c1.Guid = id1._ResourceGuid
JOIN (SELECT id1.Domain, id1.Name
FROM Inv_AeX_AC_Identification id1
GROUP BY id1.Domain, id1.Name
HAVING COUNT(1) > 1) id2 ON id1.Domain = id2.Domain AND id1.Name = id2.Name
ORDER BY c1.Name