/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


K1000 - Software Change Report?

10/13/2015 2636 views
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 Summary:
1 Comment   [ + ] Show comment

Comments

  • 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!!

Answer Chosen by the Author

1
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).

Answered 10/19/2015 by: chucksteel
Red Belt

All Answers

0
for my environment, I had to change this line:

JOIN MACHINE ON ASSET.NAME = MACHINE.BIOS_SERIAL_NUMBER

to this:

JOIN MACHINE ON ASSET.NAME = MACHINE.NAME

Answered 10/23/2015 by: JasonEgg
Red Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ