get_org.sh
No OneTemporary
Actions

Subscribers

None

File Metadata

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