Query: 4.1.1.1 (L1) Ensure 2-Step Verification (Multi-Factor Authentication) is enforced for all users in administrative roles

Description

Enforce 2-Step Verification (Multi-Factor Authentication) for all users assigned administrative roles.

Query

Tables used in this query:

• googledirectory_role
• googledirectory_role_assignment
• googledirectory_user

Controls using this query:

• 4.1.1.1 (L1) Ensure 2-Step Verification (Multi-Factor Authentication) is enforced for all users in administrative roles

SQL