/build/static/layout/Breadcrumb_cap_w.png

How to view and Save Device User History ?

Hello !


I'm looking for a tips to see and save the history of all user of a device.


Exemple :

For the device PC001, I' want to list who has use the device


Thank you in advance !


Nathan N.


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Nico_K 3 years ago
Red Belt
2

Go to Settings | History and verify the correct fields (under Subscriptions | Assets |Devices |User in your case) are retained and the retaining time is sufficient.
If it is you can find under Settings |History | Assets the nessesary info and can filter it as you like and also create reports about it.


Comments:
Posted by: Hobbsy 3 years ago
Red Belt
0

Or just for fun, why not try using this SQL in a report? If you know the machine name you want to know the history for, then enter the machine name in the highlighted yellow area below, alternatively remove the line to get multiple data and the AND at the start of the next line, you may also want to add in a GROUP BY ASSET_HISTORY.NAME


SELECT

ASSET_HISTORY.ASSET_ID as Asset_ID,

ASSET_HISTORY.NAME as Asset_Name,

ASSET_HISTORY.USER_TEXT as Change_made_by,

ASSET_HISTORY.VALUE1 as Old_Owner,

ASSET_HISTORY.VALUE2 as New_Owner,

ASSET_HISTORY.TIME as Timestamp

FROM ASSET_HISTORY

WHERE

ASSET_HISTORY.NAME = 'DESKTOP-99K26LG'

AND ASSET_HISTORY.CHANGE_TYPE = 'Modification'

AND ASSET_HISTORY.FIELD_NAME = 'OWNER_ID'

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