turbot/alicloud_insights

Query: ecs_snapshot_by_encryption_status

Usage

powerpipe query alicloud_insights.query.ecs_snapshot_by_encryption_status

Steampipe Tables

SQL

select
encryption_status,
count(*) as "Snapshots"
from (
select encrypted,
case when encrypted then
'enabled'
else
'disabled'
end encryption_status
from
alicloud_ecs_snapshot) as t
group by
encryption_status
order by
encryption_status;

Dashboards

The query is used in the dashboards: