Table: alicloud_ecs_instance

An ECS instance is a virtual machine that contains basic computing components such as the vCPU, memory, operating system, network, and disk.

Examples

Basic Instance Info

Assess the elements within your Alibaba Cloud ECS instances to gain insights into their operational status, type, and network details. This can help in managing resources, ensuring optimal performance, and identifying potential issues.

select
  instance_id,
  name,
  arn,
  status,
  instance_type,
  os_name_en,
  public_ip_address,
  private_ip_address,
  zone
from
  alicloud_ecs_instance;

select
  instance_id,
  name,
  arn,
  status,
  instance_type,
  os_name_en,
  public_ip_address,
  private_ip_address,
  zone
from
  alicloud_ecs_instance;

List stopped instances that you are still being charged for

This query is useful for identifying instances that are in a stopped state but still incurring charges. It helps in managing costs by pinpointing areas where resources are not being optimally used.

select
  instance_id,
  name,
  status,
  stopped_mode,
  instance_type,
  os_name_en,
  public_ip_address,
  private_ip_address,
  zone
from
  alicloud_ecs_instance
where
  stopped_mode = 'KeepCharging';

select
  instance_id,
  name,
  status,
  stopped_mode,
  instance_type,
  os_name_en,
  public_ip_address,
  private_ip_address,
  zone
from
  alicloud_ecs_instance
where
  stopped_mode = 'KeepCharging';

List linux instances

Identify instances where the operating system is Linux. This is useful for managing resources or troubleshooting specific issues related to Linux-based instances.

select
  instance_id,
  name,
  instance_type,
  os_name_en,
  zone
from
  alicloud_ecs_instance
where
  os_type = 'linux';

select
  instance_id,
  name,
  instance_type,
  os_name_en,
  zone
from
  alicloud_ecs_instance
where
  os_type = 'linux';

Instance count in each zone

Determine the distribution of instances across various zones to balance and optimize resource allocation. This aids in planning infrastructure decisions and mitigating risk by avoiding over-reliance on a single zone.

select
  zone as az,
  count(*)
from
  alicloud_ecs_instance
group by
  zone;

select
  zone as az,
  count(*)
from
  alicloud_ecs_instance
group by
  zone;

Count the number of instances by instance type

Assess the distribution of different instance types within your Alicloud Elastic Compute Service to better understand your resource usage. This can aid in optimizing your allocation strategy and managing costs more effectively.

select
  instance_type,
  count(instance_type) as count
from
  alicloud_ecs_instance
group by
  instance_type;

select
  instance_type,
  count(instance_type) as count
from
  alicloud_ecs_instance
group by
  instance_type;

List of instances without application tag key

Identify instances where the 'application' tag key is missing, which could indicate a lack of necessary metadata for proper resource management and classification. This can be crucial for maintaining organized and efficient infrastructure in a cloud environment.

select
  instance_id,
  tags
from
  alicloud_ecs_instance
where
  tags ->> 'application' is null;

select
  instance_id,
  tags
from
  alicloud_ecs_instance
where
  json_extract(tags, '$.application') is null;

List of ECS instances provisioned with undesired(for example ecs.t5-lc2m1.nano and ecs.t6-c2m1.large is desired) instance type(s)

Identify instances where ECS instances are provisioned with undesired types, helping to manage resources and maintain preferred configurations.

select
  instance_type,
  count(*) as count
from
  alicloud_ecs_instance
where
  instance_type not in ('ecs.t5-lc2m1.nano', 'ecs.t6-c2m1.large')
group by
  instance_type;

select
  instance_type,
  count(*) as count
from
  alicloud_ecs_instance
where
  instance_type not in ('ecs.t5-lc2m1.nano', 'ecs.t6-c2m1.large')
group by
  instance_type;

List ECS instances having deletion protection safety feature disabled

Determine the areas in which Elastic Compute Service (ECS) instances might be at risk due to disabled deletion protection. This query is useful to identify potential vulnerabilities and ensure data safety.

select
  instance_id,
  deletion_protection
from
  alicloud_ecs_instance
where
  not deletion_protection;

select
  instance_id,
  deletion_protection
from
  alicloud_ecs_instance
where
  deletion_protection = 0;

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- alicloud

You can pass the configuration to the command with the --config argument:

steampipe_export_alicloud --config '<your_config>' alicloud_ecs_instance