K1000 Report of Software installed by date
I am looking to create a report for all of my monitored PCs that will show me all new software installed on endpoints each day. I don't believe our K1000 environment has this report currently. Has anyone developed one already?
Community Chosen Answer
In 5.4 only. This will not show the exact time the software was installed, but it will show when a change occured based on the last inventory. Change the "1 DAY" to match what you need.
SELECT NAME, TIME, VALUE1 as Software, VALUE2 as Version FROM ASSET_HISTORY A WHERE FIELD_NAME = 'SOFTWARE' AND CHANGE_TYPE = 'DETECTED' AND TIME > DATE_SUB(NOW(), INTERVAL 1 DAY)
ORDER BY NAME