Query: Ensure that multifactor authentication is required to access Microsoft Admin Portals

Description

This recommendation ensures that users accessing Microsoft Admin Portals (i.e. Microsoft 365 Admin, Microsoft 365 Defender, Exchange Admin Center, Azure Portal, etc.) are required to use multi-factor authentication (MFA) credentials when logging into an Admin Portal.

Query

Tables used in this query:

• azure_tenant
• azuread_conditional_access_policy

Controls using this query:

• 5.2.7 Ensure that multifactor authentication is required to access Microsoft Admin Portals
• Ensure that multifactor authentication is required to access Microsoft Admin Portals

SQL