/build/static/layout/Breadcrumb_cap_w.png
06/07/2018 332 views
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

Comments


All Answers

1
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


Answered 06/08/2018 by: chucksteel
Red Belt