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?
1 Comment
[ + ] Show comment
-
Thank you for sharing this. This query does work. One thing I have noticed is that software I've deployed with KACE (using distribution) does not appear to write changes to the Asset_History table as a detected change. I still need to figure out how to report these things. Let me know if you have any suggestions. Thanks for your help!! - zim 9 years ago
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
9 years ago
Top Answer
This is the report that I use:
SELECT ASSET_HISTORY.ASSET_ID,
ASSET_HISTORY.TIME,
ASSET_HISTORY.VALUE1,
ASSET_HISTORY.VALUE2,
ASSET_HISTORY.USER_TEXT,
MACHINE.NAME
FROM ASSET_HISTORY
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).
Posted by:
JasonEgg
9 years ago
for my environment, I had to change this line:
to this:
JOIN MACHINE ON ASSET.NAME = MACHINE.BIOS_SERIAL_NUMBER
to this:
JOIN MACHINE ON ASSET.NAME = MACHINE.NAME
