We use Discourse for our volunteer run, member based organisation and I’d like to know if there is a quick way of getting a report of group membership. We currently have about 60 users and 20 groups as we use our Discourse to help run our organisation, especially where the shortfalls of email emerg…

[image] stephenz: I haven’t used this Data Query Explorer before. Is this something I’ll find at the CLI of my instance? It is a plugin. See Discourse Data Explorer [image] stephenz: By the looks of it, it seems a bit similar to SQL and Influx queries It’s SQL.

There might be a Data Explorer query which could surface that info for you? A list of each group, and the members in each group? That’s what you’re looking for?

@michebs maybe something you can assist with?

[image] codinghorror: A list of each group, and the members in each group? If this information is what you need, these queries can help you. ▶ LIST NAME GROUPS ▶ LIST GROUP AND MEMBERS ▶ LIST ALL GROUPS AND MEMBERS

Thanks @codinghorror @michebs . I haven’t used this Data Query Explorer before. Is this something I’ll find at the CLI of my instance? By the looks of it, it seems a bit similar to SQL and Influx queries

Making report on group membership?

Support

HAWK (Hawk) September 7, 2020, 3:36am 6

It is a plugin. See Discourse Data Explorer

It’s SQL.

Topic		Replies	Views
Allow users with access to a restricted category to see who else has access Feature	18	1449	February 16, 2026
Can I create a dashboard for a specific group inside the community? Data & reporting	3	615	June 28, 2023
Prioritize showing group members (not posts) on group landing page, describe groups, provide groups directory Feature	15	3813	July 11, 2017
Parent groups and sub-groups Feature groups	20	2133	June 16, 2025
Groups link to group? Feature	5	2055	March 13, 2017

Making report on group membership?

Related topics