Is there a way to export Users from User Management?

[Vishnu C]

We are using JIRA Server 8.4.2 version.

1. I dont see nay options to export the users list from User Management?

2. Where can I see the invited users list in User management? We sent invitation request to 100's of users but we need to track the status of the invitation whether it has been accepted and the users are accessing the application?

[Ed Letifov _TechTime - New Zealand_ · Accepted solution]

Hello,

The default built-in user management doesn't have these features, indeed.

Please consider using our app UserManagement for Jira instead - you will be able to export users to CSV in the Bulk User Actions mode.

It won't be able to track the status of invitations sent out, but you will be able to query your user base, and see which users have been created, who is active and who is not.

To keep you user counts under control you will also be able to configure Scheduled User Actions to deactivate those users in Jira who haven't been active for a while.

[Vishnu C]

@Ed Letifov _TechTime - New Zealand_ 

Thank you for the confirmation. I queried the table cwd_user. Below behaviors I noted:

- Deleted existing Users -> User entry removed from CWD_USER table

- Sent Invite User request ->No entry made in CWD_USER table

- Created User -> User entry made in CWD_USER table with Active flag 1

Still there is no way for me to get the entire user list including invited users. 

[Ed Letifov _TechTime - New Zealand_]

I am willing to bet that getting UserManagement for Jira on an evaluation license, doing a search and then pressing Export to CSV is more efficient and secure, as well as less error prone than going directly to DB.

As far as I know, JIRA does not track invited users. I am happy to be corrected!

I believe it simply sends the emails - so the best option for you might be to go through your mail server logs?

[Ravi Sagar _Sparxsys_]

Hi @Vishnu C 

Do you have ScriptRunner for Jira installed on your instance? If you can write a groovy script then getting a list of user and writing it to a csv file is not very difficult. You can refer to this and this post for some pointers. Using ScriptRunner you will be able to use not only JIRA REST api but also Jira Java apis.

Take a look at the links above.

Ravi

[Vishnu C]

@Ravi Sagar _Sparxsys_ 

Hi Ravi,

I do have the scriptrunner but if I dont know where to pull the invitation list I can write that to the file. 

[mharriger@caredx.com]

I know this question is old, but in case anyone else needs it:

Try looking at the table AO_97EDAB_USERINVITATION in the Jira database.