turbot/gcp_compliance

Query: project_access_approval_settings_enabled

Usage

powerpipe query gcp_compliance.query.project_access_approval_settings_enabled

Steampipe Tables

SQL

select
self_link as resource,
case
when access_approval_settings is not null and access_approval_settings -> 'notificationEmails' is not null then 'ok'
else 'alarm'
end as status,
case
when access_approval_settings is not null and access_approval_settings -> 'notificationEmails' is not null
then name || ' access approval is enabled.'
else name || ' access approval is disabled.'
end as reason
, project_id as project
from
gcp_project;

Controls

The query is being used by the following controls: