turbot/alicloud_insights

Query: oss_bucket_logging_table

Usage

powerpipe query alicloud_insights.query.oss_bucket_logging_table

SQL

select
b.name as "Name",
case
when b.logging ->> 'TargetBucket' <> '' then 'Enabled'
else null
end as "Logging",
b.logging ->> 'TargetBucket' as "Target Bucket",
b.logging ->> 'TargetPrefix' as "Target Prefix",
b.arn as "ARN",
a.title as "Account",
b.account_id as "Account ID",
b.region as "Region"
from
alicloud_oss_bucket as b,
alicloud_account as a
where
b.account_id = a.account_id
order by
b.name;

Dashboards

The query is used in the dashboards: