This is a query that gets session diagnostic information from the Mattermost database

mattermost_session_diagnostics.sql

-- 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,
	   FROM_UNIXTIME(s.ExpiresAt/1000) AS SessionExpireDate,
	   FROM_UNIXTIME(s.LastActivityAt/1000) AS SessionLastActivityDate,
	   s.Props
FROM Users u
	JOIN Sessions s ON s.UserId = u.Id
WHERE u.Id = '<User Id>';