how can i get a listing of groups in confluence?

[Bob Doppel]

I want to generate a report that shows a listing of all groups in our Confluence instance.  Anyone done anything like this?

Thanks!

[Davin Studer]

You could do it with a user macro.

## Developed by: Davin Studer
## Date created: 04/21/2015
## @noparams
<ul>
#foreach($group in $userAccessor.getGroups())
    <li>$group</li>
#end
</ul>

[Mallmann]

Nice one, Davin! :)

[Norman Walter]

Just in case the special characters in Davin's script causes issues like they did for me - this slightly changed version worked flawlessly for me (Confluence version 6.4):

## Developed by: Davin Studer
## Date created: 04/21/2015
## @noparams
<ul>
#foreach($group in $userAccessor.getGroups())
<li>$group</li>
#end
</ul>

 Thanks, @Davin Studer. Awesome little script.

[Davin Studer]

Yeah, unfortunately when these posts were migrated from the old Atlassian Answers site the code blocks were html encoded, which messes up the code. : (

[Mallmann]

Hello Bob,

You can get a list of all group names by running a query against your database. For instance:

select group_name from cwd_group;

It's also possible to retrieve the directory name that this group comes from and other kind of information you might need.

Let me know if that helps! 

Eduardo

[Panos]

similarly from the java api

public class MyClass extends ConfluenceActionSupport{
	private final UserAccessor useraccessor;
	public MyClass(UserAccessor userAccessor){
		this.useraccessor=userAccessor;
	}
	public String execute()
	{
		//do something with
		useraccessor.getGroups()
	}
}

[Bob Doppel]

Thanks, Eduardo!  I'll give it a shot.

Bob