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.
Answers (2)
Top Answer
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:
-
Thank you! It's exactly what I want! - service.informatique@faun.fr 3 years ago
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'
