Report of new software installed for a period of time
Answers (2)
You can query from the database anything you want.
As an example you can use this report for the last 14 days (and modify it for your own needs)
SELECT DISTINCT NAME, VALUE1 AS 'Software Display Name', VALUE2 AS 'Software Version', TIME
FROM ASSET_HISTORY A
WHERE CHANGE_TYPE = 'DETECTED'
AND FIELD_NAME = 'SOFTWARE'
AND TIME > DATE_SUB(NOW(), INTERVAL 14 DAY)
ORDER BY NAME, VALUE1
I have a few examples of this type of report in my GitHub repository:
New versions of Java installed in the past day: https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/software%20-%20java%20new%20versions%20in%20past%20day.sql
Software installed on given computers in the past 20 days: https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/software%20installed%20on%20given%20computers%20in%20past%20days.sql
