Query: Ensure guest users are reviewed on a monthly basis

Description

Guest users allow you to share your company's applications and services with users from any other organization, while maintaining control over your own corporate data. Guest users should be review on a monthly basis to ensure that inactive and unneeded accounts are removed.

Query

Tables used in this query:

• azure_tenant
• azuread_user

Controls using this query:

• 1.3 Ensure guest users are reviewed on a monthly basis
• 1.3 Ensure guest users are reviewed on a monthly basis
• 1.4 Ensure Guest Users Are Reviewed on a Regular Basis
• 1.4 Ensure Guest Users Are Reviewed on a Regular Basis
• 1.5 Ensure Guest Users Are Reviewed on a Regular Basis
• 2.4 Ensure Guest Users Are Reviewed on a Regular Basis
• 5.3.2 Ensure that guest users are reviewed on a regular basis
• 6.3.2 Ensure that guest users are reviewed on a regular basis
• Ensure guest users are reviewed on a monthly basis

SQL