K1000 - Software Change Report?
I'm basically trying to create a report view of what I see when I drill into the Software-->Installed Programs and click "Show changes". It shows me when new software was detected and the date it was detected at. I've gotten so close with the OBJECT_HISTORY table, but my dates don't sync. Has anyone written a report to accomplish this?
Answer Chosen by the Author
This is the report that I use:
JOIN ASSET ON ASSET.ID = ASSET_HISTORY.ASSET_ID
JOIN MACHINE ON ASSET.NAME = MACHINE.BIOS_SERIAL_NUMBER
WHERE CHANGE_TYPE = "Detected"
AND FIELD_NAME = "SOFTWARE"
AND DATE(ASSET_HISTORY.TIME)> DATE_SUB(NOW(), INTERVAL 30 day)
AND MACHINE.NAME = 'steelc'
This will show software changes for the past 30 days for the given machine (mine in this case).
Answered 10/19/2015 by: chucksteel
Please log in to comment
log in to commentPlease