Data pull

Question

I have 7 different teams, each with their own Jira projects and boards. Each team is using Jira differently. I need to be able to view resource allocation across teams. First, I need to understand how the teams are all currently using Jira and get everyone to use the fields needed to get the needed visibility. How do I pull a report of all of the fields used (required and not) for epics across all teams?

Alexey Pavlenko _App Developer_ · Answer

Hi @Stacy Norman ,

If I understand you correctly, there are 2 requests:

* Unified view of resouce allocation for measuring and tracking purposes across 7 teams

For that, you can use the app I developed - Multi-team Metrics & Retrospectives. You can render several teams across several periods (periods might be sprints, months, quarters, half-years, or years).

Also, you track and measure here any custom metrics constructed via JQL. Columns in the drill-down section are editable - you can choose which custom fields to display.

If you want to see epics in this view, just add them to sprints and you will be able to see them here, but I would suggest using non-epic work-items and track work using sprints across all work-items, or just track tasks belonging to certain epics and assigned to sprints (you can apply a filter on top of any metric - for example, to see Completed Scope only for a certain sprint and a certain epic).

* Unification of epic fields

If you are sure that tracking resource allocation in the epics themselves is convenient for you/your teams (epics are not designed well for such actions) - you will need to go to the Project Settings of each project, go to Work items -> Fields, toggle on 'Only required'  and write down all the required fields there. After that create a JQL consisting of those fields and check their values in the Issue Navigator, for example.

Best regards,
Alexey

Christopher Yen · Answer

Hi @Stacy Norman , welcome to the community!

With 7 projects, I think the easiest way is to just go to each project and look at their Epics to get a sense of any common process/field usage between the 7. Use the create button and select Epic and try to save with nothing filled out to quickly see what's required. You can probably start with a preliminary filter showing Summary, assignee, status, reporter, created, and possibly due date?

Ultimately, the desired metrics will need to be determined and the teams should coordinate some standards to help with documenting and providing that single pane of glass view.

Jayesh Raghuvanshi_qb6277 · Answer

@Stacy Norman

Jira does not provide any direct report to list all fields used in epics across multiple projects, but we can use Rest API

Using the Jira API endpoint /rest/api/3/field you can get a list of all fields

Fetch the epics the using a JQL reference like issuetype = Epic AND project in (PROJECT1, PROJECT2, ..., PROJECT7)

Thanks
Jayesh R