turbot/alicloud

GitHub
steampipe plugin install alicloudsteampipe plugin install alicloud
alicloud_accountalicloud_action_trailalicloud_cas_certificatealicloud_cms_monitor_hostalicloud_cs_kubernetes_clusteralicloud_cs_kubernetes_cluster_nodealicloud_ecs_auto_provisioning_groupalicloud_ecs_autoscaling_groupalicloud_ecs_diskalicloud_ecs_disk_metric_read_iopsalicloud_ecs_disk_metric_read_iops_dailyalicloud_ecs_disk_metric_read_iops_hourlyalicloud_ecs_disk_metric_write_iopsalicloud_ecs_disk_metric_write_iops_dailyalicloud_ecs_disk_metric_write_iops_hourlyalicloud_ecs_imagealicloud_ecs_instancealicloud_ecs_instance_metric_cpu_utilization_dailyalicloud_ecs_instance_metric_cpu_utilization_hourlyalicloud_ecs_key_pairalicloud_ecs_launch_templatealicloud_ecs_network_interfacealicloud_ecs_regionalicloud_ecs_security_groupalicloud_ecs_snapshotalicloud_ecs_zonealicloud_kms_keyalicloud_kms_secretalicloud_oss_bucketalicloud_ram_access_keyalicloud_ram_credential_reportalicloud_ram_groupalicloud_ram_password_policyalicloud_ram_policyalicloud_ram_rolealicloud_ram_security_preferencealicloud_ram_useralicloud_rds_backupalicloud_rds_databasealicloud_rds_instancealicloud_rds_instance_metric_connectionsalicloud_rds_instance_metric_connections_dailyalicloud_rds_instance_metric_cpu_utilizationalicloud_rds_instance_metric_cpu_utilization_dailyalicloud_rds_instance_metric_cpu_utilization_hourlyalicloud_security_center_field_statisticsalicloud_security_center_versionalicloud_slb_load_balanceralicloud_vpcalicloud_vpc_dhcp_options_setalicloud_vpc_eipalicloud_vpc_flow_logalicloud_vpc_nat_gatewayalicloud_vpc_network_aclalicloud_vpc_route_entryalicloud_vpc_route_tablealicloud_vpc_ssl_vpn_client_certalicloud_vpc_ssl_vpn_serveralicloud_vpc_vpn_connectionalicloud_vpc_vpn_customer_gatewayalicloud_vpc_vpn_gatewayalicloud_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.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
access_key_idtextThe AccessKey ID.
account_idtextThe Alicloud Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
create_datetimestamp with time zoneThe time when the AccessKey pair was created.
regiontextThe Alicloud region in which the resource is located.
statustextThe status of the AccessKey pair. Valid values: Active and Inactive.
titletextTitle of the resource.
user_nametextName of the User that the access key belongs to.