turbot/alicloud_insights

Query: ecs_instance_overview

Usage

powerpipe query alicloud_insights.query.ecs_instance_overview

Steampipe Tables

SQL

select
tags ->> 'Name' as "Name",
instance_id as "Instance ID",
os_name_en as "OS Name",
network_type as "Network Type",
creation_time as "Creation Time",
billing_method as "Billing Method",
internet_charge_type as "Internet Charge Type",
title as "Title",
region as "Region",
account_id as "Account ID",
arn as "ARN"
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: