Statistics with SQL request

Hello,

In the administration panel, and in the statistics menu, we can see the total of activ user, public/private channel and total of messages by team.

Is there by any chance a way to have the same kind of information with SQL request ? (So i can have all those stats at one with one request)

Or if you have another solution, it would be great.

Thank you.

Josselin

Hi there, @jpuchois

If I understand correctly, you would like to have some sort of SQL transaction logging to capture the number of SQL requests made to the database hosting the Mattermost server from the System Console > Reporting page. I hope I am getting the right idea.

If yes, I don’t think Mattermost has this feature yet but perhaps you can consider the usage of General Query and Binary Log that needs to be set up on MySQL level.