Query: Ensure trusted locations are defined

Description

Microsoft Entra ID Conditional Access allows an organization to configure Named locations and configure whether those locations are trusted or untrusted. These settings provide organizations the means to specify Geographical locations for use in conditional access policies, or define actual IP addresses and IP ranges and whether or not those IP addresses and/or ranges are trusted by the organization.

Query

Tables used in this query:

• azure_tenant
• azuread_conditional_access_named_location

Controls using this query:

• 1.2.1 Ensure Trusted Locations Are Defined
• 1.2.1 Ensure Trusted Locations Are Defined
• 1.2.1 Ensure Trusted Locations Are Defined
• 2.2.1 Ensure Trusted Locations Are Defined
• 6.2.1 Ensure that 'trusted locations' are defined
• Ensure trusted locations are defined

SQL