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

Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

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:

1 SELECT * FROM current_dw.[Epic Log] WHERE el.[FK Epic ID] = <Your Epic ID> AND [Detail Text] LIKE '%Due date Changed%' ORDER BY [Date Audit Event] DESC;

  • 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:

1 SELECT * FROM current_dw.[Epic Log] WHERE [Date Audit Event] >= '<Start Date>' AND [Date Audit Event] <= '<End Date>' AND [Detail Text] LIKE '%Due date Changed%' AND el.[FK Epic ID] = <Your Epic ID> ORDER BY [Date Audit Event] DESC;

  • 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:

1 SELECT * FROM current_dw.About;

Updated on April 14, 2025
Platform
Cloud and Data Center
Products
Jira Align Cloud
Jira Align Data Center
On this pageSummarySolution

Still need help?

The Atlassian Community is here for you.
Ask the Community