/build/static/layout/Breadcrumb_cap_w.png

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 8 years ago

Answers (2)

Answer Summary:
Posted by: chucksteel 8 years ago
Red Belt
1

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 8 years ago
Red Belt
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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