audit_project_mfa.sql
No One
Actions

Authored By

	epriestley
	Dec 9 2015, 4:25 PM

Size

364 B

Referenced Files

None

Subscribers

None

audit_project_mfa.sql
View Options

	SELECT
	u.username User, p.name Project, IF(f.id IS NULL, "NO", "YES") "Has MFA"
	FROM phabricator_user.user u
	LEFT JOIN phabricator_user.edge ue
	ON ue.src = u.phid AND ue.type = 14
	LEFT JOIN phabricator_project.project p ON ue.dst = p.phid
	LEFT JOIN phabricator_auth.auth_factorconfig f ON f.userPHID = u.phid
	WHERE p.name = 'Dog Project';