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

Ramel · ‎02-29-2024

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 · ‎02-29-2024

@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

View solution in original post

modiboyina · Wednesday

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,
Hareesha.