/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Kace report - daily report of any asset that has been changed or created

06/07/2018 523 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

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