list all users in a group

Running jira server 7.3.0

I want to display and print, if need be, a list of all users (customers, jira users and agents) by group in jira.    Is this possible? 

Seems I am looking to hard into this, such a simple thing, and can not see an obvious way to do this.

 Thanks

2 answers

You can definetly create a group and add the requuried members in that group but i am unable to understand how you want to user this group and where you would like to display and print?

 

Yes. Easy to setup a group with users.  No problem there at all.  But I just want some way to list/print users in any group.  So I have a hardcopy printout of all the users in a group.

 

Jira doesn;t have any print option but you can use Chrome print otption to save the user list which you would like to Print.

Right click on web page which you would like to print and save with PDF. This will save the users in PDf format which can you print or send through email. if you are satisfied with the answer then please vote and like it. Thanks in advance

Hi,

You can do this with your sql database.

I use mysql, here's my request:

select lower_child_name, parent_name from cwd_membership order by parent_name;

To export the result, you can use this out of your sql database:

mysql -h databseServer  -u jiradbuser-p jiradb -e "sql_request"

You can easily convert this file with excel.

Regards

Thank you Laurent.  Will give this a go in future.  Have had to simply use print and save as pdf option as suggested by AtlassianPassion above.  

At least I have a saved listing floating around.

 

regards

Maria

Ok,

Try it when you have the time. I was new to sql but it turned out the be usefull when i wanted to get specific information like this. It's also very easy to convert the output data into nice excel table.


Good luck !

Regards,

Laurent

You can use the user-list macro in Confluence if it is using the same groups. There's no really great answer for it in JIRA :(

thanks Matt for your suggestion.  Will check this out as an option.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,198 views 13 19
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot