How to create a report based on Assignment Group Change history via the Incident Table

[Ramakrishna Kom]

Hi,

Can someone help me to generate a new report based on Assignment Group Change history via the Incident Table.

[Ishaan Shoor]

You can use the Assignment Group metrics as the source to create a report for assignment group changes on the incident table.

.

[Ramakrishna Kom]

Hi Ishaan,

I'm expecting the output would be like, the report should display current assignment group value and the previous assignment group value. Please share your inputs on this.

[Ishaan Shoor]

If you want previous and current value thingy, follow the steps below:

1) Create a database view something like below.

2) Create a report out of this database view as below

This way you get the value(previous value) from metric and also have assignment group field from incident which gives the current value of the assignment group.

.

[Ramakrishna Kom]

Does it possible to get the current assignment group name as well as the previous assignment group name history, by which actually the Incident  was assigned too.