icelander

#!/bin/ruby

require 'csv'
require 'yaml'
require 'httparty'
require 'uri'

# ## members_to_csv.rb
# 
# ### About

icelander

#!/bin/ruby

require 'uri'
require 'httparty'

# ## post_as_a_bot.rb
# 
# ### About
# 
# post_as_a_bot.rb is a Ruby script that posts a message in a Mattermost channel as a bot user

icelander

-- Gets all channel memberships for Open and Private channels
SELECT t.DisplayName as TeamName,
	   c.DisplayName as ChannelName,
	   c.Type, -- O is a public channel, P is a private channel
	   u.FirstName,
	   u.LastName,
	   u.Username,
	   u.Email,
	   IF (cm.LastViewedAt!=0, FROM_UNIXTIME((cm.LastViewedAt/1000)), 'Never') AS LastViewed
FROM ChannelMembers cm

icelander

-- Find diagnostic information for a specific user's sessions
SELECT u.Id as UserId, 
	   u.Username, 
	   u.Email,
	   s.Id As SessionId,
	   s.Roles,
	   s.DeviceId, -- For mobile sessions
   	   IF (s.ExpiresAt IS NOT NULL && s.ExpiresAt < (UNIX_TIMESTAMP() * 1000), "Expired", "Active") as SessionActive,
   	   IF (FROM_UNIXTIME(s.ExpiresAt/1000) IS NULL, "Token", "User") as SessionType, -- Tokens are bot or personal access tokens, User are sessions where the user logged in
	   FROM_UNIXTIME(s.CreateAt/1000) AS SessionCreateDate,

icelander

#!/bin/bash

## upgrade_mattermost.sh
#
## About
#
# This script was an attempt to automate upgrading Mattermost. Note the past 
# tense.
#
## Usage

icelander

Navigating The Mattermost Database

NOTE: I highly recommend using a SQL client like pgAdmin or MySQL Workbench

Update: If you want to find out how many people have logged into your Mattermost server in the last 90 days this query is much more perfomant than the one using the Audits table:

MySQL

SELECT COUNT(*)

icelander

#!/usr/bin/env ruby

require 'csv'
require 'yaml'
require 'httparty'
require 'uri'

# ## members_to_okta.rb
# 
# ### About

icelander

#!/usr/bin/env ruby

require 'smartsheet'

webhook_url = "https://mattermost.example.com/hooks/yu6twumt93n89cjibmhdgz6mpa"
smartsheet_api_key = "<SMARTSHEET API KEY>"
smartsheet_id = "<SMARTSHEET ID>" # File > Properties on sheet

# Initialize the client - use your access token here
smartsheet_client = Smartsheet::Client.new(token: smartsheet_api_key)

icelander

#!/usr/bin/env ruby

require 'rubygems'
require 'json'
require 'net-ldap'

###
## make_ldap_users.rb 
#
# This script automates the process of importing users from a Mattermost bulk

icelander

#!/bin/bash

timestamp_string=`date -Iseconds`
parent_dir=`pwd`
dirname="$HOSTNAME-$timestamp_string"
dirpath="$parent_dir/$dirname"
tarname="$dirname.tgz"
tarpath="$parent_dir/$tarname"

if [[ $1 == "--help" || $1 == "-h" ]]; then