Query for tracking asset changes
Track asset changes
Columns:
Asset Name, Edited at, Edited by, Attribute, old value, new value
Go to Reports Tab--> New Query Report and use the below query
Query
select ciname as "Asset Name", longtodate(operationtime) as "Edited at", username as "Edited by", attribute as "Attribute", oldvalue as "Old Value", newvalue as "New Value" from cihistory ch left join cihistorydetails chd on chd.historyid = ch.historyid left join ci on ci.ciid = ch.ciid;
Regards,
Kirupakaran H
Servicedesk Plus
New to ADSelfService Plus?