turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_cms_monitor_host

Cloud Monitor provides the host monitoring feature to monitor hosts by using the Cloud Monitor agents that are installed on the hosts. The host monitoring feature allows to monitor Elastic Compute Service (ECS) or physical Linux and Windows instances of Alibaba Cloud.

Examples

Basic info

select
host_name,
instance_id,
is_aliyun_host ali_uid,
ip_group,
operating_system,
region
from
alicloud_cms_monitor_host;

Get the status of each host

select
host_name,
m ->> 'InstanceId' as instance_id,
m -> 'AutoInstall' as auto_install,
m -> 'Status' as status
from
alicloud_cms_monitor_host,
jsonb_array_elements(monitoring_agent_status) as m;

List hosts provided by Alibaba Cloud

select
host_name,
is_aliyun_host
from
alicloud_cms_monitor_host
where
is_aliyun_host;

.inspect alicloud_cms_monitor_host

Alicloud Cloud Monitor Host

NameTypeDescription
account_idtextThe Alicloud Account ID in which the resource is located.
agent_versiontextThe version of the Cloud Monitor agent.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
ali_uidbigintThe ID of the Alibaba Cloud account.
eip_addresstextThe elastic IP address (EIP) of the host.
eip_idtextThe ID of the EIP.
host_nametextThe name of the host.
instance_idtextThe ID of the instance.
instance_type_familytextThe type of the ECS instance.
ip_grouptextThe IP address of the host.
is_aliyun_hostbooleanIndicates whether the host is provided by Alibaba Cloud.
monitoring_agent_statusjsonbThe status of the Cloud Monitor agent.
nat_iptextThe IP address of the Network Address Translation (NAT) gateway.
network_typetextThe type of the network.
operating_systemtextThe operating system.
regiontextThe Alicloud region in which the resource is located.
serial_numbertextThe serial number of the host. A host that is not provided by Alibaba Cloud has a serial number instead of an instance ID.
titletextTitle of the resource.