app_session.sh
f70579a7d63fmaster

app_session.sh
View Options

			#!/bin/bash

			REQ="select u.username,s.type,s.sessionKey,DATE_FORMAT(FROM_UNIXTIME(s.sessionStart), '\''%e %b %Y %H:%m'\'') as dd from phabricator_session as s join user as u on u.phid=s.userPHID order by s.sessionStart;"
			DB='phabricator_user'

			ssh c4science-db00 "mysql -e '$REQ' $DB" 2> /dev/null