IT Management Suite

 View Only
  • 1.  Computers Merged Report

    Posted Dec 16, 2014 05:19 PM

    Here is report that might come in handy if you ever wanted a report of Computers Merged.

    select
        c.Name ComputerResourceName
        ,bi.[Hardware Serial Number]
        ,m.DeprecatedResourceName
         ,m._eventTime as DateMerged
    from Evt_Asset_Merge_Event m
    join vComputer c on c.Guid = m.MergedResourceGuid
    left join Inv_AeX_AC_Identification bi on bi._ResourceGuid = c.Guid
    order by m._eventTime desc