- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-29-2024 12:07 AM
Hi Everyone,
I just want to ask if anyone has an idea how we can extract a report against change_request table where the planned start/end date has been changed? We just want to see the number of CRs that was extended.
Thank you in advance.
Regards,
Ramel
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-29-2024 12:39 AM
@Ramel :
1. Go to sys_audit table.
2. Apply query as table name change request and field names as planned start date and planned end date.
3. You can see the old value and new value for these fields.
4. You can export this data in excel- List context menu- Configure- Export-excel
5. Or you can see data in interactive way - List context menu- configure- Launch Interactive analysis
Note that this table may stores large data so use query with date fields (created) appropriately. Attached screenshot for reference.
Hope it helps. Kindly mark helpful/accepted if it helps.
Regards,
Priyanka Salunke
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-29-2024 12:39 AM
@Ramel :
1. Go to sys_audit table.
2. Apply query as table name change request and field names as planned start date and planned end date.
3. You can see the old value and new value for these fields.
4. You can export this data in excel- List context menu- Configure- Export-excel
5. Or you can see data in interactive way - List context menu- configure- Launch Interactive analysis
Note that this table may stores large data so use query with date fields (created) appropriately. Attached screenshot for reference.
Hope it helps. Kindly mark helpful/accepted if it helps.
Regards,
Priyanka Salunke
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-29-2024 01:01 AM
Hi @Ramel
Greetings!!
The one way is sys_audit log as suggested by @Priyanka_786 or if you want you can create the metric definition as well for the same.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************