We are trying to determine all our Active Jira and Confluence users. It would be nice if we could filter users on Login Details and/or export the results to Excel. This would simplify managing our users, until that is an option I was wondering how are others determining Active/Inactive users?
You can run the query below in your Confluence database to list all the active user in Confluence.
SELECT o.list_index, d.active, d.id as DirectoryID, d.directory_name, d.directory_type, u.id as UserID, u.user_name FROM cwd_user u JOIN cwd_directory d ON u.directory_id = d.id JOIN cwd_app_dir_mapping o ON d.id=o.directory_id ORDER BY 2 DESC, 1 ASC;
For the sql query to list all the active user in JIRA, you can follow this KB https://confluence.atlassian.com/display/JIRAKB/How+to+Get+a+List+of+Active+Users+Counting+Towards+the+JIRA+License.
Hope this helps.
Sorry, I din't know that you're using Confluence 3.4. You should run this two query to find the internal/external user with the group associations for Confluence.
select e.name, g.groupname from external_entities e left join external_members m on e.id=m.extentityid left join groups g on m.groupid=g.id order by e.name; select u.name, g.groupname from users u left join local_members m on u.id=m.userid left join groups g on m.groupid=g.id order by u.name;
I'm not well verse with JIRA but you can find the list of available user by going to the Administrator >> User then filter users under the group jira-users. This should list the active user.
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 ...
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot