turbot/microsoft365_compliance

Query: azuread_guest_user_info

Usage

powerpipe query microsoft365_compliance.query.azuread_guest_user_info

Steampipe Tables

SQL

select
id as resource,
case
when user_type = 'Guest' then 'info'
else 'skip'
end as status,
case
when user_type = 'Guest' then display_name || ' is guest user.'
else display_name || ' is ' || user_type || ' user.'
end as reason,
tenant_id as tenant_id
from
azuread_user;

Controls

The query is being used by the following controls: