How to find group usage in Confluence

[Marcel Plomp]

How do I find where a specific group is used in Confluence? In other words: How do I find which permissions on spaces a specific group has?

In JIRA you can at least see if a group is used within a permission scheme.

Is this also possible in Confluence?

[Tibor Hegyi _META-INF_ · Accepted solution]

Hi Marcel,

there is a handy tool that gives you exactly what you are looking for: a central page where you can view the groups and their permissions in all spaces. 

https://marketplace.atlassian.com/plugins/hu.metainf.plugin.confluence.ultimate-permission-manager/server/overview

Tibor

[Marcel Plomp]

Hi Tibor,

Thanks for the link. It seems that for every feature that is missing in Confluence ( or Jira) an add-on is available.

I'll take a look at it but I expected an answer that leads to a "normal"' resolution just by using Confluence. If that is not available, maybe Atlassian can provide it in future releases.

Regards,

Marcel

[Tibor Hegyi _META-INF_]

Hi Marcel,

I understand your point of view, and you are right.

From another perspective though, the vital Marketplace is the power of Atlassian Ecosystem 

Good luck and let me know you have questions on the above mentioned addon.

Regards,

Tibor

[Marcel Plomp]

Don't get me wrong. I understand the value of the Atlassian Ecosystem but an add-on should provide additional functionality that is not a basic need for Confluence and which is very helpful for the business (like Tempo Timesheets for Jira).

Managing your groups in a proper way, including the possibility to see what rights these groups have, should be imbedded in the basic installation of Confluence as this is a basic need (IMHO).

Atlassian still has some work to do.

[TomC]

@Marcel Plomp sounds like a valid feature request. Sometimes Atlassians see and respond to questions like yours that come through and that may still happen. Another option exists too...

As you probably know, Atlassian has an 'open' feature request system at jira.atlassian.com   You can search to see if an issue similar to yours has been raised and is open (if so, you can watch the issue and vote for it, plus add comments) or create an issue for it.

Good luck, mate!

[Marcel Plomp]

Hi Tom,

Thanks. I know.

I'll take a look., sometime,.....in the future.

Regards,

Marcel.

[Kevin Molloy]

An alternative is to attempt to remove a group.  It will give you a warning and tell you where it's used.  You can then cancel the remove.

[Dang Thi Thuy Tien]

Hi there, 
With this app Group Master for Confluence, you easy get group usage in your Confluence.
Please have a look ;)
https://marketplace.atlassian.com/apps/1236396/group-master-for-confluence?hosting=datacenter&tab=overview

And another advanced group management capabilities:
    View group usage across Jira
    Edit group names for clarity
    Move or copy group members easily
    Replicate or migrate group usage
    Delete groups and clean up associated data 

[Łukasz Sielski priv]

or you can use this for free

https://confluence.atlassian.com/confkb/how-to-list-which-spaces-a-group-can-access-720636535.html

[Edward Dumser]

This is a good start, but does not list groups used in page restrictions

[Edward Dumser]

I made this to check for page restrictions:

SELECT
    `SPACENAME` as `Space`,
    `TITLE` as `Page`,
    `CP_TYPE` as `Permission`,
    `GROUPNAME` as `Group`
FROM `CONTENT_PERM` cp
INNER JOIN `CONTENT_PERM_SET` cps ON(cp.`CPS_ID` = cps.`ID`)
INNER JOIN `CONTENT` c ON(c.`CONTENTID` = cps.`CONTENT_ID`)
INNER JOIN `SPACES` s ON(c.`SPACEID` = s.`SPACEID`)
WHERE cp.`GROUPNAME` = '<group name>'
GROUP BY cps.`CONTENT_ID`, `SPACENAME`, `TITLE`, `CP_TYPE`, `GROUPNAME`;