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; } } }

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.

Accepted answers

Shannon S

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

All comments

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

Shannon S

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

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server