Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F62217332
get_org.sh
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Sat, May 11, 17:10
Size
277 B
Mime Type
text/x-shellscript
Expires
Mon, May 13, 17:10 (1 d, 23 h)
Engine
blob
Format
Raw Data
Handle
17266274
Attached To
rPHINFRA c4science
get_org.sh
View Options
#!/bin/bash
SQL
=
"select right(accountID, length(accountID)-INSTR(accountID, '@')) as domain,
count(*) as count from user_externalaccount where accountType='shibboleth'
group by domain order by count desc;"
ssh c4science-db01
"mysql -B -e \"$SQL\" phabricator_user"
Event Timeline
Log In to Comment