turbot/alicloud
steampipe plugin install alicloud

Table: alicloud_slb_load_balancer

Server Load Balancer (SLB) distributes network traffic across groups of backend servers to improve the service capability and application availability. It Includes Layer 4 Network Load Balancer (NLB), Layer 7 Application Load Balancer (ALB), and Classic Load Balancer (CLB). It is the Official Cloud-Native Gateway of Alibaba Cloud.

Examples

Basic info

Explore the status and details of your load balancers to understand their configuration and network type. This can help in managing network traffic and ensuring efficient distribution of workloads across resources.

select
load_balancer_name,
load_balancer_id,
load_balancer_status,
address,
address_type,
vpc_id,
network_type
from
alicloud_slb_load_balancer;
select
load_balancer_name,
load_balancer_id,
load_balancer_status,
address,
address_type,
vpc_id,
network_type
from
alicloud_slb_load_balancer;

Get VPC details associated with SLB load balancers

Determine the areas in which your SLB load balancers are associated with specific VPC details. This can help you gain insights into your load balancing configurations and how they interact with your virtual private cloud settings.

select
s.load_balancer_name,
s.load_balancer_id,
s.vpc_id,
v.is_default,
v.cidr_block
from
alicloud_slb_load_balancer as s,
alicloud_vpc as v;
select
s.load_balancer_name,
s.load_balancer_id,
s.vpc_id,
v.is_default,
v.cidr_block
from
alicloud_slb_load_balancer as s,
alicloud_vpc as v;

List SLB load balancers that have deletion protection enabled

Identify the instances where load balancers have deletion protection enabled. This is useful in ensuring the prevention of accidental deletion of critical load balancers.

select
load_balancer_name,
load_balancer_id,
load_balancer_status,
delete_protection
from
alicloud_slb_load_balancer
where
delete_protection = 'on';
The query provided is already compatible with SQLite.It does not use any PostgreSQL - specific functions
or data types that need to be converted.Therefore,
the SQLite query is the same as the PostgreSQL query: ` ` ` sql
select
load_balancer_name,
load_balancer_id,
load_balancer_status,
delete_protection
from
alicloud_slb_load_balancer
where
delete_protection = 'on';
### List SLB load balancers created in the last 30 days
Explore which load balancers have been created in the past month. This can be useful in monitoring recent activity and ensuring proper load distribution across your network.
```sql+postgres
select
load_balancer_name,
load_balancer_id,
load_balancer_status
from
alicloud_slb_load_balancer
where
create_time >= now() - interval '30' day;
select
load_balancer_name,
load_balancer_id,
load_balancer_status
from
alicloud_slb_load_balancer
where
create_time >= datetime('now', '-30 day');

Schema for alicloud_slb_load_balancer

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The Alicloud Account ID in which the resource is located.
addressinetThe service IP address of the SLB instance.
address_ip_versiontext=The IP version. Valid values: ipv4 and ipv6.
address_typetext=The network type of the SLB instance. Valid values: internet|intranet.
bandwidthbigintThe maximum bandwidth of the listener. Unit: Mbit/s.
create_timetimestamp with time zoneThe time when the SLB instance was created.
create_time_stamptimestamp with time zoneThe timestamp when the instance was created.
delete_protectiontextIndicates whether deletion protection is enabled for the SLB instance.
internet_charge_typetext=The metering method of Internet data transfer. Valid values: paybybandwidth|paybytraffic.
internet_charge_type_aliastextThe alias for metering method of Internet data transfer.
load_balancer_idtext=The ID of the SLB instance.
load_balancer_nametext=The name of the SLB instance.
load_balancer_spectextThe specification of the SLB instance.
load_balancer_statustext=The status of the SLB instance. Valid values: inactive|active|locked.
master_zone_idtext=The ID of the primary zone to which the SLB instance belongs.
modification_protection_reasontextThe reason why the configuration read-only mode is enabled.
modification_protection_statustextIndicates whether the configuration read-only mode is enabled for the SLB instance.
network_typetext=The network type of the internal-facing SLB instance. Valid values: vpc|classic.
pay_typetextThe billing method of the SLB instance. Valid values: PayOnDemand.
regiontextThe Alicloud region in which the resource is located.
resource_group_idtext=The ID of the resource group.
slave_zone_idtextThe ID of the secondary zone to which the SLB instance belongs.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagstextA map of tags for the resource.
tags_srcjsonbA list of tags.
titletextTitle of the resource.
v_switch_idtext=The ID of the vSwitch to which the SLB instance belongs.
vpc_idtext=The ID of the virtual private cloud (VPC) to which the SLB instance belongs.

Export

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_slb_load_balancer