Control: Ensure Multi-factor Authentication is required for Azure Management

powerpipe control run azure_compliance.control.iam_conditional_access_mfa_enabled

powerpipe login
powerpipe control run azure_compliance.control.iam_conditional_access_mfa_enabled --share

with distinct_tenant as (
  select
    distinct tenant_id,
    subscription_id,
    _ctx
  from
    azure_tenant
)
select
  p.id as resource,
  case
    when p.built_in_controls @> '["mfa"]' then 'ok'
    else 'alarm'
  end as status,
  case
    when p.built_in_controls @> '["mfa"]' then p.display_name || ' MFA enabled.'
    else p.display_name || ' MFA disabled.'
  end as reason,
  t.tenant_id
  
from
  distinct_tenant as t,
  azuread_conditional_access_policy as p;