Change management report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2023 08:01 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2023 10:29 AM - edited ‎07-21-2023 12:16 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2024 09:51 AM
@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.