Reporting on state changes in change records

LadySGRho89 · ‎08-11-2023

Is there a way in to run a report that shows which changes went to a different state during a certain time frame? For example, I want to report on all changes that went from Assess to Authorize during a certain timeframe.

AnveshKumar M · ‎08-11-2023

Hi @LadySGRho89

If you have enabled Audit for the state field in change table, you can run a report on sys_audit table to get your desired report.

In general state field in change_request field is audited. You can see the following screenshot where you can see state changes for a record (sys_id), it contains both old value and new value.

Thanks,
Anvesh

View solution in original post

AnveshKumar M · ‎08-11-2023

Hi @LadySGRho89

If you have enabled Audit for the state field in change table, you can run a report on sys_audit table to get your desired report.

In general state field in change_request field is audited. You can see the following screenshot where you can see state changes for a record (sys_id), it contains both old value and new value.

Thanks,
Anvesh