turbot/alicloud_insights

Query: ecs_instance_dedicated_host

Usage

powerpipe query alicloud_insights.query.ecs_instance_dedicated_host

Steampipe Tables

SQL

select
dedicated_host_name as "Name",
dedicated_host_id as "ID",
dedicated_host_cluster_id as "Cluster ID",
dedicated_instance_affinity as "Instance Affinity",
dedicated_instance_tenancy as "Instance Tenancy"
from
alicloud_ecs_instance
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: