directory_user_2fa_enrolleddirectory_user_admin_2fa_enrolleddirectory_user_admin_countdirectory_user_admin_max_countdirectory_user_is_delegated_admindrive_domain_restrictiondrive_members_only_accessdrive_viewer_restrictionsgmail_auto_forwarding_disabledgmail_delegation_disabledgmail_pop_imap_disabledgroups_admin_created_only
Query: directory_user_admin_count
Usage
powerpipe query googleworkspace_compliance.query.directory_user_admin_count
Steampipe Tables
SQL
with super_admins as ( select count(*) as count from googledirectory_user where is_admin = true)select 'organization' as resource, case when count > 1 then 'ok' else 'alarm' end as status, 'Found ' || count || ' super admin account(s).' as reasonfrom super_admins;
Controls
The query is being used by the following controls: