diff --git a/utils/get_users_email.sh b/utils/get_users_email.sh
new file mode 100755
index 0000000..a7b9682
--- /dev/null
+++ b/utils/get_users_email.sh
@@ -0,0 +1,5 @@
+#!/bin/bash
+
+SQL="select 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 email.address like '%epfl.ch';"
+
+ssh c4science-db01 "mysql -B -e \"$SQL\" phabricator_user" | sort -u