Reporting on 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]

Hello @LadySGRho89 

You can run report on sys_audit table to get this report if the field is being audited. In general state changes in change request are audited, so you can pull up this report as the audit entry contains date time, table name, field name, old value and new value.

Ignore if you have got multiple replies from me for this query, it seems there is an issue with community, the answers posted are some time not showing up in the replies.

[LadySGRho89]

Can you show an example of this? I am still fairly new to ServiceNow.