Searching Groups Information

[Ian Mason]

Is it possible to query the confluence database to find out when a group was created and by whom?

[Fabio Racobaldo _Herzum_]

Hi Ian,

in order to retrieve when group has been created you can just perform the following query :

select * from cwd_group where group_name = 'YOUR_GROUP_NAME';

you can see when the related group has been created/updated into created_date/updated_date columns.

Hope this helps.

Fabio

[Fabio Racobaldo _Herzum_]

I didn't find any information stored on the db for that.

Regards,

Fabio

[Ian Mason]

Are there any parameters for searching who created a group?

[Ian Mason]

Thanks Fabio!

[Guilherme Nedel [Atlassian]]

Hello Ian,

You could employ increased logging levels in tandem with the SQL query mentioned above. To have more information on group addition actions:

1. Edit <install-dir>/confluence/WEB-INF/classes/log4j.properties
2. Search for 'Embedded Crowd logging'
3. Change this line to DEBUG level logging (default set at INFO initially)

log4j.logger.com.atlassian.confluence.user.crowd=DEBUG

The article for such configuration can be reviewed here.

[Ian Mason]

If we increased the embedded crowd logging, it will return a field that gives us a user that created the group? Thanks! - Ian