How to find if a synced Story was first created in Jira or Jira Align using Enterprise Insights
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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 article shows how to use Enterprise Insights (EI) to determine whether a story was created in Jira first (and then synchronized up to Jira Align) or if it was created in Jira Align first (and then synchronized down to Jira).
Solution
The following steps will show how one can use Enterprise Insights (EI) to know whether a story was created in Jira first or if it was created in Jira Align first prior to sync:
Create two Stories, one in Jira Align (JA) and the other in Jira, and let them sync
Then check the Enterprise Insights database table below that basically shows the work item Story Audit log information:
current_dw.[Story Log]
The above EI table does not have a specific column to show if the work item was created in Jira or Jira Align. However, one could check the creation entry in the [Story Log] table using its [Action Type] column. Then, check the detail log text in the [Detail Text] column which shows the work item Creation Audit log information.
1 2 3current_dw.[Story Log]. [Action Type] current_dw.[Story Log]. [Detail Text]The below sample EI query uses the placeholder "EnterJiraAlignStoryIDHere" for [FK Story ID].
1select * from current_dw.[Story Log] where [FK Story ID]=<EnterJiraAlignStoryIDHere>
User needs to replace the placeholder "EnterJiraAlignStoryIDHere" with the Jira Align Story ID in the above query. The Jira Align Story ID can be obtained from the Jira Align UI Story slide-out panel (For example: "Story 12345")".
The following screenshot shows the above EI query results as an example:
As highlighted in the above screenshot, the [Detail Text] column can be used to know if a story was created in Jira or in Jira Align:
For Story created in Jira Align, the [Detail Text] column shows creation log entry as "Story Created:"
For Story created in Jira and synced to Jira Align, the [Detail Text] column shows creation log entry as "Created - CreatedBy:"
Was this helpful?