Hello. Over the years, our colleagues have created many private channels where they communicate with specific people. Now my boss wants to know which channels are used by whom and which channels are unused and can be deleted. Since no one is in all groups, this probably has to be done through the C…

Hello, @VincentVegas I have this SQL query that I use to extract information of the users from each team and channel including their membership. SELECT DISTINCT u.Username, t.DisplayName AS TeamName, c.DisplayName AS ChannelName, cm.SchemeUser AS User, cm.SchemeAdmin AS Admin FROM ChannelMembers A…

A list of all channels with all users in them

Troubleshooting

VincentVegas (Thomas F.) August 3, 2020, 10:05am 3

Thanks, that works quite well.

Regards,
Thomas

1 Like

Topic		Replies	Views
Re-join to empty Private Group Troubleshooting	6	5166	May 8, 2017
Get all channels a user is involved (Public, Private and Direct Messages) Troubleshooting	3	6373	February 8, 2024
Mmctl channel user list doesn't exist? Troubleshooting	5	981	December 20, 2024
Can't find the user when adding into channel Troubleshooting	3	767	July 21, 2021
List channels that a user is "channel admin" in? Troubleshooting	3	445	March 21, 2023

A list of all channels with all users in them

Related topics