Loading
  • Hi Simon,

    As a first step: Use SQL for joining the inventory (device) information with their history information.

     

    SELECT 

     device.ComputerName

    , corpunit.path      AS  CorporateUnit

    , history.NewValue    AS  ApplicationInstalled

    , history.OldValue    AS  ApplicationUninstalled

    , history.HistoryDate

    FROM [ComplianceComputer] device

    JOIN [ComplianceHistory] history

    ON history.ComplianceComputerID = device.ComplianceComputerID

    LEFT JOIN [GroupEx]    corpunit

    ON corpunit.GroupTypeID = 2

      AND corpunit.GroupExID  = device.BusinessUnitID

    WHERE

       FieldName = 'SoftwareApplication'

     

    Expose the results of this query as a report in the FNMS UI, and group or filter by department (CorporateUnit).

    Hope this helps 😃 ?

    Expand Post

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


Loading
Auditing