Pulling report for state changes

LadySGRho89
Tera Expert

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. 

1 ACCEPTED SOLUTION

AnveshKumar M
Tera Sage
Tera Sage

Hi @LadySGRho89 

Yes you can run a report on sys_audit table to get this report, if the field is being audited. In general state changes in change request table is audited, so you can pull this report from sys_audit table. See the screenshot below.

 

IMG_20230812_052352.jpg

Thanks,
Anvesh

View solution in original post

4 REPLIES 4

AnveshKumar M
Tera Sage
Tera Sage

Hi @LadySGRho89 

Yes you can run a report on sys_audit table to get this report, if the field is being audited. In general state changes in change request table is audited, so you can pull this report from sys_audit table. See the screenshot below.

 

IMG_20230812_052352.jpg

Thanks,
Anvesh

Hi,

Thanks for your response. How can I check if a field is being audited or not?

And if not audited, can I make a field to be audited

Gemma4
Mega Sage

@LadySGRho89 Is it possible to have the change request number display and what the old and new values are. While I appreciate being able to report on state changes out of the box, the details can't be  presented. 

sys_audit.png