This repository contains a series of scripts that I have written for Mattermost to perform descrete tasks. I am sharing them here in case other Mattermost users might find them useful.
Import Note: This code is provided as-is without any warranty and is not sponsored, supported, or endorsed by Mattermost, Inc. Please use cautiously and test before running any of these scripts against a production server.
The following queries have been tested on MySQL 5.7.24:
- get_number_of_posts_in_public_private_channels.sql - This query retrieves the total number of posts in the database for Public ('O') and Private ('P') channels. This includes posts that are marked as deleted or edited so the number will be larger than the total number of posts visible to users in Mattermost
- get_posts_by_team_and_channel.sql - The query retrieves a list of active channels by team and the total number of posts in each channel ordered by Team and Channel. This query returns only Public ('O') and Private ('P') channels and posts that are visible (not deleted or past revisions of edited posts).
- get_users_in_channels.sql - The following SQL query retrieves a list of active channels and the active users that are members of the channel ordered by Team, Channel, LastName and Username fields. Returns only Public ('O') and Private ('P') channels.
- get_users_in_teams.sql - The following SQL query retrieves a list of users who are membersof active teams ordered by Team, LastName, and then Username.