Pulling report for state changes

[LadySGRho89]

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 · Accepted solution]

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.

 

[Vaibhav Sharma1]

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

[AnveshKumar M]

@Vaibhav Sharma1 this KB article might help you.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0685670 

[Gemma4]

@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.