Change Reporting Assess to authorize

[Denise10]

I am being asked to build a report that captures when a change is moved from assess to authorize state at a specific time during the week.  Is there a way to capture this via a regular report or something via analytics?

[Hajar BENJAHHAR]

Hello Denise, 

Could you please be give more details. You want to calculate the time the change request takes to transit from state assess to authorized ?  

[Denise10]

Hello - i'm looking to capture a very specific activity.  When the state of a change moves from assess to authorize at a certain point on and time.  We are trying to capture a behavior.  

Ex:  Change moves to authorize after 1:00 PM CT every tuesday.  If the change moves to auth state after that time it will not meet the CAB criteria for the change to be reviewed.  the users wait to move it to auth and then file everything as an emergency change.

We are trying to collect the data to show the behavior to again enforce the current process.

[JP - Kyndryl]

Hi Denise,

I would suggest you create a new metric definition "Change State Duration" in copying/modifying OOTB "Incident State Duration".

You may also create a new DB View "change_metric" in copying/modifying OOTB "incident_metric".

Reporting on this new DB view (that will combine metric_instance and change_request tables) you will be able to see all the time passed in each Change states.

Regards.

JP

[Denise10]

Thank you for this suggestion.  I will check it out.