How to Obtain Audit Details for Milestone Due Date Changes in Jira Align using Enterprise Insights

Summary

This guide explains retrieving audit details for milestone (Epic) due date changes within Jira Align using Enterprise Insights.

Solution

Steps:

1. Connect to your Enterprise Insights database. You can use your preferred SQL client to establish a connection.

2. Execute the following SQL query:

• Replace <Your Epic ID> with the actual ID of the milestone/Epic you are investigating. You can find this ID in the Jira Align URL for the Epic.

• This query filters the Epic Log table for entries related to your specific Epic and containing the phrase "Due date Changed" within the Detail Text column. The results are then sorted by the Date Audit Event column in descending order, showing the most recent changes first.

• Wildcard Usage: The LIKE operator with % wildcards is used to find entries containing "Due date Changed" even if other text is present in the Detail Text column.

3. (Optional) Filter by date range: If you want to see changes within a specific timeframe, add a date filter to your query:

• Replace `<Start Date>` and `<End Date>` with the desired date range in the format 'YYYY-MM-DD'.

4. Review the results: The query results will show several columns, including:

• FK Epic ID: The ID of the milestone/Epic.

• Detail Text: A text description of the change, including the old and new due dates.

• Date Audit Event: The timestamp of when the change occurred.

Important Considerations:

• Enterprise Insights Data Refresh: The Epic Log table, like other Enterprise Insights tables, is typically updated hourly. There might be a delay between a due date change in Jira Align and its reflection in Enterprise Insights. To check the last sync time, you can run: