- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2023 01:16 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2023 04:58 PM
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.
Anvesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2023 04:58 PM
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.
Anvesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2024 01:21 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2024 07:20 PM
@Vaibhav Sharma1 this KB article might help you.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0685670
Anvesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2024 12:11 PM
@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.