Report/Extract on change request tickets where planned start/end date was changed

Ramel
Mega Guru

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

1 ACCEPTED SOLUTION

Priyanka_786
Tera Guru
Tera Guru

@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

 

Priyanka_786_0-1709195901305.png

 

View solution in original post

2 REPLIES 2

Priyanka_786
Tera Guru
Tera Guru

@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

 

Priyanka_786_0-1709195901305.png

 

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

****************************************************************************************************************