Query for tracking asset changes

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 ADManager Plus?

                New to ADSelfService Plus?