Kace report - daily report of any asset that has been changed or created
We are in the process of moving our inventory into Kace, and we have workflows for our tech staff that detail how to update or add a new asset. While we are in the early stages we would like to know that information is correctly being added and updated. A daily report of what's been added or changed will be helpful. Thoughts?
Thanks!
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
6 years ago
Here is a report that will show records from the ASSET_HISTORY table for computer asset changes in the past 24 hours by technicians:
SELECT ASSET_HISTORY.*
FROM ORG1.ASSET_HISTORY
JOIN ASSET on ASSET.ID = ASSET_HISTORY.ASSET_ID
WHERE ASSET.ASSET_TYPE_ID = 5
AND TIME > DATE_SUB(NOW(), INTERVAL 24 HOUR) AND USER_ID != 0
Comments:
-
You are a hero! Thanks! - ckeenan@smith.edu 6 years ago
