app_session.sh
No OneTemporary
Actions

Subscribers

None

File Metadata

	#!/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