
simonclarke69 asked a question.
Auditing
I have been asked to Audit another Departments new install . Any tips on performing an holistic check and suggestions for optimisation of the service please ?

simonclarke69 asked a question.
I have been asked to Audit another Departments new install . Any tips on performing an holistic check and suggestions for optimisation of the service please ?
Need help finding an answer?
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 😃 ?