Asset Management Suite

 View Only
  • 1.  Target of a Resource Merge

    Posted Jun 10, 2013 04:15 PM

    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

     

     



  • 2.  RE: Target of a Resource Merge
    Best Answer

    Posted Jun 11, 2013 04:50 PM

    After testing I think the Domain and Name fields from inv_aex_ac_identification are used to merge computers when selecting Computer Name/Domain Merge Key.  The above query displays what will be merged.