How to report on who reassigned an incident

Mathieu Van de
Tera Contributor

Hi all,

I try to report on who in my team reassigned incidents to other teams.

So I would like a report with the following info : 

- Incident number

- Old assignment group

- New assignment group

- Reassigned by (user)

- Reassignment date

Is this possible please ?

I've already red a lot of topics about this but I never found and answer who would give me the "reassigned by (user)" information.

So, simply said, my biggest difficulty is to report on which user reassigned the incident.

Thanks in advance for your help.

Best Regards,

Mat

2 REPLIES 2

Thomas_Davis
Administrator
Administrator

Hello, you can do this by adding some logic into the MetricInstance Script Include. You will need your Admin to help you with this, but this is what you could do.

In the Filter Navigator, select Script Includes under Metrics

Once there, find and select MetricInstance

In this Script section, you will want to add some lines of code. In this section of code:

You will want to add in what I have in lines 27-30

Then you will also want to add a few more lines of code in this section:

You will want to add lines 42-45

Once you have done this select Update, in the top right-hand corner.

Next, you will want to go to Database Views in your Filter Navigator (admin required)

Search for incident_metric and then select it:

Under Related links, click to Try It

Once the results are loaded, click on the Update Personalized List icon:

Here we want to add in the additional columns that will give us the information we are looking for.

Find and move over to Selected, these three columns:

Click OK

If we sort the results on the Updated column, we can see the order in which the Assignment Group changed:

Notice in my test Incident:
1. It was originally set to Networking Operations when the Incident was created.
2. Admin changed it to Database
3. Thomas Davis changed it to Analytics
4. Charles Taylor changed it to HR Systems Support
5. Shaun Tait changed it to IT Securities
6. It is currently still at IT Securities.

This information (Updated by and Updated) will be captured with any change to the Incident, so this will be captured with other changes, like State, Priority, etc.

Next, you will want to create a report to see this information.

In the Filter Navigator go to Reports > Create New

On the Data tab, you will want to set the information to: (Name, your choice)

Type, select List, under Other

You shouldn't need to change anything under Configure or Style, but that may be up to you.

Click Run

Notice in the results, I see the same thing that was in the Database View

This should give you want you are looking for.

Hope this helps,

Hello Thomas

 

We're very interested in this solution but your screenshots don't work.   Is there a new link or resource for these steps that you can refer me to?

 

Thanks in advance!

Rob