Page MenuHomec4science

user_info.sh
No OneTemporary

File Metadata

Created
Fri, May 10, 01:56

user_info.sh

#!/bin/bash
username=$1
SQL="select u.phid, u.realName, c.fieldValue, from_unixtime(u.dateCreated) as dateCreated, ext.accountType, ext.accountID, ext.email, email.address from user as u left join user_email as email on email.userPHID=u.phid left join user_externalaccount as ext on ext.userPHID=u.phid left join user_configuredcustomfieldstorage as c on c.objectPHID=u.phid and fieldIndex='bt55gs3Z6lcv' where u.userName='${username}';"
ssh c4science-db01 "mysql -B -e \"$SQL\" phabricator_user"

Event Timeline