turbot/steampipe-mod-alicloud-insights

Dashboard: AliCloud ECS Disk Detail

This dashboard answers the following questions for each disk:

  • How is the disk configured?
  • What relationships does the disk have with other resources?
  • What tags are applied?
  • What instances is it attached to?
  • How is encryption configured?
  • What is the read and write throughput?
This dashboard contains 6 cards, 1 graph, 1 input and 4 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-alicloud-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select AliCloud ECS Disk Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run alicloud_insights.dashboard.ecs_disk_detail --share

Queries

This dashboard uses the the following queries:
select
i.instance_id as "Instance ID",
i.name as "Name",
i.arn as "Instance ARN",
i.status as "Instance State",
attachment ->> 'AttachedTime' as "Attachment Time"
from
alicloud_ecs_disk as v,
jsonb_array_elements(attachments) as attachment,
alicloud_ecs_instance as i
where
i.instance_id = attachment ->> 'InstanceId'
and v.arn = $1
and v.account_id = split_part($1, ':', 5)
and v.region = split_part($1, ':', 4)
order by
i.instance_id;

Tags