steampipe plugin install alicloudsteampipe plugin install alicloud

alicloud_account alicloud_action_trail alicloud_cas_certificate alicloud_cms_monitor_host alicloud_cs_kubernetes_cluster alicloud_cs_kubernetes_cluster_node alicloud_ecs_auto_provisioning_group alicloud_ecs_autoscaling_group alicloud_ecs_disk alicloud_ecs_disk_metric_read_iops alicloud_ecs_disk_metric_read_iops_daily alicloud_ecs_disk_metric_read_iops_hourly alicloud_ecs_disk_metric_write_iops alicloud_ecs_disk_metric_write_iops_daily alicloud_ecs_disk_metric_write_iops_hourly alicloud_ecs_image alicloud_ecs_instance alicloud_ecs_instance_metric_cpu_utilization_daily alicloud_ecs_instance_metric_cpu_utilization_hourly alicloud_ecs_key_pair alicloud_ecs_launch_template alicloud_ecs_network_interface alicloud_ecs_region alicloud_ecs_security_group alicloud_ecs_snapshot alicloud_ecs_zone alicloud_kms_key alicloud_kms_secret alicloud_oss_bucket alicloud_ram_access_key alicloud_ram_credential_report alicloud_ram_group alicloud_ram_password_policy alicloud_ram_policy alicloud_ram_role alicloud_ram_security_preference alicloud_ram_user alicloud_rds_backup alicloud_rds_database alicloud_rds_instance alicloud_rds_instance_metric_connections alicloud_rds_instance_metric_connections_daily alicloud_rds_instance_metric_cpu_utilization alicloud_rds_instance_metric_cpu_utilization_daily alicloud_rds_instance_metric_cpu_utilization_hourly alicloud_security_center_field_statistics alicloud_security_center_version alicloud_slb_load_balancer alicloud_vpc alicloud_vpc_dhcp_options_set alicloud_vpc_eip alicloud_vpc_flow_log alicloud_vpc_nat_gateway alicloud_vpc_network_acl alicloud_vpc_route_entry alicloud_vpc_route_table alicloud_vpc_ssl_vpn_client_cert alicloud_vpc_ssl_vpn_server alicloud_vpc_vpn_connection alicloud_vpc_vpn_customer_gateway alicloud_vpc_vpn_gateway alicloud_vpc_vswitch

Table: alicloud_ram_user

Access keys are long-term credentials for a RAM user. You can use access keys to sign programmatic requests to the Alibaba Cloud CLI or API (directly or using the Alibaba Cloud SDK).

Examples

List of access keys with their corresponding user name and date of creation

select
  access_key_id,
  user_name,
  create_date
from
  alicloud_ram_access_key;

List of access keys which are inactive

select
  access_key_id,
  user_name,
  status
from
  alicloud_ram_access_key
where
  status = 'Inactive';

Access key count by user name

select
  user_name,
  count (access_key_id) as access_key_count
from
  alicloud_ram_access_key
group by
  user_name;

Access keys older than 90 days

select
  access_key_id,
  user_name,
  status create_date,
  age(create_date)
from
  alicloud_ram_access_key
where
  create_date <= (current_date - interval '90' day)
order by
  create_date;

Query examples

.inspect alicloud_ram_access_key

Alibaba Cloud RAM User Access Key.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
access_key_id	text	The AccessKey ID.
account_id	text	The Alicloud Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
create_date	timestamp with time zone	The time when the AccessKey pair was created.
region	text	The Alicloud region in which the resource is located.
status	text	The status of the AccessKey pair. Valid values: Active and Inactive.
title	text	Title of the resource.
user_name	text	Name of the User that the access key belongs to.