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:
Cancel
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!!
Please log in to comment

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

Please log in to comment

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
Fourth Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share