How to see users who have been invited but not signed up?

[jdwyatt]

I am running JIRA Software Server edition v7.11.0. I have invited users to join via the "Invite users via email" capability. Outbound SMTP works. Some users went forward with registration, while others did not. I'd like to see the outstanding list of invitees who have not yet joined my JIRA.

[Stephen Sifers]

Hello Josh and welcome to the Community!

There is nothing within the interface which will show users who have been invited to create an account within Jira. There is a way where you may query the database to see all users invitations along with if they’ve redeemed their account. The Database query for PostgreSQL will look like:

SELECT * FROM "AO_97EDAB_USERINVITATION"

And for all accounts not redeemed:

SELECT * FROM "AO_97EDAB_USERINVITATION"
where "REDEEMED" = 'false'

Here is an example output:

 

I hope this helps to locate all invited users and all users with outstanding invitations.

Regards,
Stephen Sifers