Query: azuread_group_not_public

select
  id as resource,
  case
    when visibility = 'Public' then 'alarm'
    else 'ok'
  end status,
  case
    when visibility = 'Public' then title || ' is public.'
    else title || ' is not public.'
  end reason
  
  , tenant_id as tenant_id
from
  azuread_group;