Incident Record Reporting

[Gerald Onyia]

Hello!

I need some assistance. I am trying to generate a report or some way of viewing and exporting the following criteria:

- View all Resolved or Closed Incident records whose Assignment Groups are different that those the Incident records were created with. Basically, displaying all Resolved or Closed Incident records whose Assignment Groups were modified prior to resolving or closing.

I am open to any way of doing this as long as I have something to show via a report or an Excel export.

Thanks!

[Zach Koch]

The only way that you would have access to see what the value of the Assignment group is, throughout the lifecycle of the record, would be to go look at its Audit history. OOTB sys prefixed tables are not reportable, but you can add them if you need to.

It is not recommended to report on these, but if you choose, you can follow these docs to do so.

Docs to adding sys tables to reporting 

You could set up something like this as an alternative

Alternative 

[Gerald Onyia]

Hi Zach,

Thanks for the response! In your Alternative link, there aren't any 'Accepted Solution'. There are only a few 'Handful' comments. Which of the 'Handful' comments do you think would be the ideal solution for my inquiry? Thanks!

[Zach Koch]

If you don't need the reporting from the past, I would follow Goran Witchdoc's method. If for some reason you need to report on past data, before the solution is implemented, I would follow Nickels suggestion.

[Gerald Onyia]

Thanks for the response Zach. I'm not used to scripting, and do not know how to update Nickels script to match what I need. How would I update his script below to my needs in my post? Thanks!

answer = false;
var cis = new GlideRecord('alm_hardware');
cis.addEncodedQuery('sys_updated_onONLast month@javascript:gs.beginningOfLastMonth()@javascript:gs.endOfLastMonth()');
cis.query();
if (cis.hasNext()){
	answer = true;
	while (cis.next()){
		var hs = new GlideHistorySet(cis);
		var sys_id = hs.generate();
	}
}