If you have JIRA Server, you can get this information from the database. Here's a MySQL query to get you started:
SELECT p.pkey, p.pname, pc.cname AS "category" FROM project p, projectcategory pc, nodeassociation na WHERE na.source_node_entity = 'Project' AND na.sink_node_entity = 'ProjectCategory' AND na.source_node_id = p.id AND pc.id = na.sink_node_id
NOTE: Uncategorized projects will not be returned.
Hope this helps!
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event