Change management report

EmmaM23
Tera Contributor

Hi, I'm trying to build a report which will show the count of changes which are implemented outside of their planned window. I have set-up a report with the attached conditions, but these are only showing changes which have a different actual start/end date/time compared to the planned details. Would anyone have any recommendations on if/how I could capture that information in a report?

2 REPLIES 2

Bert_c1
Kilo Patron

Hi EmmaM23,

 

I can envision a GlideRecord script to do the comparisons you want. I don't see how to do that in a Report Definition.  I suppose that script can be used to add records in a custom table, then report on that custom table. Or, create a custom field on change_request, that a script sets to true, and base a report on that field.

 

Maybe other community members will have a different suggestion.

dreinke
Tera Contributor

@EmmaM23 did you ever figure this out??  I've got a script execution/mail script doing it now, but the output is ugly and I'd like to make it a "real" report.