How to get a map of all SW projects relationships?

[Inbar Levi]

Hi,

I am looking for a way to get a map (excel maybe from DB?) so I can see all Jira projects links to one another, so I can make a silo list..

Use case: to know which project is relate to other project (meaning there is a linked issue between them) , so I can migrate them to the cloud together at pashas (each silo at a time).

[Ignacio Aredez GenAI Expert]

1. Extract Data
Use Jira Query Language (JQL) to find linked issues across projects with a query like issueLinkType is not EMPTY.
Export the search results to CSV, ensuring you include project keys and issue links.

2. Analyze Relationships
Use Excel to process the CSV. Identify which projects are linked by examining the issue keys and extracting project keys from them.
Alternatively, write a script (in Python or another language) to automate this analysis.

3. Visualize Map
In Excel, create a table or matrix showing project interconnections.
For a visual map, consider tools like Microsoft Power BI or Gephi to graphically represent project links.

4. Plan Migration
Based on the map, group projects into silos that are interrelated and should be migrated together to Jira Cloud.

Key Tips
Automation can simplify this process, especially for large datasets.
Utilize the Jira Cloud Migration Assistant for a smoother transition, as it helps identify and migrate dependent components effectively.