How to check at a time all groups in confluence using a DB server?

[ICICI Bank Atlassian Support Team]

How to check at a time all groups in confluence using a DB query server?

How to write a DB query about all groups at a time??

[Nic Brough -Adaptavist-]

I am sorry, I do not understand what you are looking for.

Forget the database, what would your report look like?  A list of groups?  With what other data?

[ICICI Bank Atlassian Support Team]

Dear Noc,

My question is, In confluence Database server I want to see all the groups at a time.

for example in 1 group to see using this below Database query, I want all group at a time using this DB below query

select DISTINCT u.lower_user_name, u.lower_email_address, g.group_name from cwd_user u inner join cwd_membership m on u.id=m.child_user_id inner join cwd_group g on g.id=m.parent_id where g.group_name='crmg-users' order by g.group_name;

[Nic Brough -Adaptavist-]

I still do not understand.  What does "all group at a time" look like if you could do it?  What question does it answer?