nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Searching Groups Information

Ian Mason

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

Accepted answers

All comments

Fabio Racobaldo _Catworkx_

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 _Catworkx_

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

Hello Ian,

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

Edit <install-dir>/confluence/WEB-INF/classes/log4j.properties
Search for 'Embedded Crowd logging'
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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration