I would like to have a simple list of all the NAMES of my Customers and their Accounts and their Projects.


I need something like in the format in the image attached. In either XL or even better - straight in an internal view in Jira.

I'm interested only in the NAMES of the customers/accounts/projects but their KEYS will be nice as well.

Thanks for the help!!


1 answer

0 votes

You'll need some code to do that. Jira doesn't have any "export/report list of users", the closest you can get is to just scrape the screen listing users.

There's also a LOT of complexity in this requirement - you need to define your business rules on how a user belongs to a project, and then write code to extract their membership. (An easy rule is "user can see issues in it", but the default setup is that everyone can do that. So then you might say "user can create issues in it", but that's a two layered route - you need to read the permissions for the project and then see if the user matches any of the "create" rules)

Thanks a mil Nic.

I'm not interested in Users. Only in that list of Customers and each Customer's Account and each Account's Projects.

The data is out there as I see it in many places in Jira - but only parts of what I need (e.g. Customer and its Accounts in one place and in another place Account and its Projects).

I want all in a simple list...;-) Basic no?


Ah, sorry, I had assumed "customer = user", but that's not right.

Could you explain what a "customer" is then? I think this actually becomes harder because you've got to map customer -> user -> permission -> project, and you haven't said how you are linking user accounts to customers.

Nic - this has nothing to do with users. I'm not interested in a list which shows connections between users and other entiuties.

I'm only interested in a list preseting the connections between ALL my organization's Customers and ALL their Accounts and all their Projects.

Hi Nic,

I'm trying to explain myself in the clearest way possible. I'm sorry if it is not in the level you expect...

Anyways - I think I understand now what is the issue here. Since you mentioned specificallu that Jira accounts ARE users - It hit me - I'm using Tempo add-in and I need that mentioned list of customers-accounts-projects from there.

In Tempo users are NOT accounts.



You are missing the point.

You talked about "Jira accounts". These ARE users. You've asked for a list of "customers" and not told us what you mean by "customer", let alone what we really need to know, which is "how are you connecting customers to projects?" (I'm having to guess it's via user accounts as you've mentioned them)

You can't expect us to help you generate a report on "customer to project" if you won't tell us how you are forming that relationship in Jira.

Ah, Tempo, yes. We had no way of knowing that.

Still need to know how you are defining "customer" though, and accounts.

Thanks. I've contacted Tempo directly. I'll wait for their answer (unless you have a feeling you WILL be able to assit...).

As for your question - I'm not sure we can even "define" customers and accounts as it is a given in Tempo: Customer is a parent of Account(s) and Account is a parent of Project(s). Helps?


I'm not that familiar with Tempo, sorry.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 13, 2019 in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

514 views 0 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you