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

[Ramel]

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

[Priyanka_786 · Accepted solution]

@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

[Dr Atul G- LNG]

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.

[modiboyina]

Hi Everyone,

can you please me create a report which shows all changes where schedule end date was extended, after change has moved to "implementation in progress" state.
assignment group should contains "ITS"
starting date 1/1/2025

Thank you in advance.

Regards,
Ramel

[Dr Atul G- LNG]

Hi @modiboyina 

Note: This is not a direct report. You’ll need to:

• Create a metric based on the Planned End Date.

• Add a condition to filter by the specific group.

• Then, create a report and proceed accordingly.