/build/static/layout/Breadcrumb_cap_w.png

Past Assigned User History

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. 

Asked 4 years ago 422 views
0 Comments   [ + ] Show comments

Answers (1)

Posted by: gwir 4 years ago
Second Degree Brown Belt
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



 
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