Sam Tsubota Atlassian Team

@Jason Davis I recommend opening a ticket with the Atlassian support team and they can help you with this. Here is a link to the Jira Align support portal: https://support.atlassian.com/jira-align/

@venkateshwarlu In Enterprise Insights, the About table has the refresh UTC time.

@Jason Davis There hasn't been any changes to permissioning on EI. Does Alteryx Server require permissions to the master DB for SQL DBs? I've seen this before as an issue on another tool. With EI we don't allow permissions to the master DB. 

Does Alteryx Server use port 1433 outbound to connect to Enterprise Insights? I'm guessing that it does. Are there different firewall rules for Alteryx Server? The reason why I am asking these questions because you can connect to Enterprise Insights with Alteryx Desktop which confirms that you can connect from your…

@Jason Davis Is your Alteryx Server on your corporate network and is its IP address within the IP addresses that is whitelisted on your Enterprise Insights instance? 

@David Spiller This is by design. The intent of features is to represent an increment of value that is completed with a quarter or program increment. If you have a feature that takes more than one quarter or program increment to complete, it either should be a portfolio epic or broken down into small increments. If your…

@Steve Krysko The primary use case for the Jira Align APIs are for building integrations with Jira Align. Thus the fields that are available through the APIs are limited. Jira Align Enterprise Insights is the data mart for Jira Align that is intended for building custom reports and dashboards using your existing data…

@Kiran Yarlagadda The current_dw.Epic Process Step Assignment History table has the process step history for Epics. The Assignment Start Date and Assignment End Date columns show when the Epic assigned to the process step. If you see a 9999-12-31 date in the Assignment End Date column that indicates that the Epic is…

@GregPearson Jira Align's delete functionality doesn't automatically delete issues in Jira. On the Jira Setup tab under Jira Settings, you can configure the Jira Connector to sync when a work item is deleted in Jira Align to a Jira workflow status like "Delete" in the Delete Item Status field (See below). What will happen…

@Carlos Ceballos When configuring the Jira Connector within Jira Align, one of the things that is done is mapping the Jira statuses in the story workflow to the Jira Align story states before connecting a Jira project with Jira Align to sync issues. Check with your Jira Align admin to confirm how they have mapped the…

Hi @Kiran Yarlagadda IP whitelisting is required if you want to connect Tableau to Enterprise Insights. It’s necessary to validate incoming requests coming from customer’s network.

The reason why I suggested checking these things because Enterprise Insights access is just IP whitelisting and either SQL login or Azure AD authentication. Since you are able to connect to Enterprise Insight, albeit not consistently, that rules out issues with IP whitelisting or SQL login authentication. The biggest…

I suggest also checking with your network team to see if any firewall or network configurations were changed recently that may be blocking traffic to the port that is used to connect to Enterprise Insights. 

@Jason Davis You should to check to see if the network IP address for your Alteryx instance was changed recently. When your Enterprise Insights instance was set up a range of IP addresses for your corporate network was whitelisted by Atlassian to restrict access to users/application on your network. If the IP address has…

Hi @Kiran Yarlagadda , yes you can connect Jira Align Enterprise Insights from Python. There is a community article that explains how to do this. https://community.atlassian.com/t5/Jira-Align-articles/How-to-connect-to-Jira-Align-Enterprise-Insights-using-Python/ba-p/2063676

@Ian C The Key Results are located in the current_dw.Metric and the Key Results check-in values are in the current_dw.Metric Value table

@Serajul Arfeen Unfortunately, you can't change the location or sizing of a custom field on the Details Panel of a work item.

An ER diagram for Enterprise Insights is not available. The data schema document on the Jira Align Knowledge Base has a tab of the foreign key mappings.

Hi @Saravanamuthu Kandasamy , there isn't an ERD for Enterprise Insights. There is a data schema document on the Jira Align Knowledge Base for each release that shows the tables and columns and the foreign key mappings. In order to access the data schema document you need to create a login through the Sign In button in the…

@Rebecca Hylek What may have happened when your site admin was logged in with his Jira account when allowed the Jira Connector to access Jira Cloud when authorizing Jira Oauth access . You can try re-authorizing Jira Oauth access in the Jira Connector with the following steps: 1. In one web browser tab, open Jira Align and…

@Abhinav Reddy The current_dw.Role Log table in Jira Align Enterprise Insights (formerly known as Leo) contains the audit log data for changes to systems roles. The Detail Text column provides the specific details on the change to the permission toggles. You will need to join this table with the current_dw.Role table on…

If you are on Jira Align cloud, you don't have access to the database. If you are referring to Jira Align Enterprise Insights, the data schema document is available on the Jira Align knowledge base under Enterprise Intelligence. You will need to create a login through Sign In to access previous version of the document. 

You have to purchase it separately. Reach out to your Atlassian enterprise advocate or partner to get more info and pricing.

@Rafi Ahmad You will need Enterprise Insights. You won't be able to access your Jira Align instance's database directly since you are on Jira Align cloud. 

@Rafi Ahmad Do you have an on-prem instance of Jira Align? It sounds like you do because if you have the cloud version you don't have the ability to backup your own data. If you do have an on-prem instance, I won't be able to help you because I don't know the Jira Align database schema. Enterprise Insights transforms the…

@Rafi Ahmad The best way to accomplish this is with Jira Align Enterprise Insights which is a data warehouse for Jira Align. You will be able to connect Power BI to Enterprise Insights. It has tables with the data you need to be able a dashboard with flow metrics. Do you have Enterprise Insights? 

@Rafi Ahmad Since you have multiple process steps in your process flow that represent active, you will probably need to take a sum of the average days of the active steps and then calculate the average. For quality, you can get that through Jira or if you have Jira bugs syncing with Jira Align stories you can filter the…

@Rafi Ahmad I wrote a community article on how to manually derive flow metrics from Jira Align views and reports. https://community.atlassian.com/t5/Jira-Align-articles/Measuring-the-Flow-of-Value-Using-Flow-Metrics/ba-p/1490534

@Sjoquist, Carl You need to submit a support ticket with Jira Align support and they can help with enabling that.

@Rafi Ahmad Here are answers to your question. Most of what you are looking for is on the Program Board 1. The Program Board shows features, dependencies, team objectives (PI Objectives) and milestones. Dependencies appear as a cross in a team’s swim lane and milestones appear as a diamond in the top row of the board.…