How to create a report showing assignment group was X and assignment group is now Y

[Treva1]

How to create a report showing assignment group was X and assignment group is now Y

[Saurav11 · Accepted solution]

Hello,

Create a report on sys_audit table:-

Table name-> incident

Field name-> assignment group

Then you will be able to see the old value and new value for all the Incidents:-

Screenshot:-

Please mark answer correct/helpful based on Impact

[Saurav11]

Hello,

If my answer helped you please mark it as correct as well.

Thanks.

[Treva1]

Hey Im hoping you can answer 1 other question i have. 

[Saurav11]

Yes