Export users

[Arantxa Lacasa Madero]

Hello,

Is there any way to export all users from a group, to know at least the number of users that are in that group?

In paginations, it does not say the total number of elements of each list.

[Sandro Herrmann [Communardo] · Accepted solution]

Another way to achive this is by writing a little usermacro.

## @param groupname:title=Group Name|type=string|required=true|desc=The Name of the Group

#set($containerManagerClass=$action.class.forName('com.atlassian.spring.container.ContainerManager'))
#set($getInstanceMethod=$containerManagerClass.getDeclaredMethod('getInstance',null))
#set($containerManager=$getInstanceMethod.invoke(null,null))
#set($containerContext=$containerManager.containerContext)

  
## the user accessot gives you access to the users
#set($userAccessor=$containerContext.getComponent('userAccessor')) 


#foreach( $group in $userAccessor.groupsAsList  )

    #if( $group.toString().equals($paramgroupname) )
              There are $userAccessor.getMemberNamesAsList($group).size() users in the group $group
    #end

#end

This macro with an example name "usercount" can now be used by using the following macro call at a page:

{usercount|usergroup=confluence-users}

[Arantxa Lacasa Madero]

It works perfectly. Thanks so much!

[ARF2 ARF2]

Hi,

My company (LBAppStudio) has created a solution for Confluence Cloud to export all users in a group or groups.  Please find the solution here:  https://marketplace.atlassian.com/apps/1234489/reports-plus-for-confluence?hosting=cloud&tab=overview. We are happy to consider any enhancement requests!

[Yilin]

Hi Arantxa,

May be you can try the following SQL statement, hope this hlep:

select cu.user_name,cu.active,cu.first_name,cu.last_name,cu.email_address from cwd_user cu join cwd_membership cm on cu.id=cm.child_user_id join cwd_group cg on cm.parent_id=cg.id where cg.group_name='confluence-users';

Cheers

Yilin

[Yilin]

In this case, maybe you can open the page with the following URL:

"<Your Confluence base URL>/admin/users/domembersofgroupsearch.action?membersOfGroupTerm=<The name of your group>"

The page will display the member of this group .

Also, you can use the "user list" macro in a page to list the user in a group. :)

Hope this help.

[Arantxa Lacasa Madero]

Thank you Yilin.

I really needed some way without having to access the database, since it is something that should manage the Level 1 technical support, and they do not perform queries to database.

Indicate the total number of a listing is a necessary and available information in most applications. Would not this be included in Confluence?

[Arantxa Lacasa Madero]

Thank you Momo.

But I need to know the total number of users of a group (without counting them one by one, and without doing a query to database).

Is this possible? Maybe with a param of the userlist macro?