sql query to find inactive group in confluence

[PK_KP]

Hi,

I tried couple of sql queries but im facing issues still, I need to view the inactive groups in the confluence. 

[Shannon S · Accepted solution]

Hi @PK_KP,

I assume you've found a solution to this already, but if not, the documentation on how to bulk-delete groups in SQL for Confluence also has a script to locate empty groups:

• How to remove groups from Confluence via the database 

Check under Section 1: Check to see if the group(s) is safe to delete for that information,.

Let me know if you have any trouble.

Shannon

[Parvaneh Zand]

Hi @PK_KP 

I haven't heard about inactive groups. Do you mean groups with no users?

[PK_KP]

Yes the groups which are empty without any users