Incident field changes report

[Gary Larsen]

I am trying to create a report for all incidents that a particular user has updated the assignment group  

EX

all incidents were the MA user changed the assignment group

[Uncle Rob]

Under the navbar menu is a section called "Metrics" under which a module called "Definitions"
Metric Definitions are an ANCIENT feature that would add an entry into Metric Instances any time a defined field was changed.  It would track the user who performed the action, the new value, and calculate the final duration of the old value on the change.   Most of the OOB ITSM tables already have Metric Definitions created for fields like state, priority, assignment group, and assigned to.

So in your case go to incident_metrics and search for records with a "definition" (reference to Metric Definition) of "assignment group".  That should get you where you want.

[Gary Larsen · Accepted solution]

I found a solution, I made a database  view with incident and sys_audit tables