user_stats.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"