/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Past Assigned User History

01/17/2020 325 views

Is there a way to see who has had an asset in the past. For example, we have Joe that had a PC for 3 years, Joe leaves and then the computer goes to Jill and she leaves after 6 months and the computer goes to Bill. Is there a report that tells the history of an asset. 

0 Comments   [ + ] Show comments

Comments


All Answers

0

You can try this sql query :


SELECT NAME, `TIME`, CHANGE_TYPE, FIELD_NAME, VALUE1, VALUE2, FRIENDLY_FIELD_NAME
FROM ORG1.ASSET_HISTORY
WHERE FRIENDLY_FIELD_NAME = 'User'
AND CHANGE_TYPE = 'Modification'
;

And filter on the computer name



Answered 01/17/2020 by: gwir
Brown Belt

 
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