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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Alicloud Account ID in which the resource is located.
address	inet		The service IP address of the SLB instance.
address_ip_version	text	=	The IP version. Valid values: ipv4 and ipv6.
address_type	text	=	The network type of the SLB instance. Valid values: internet\|intranet.
bandwidth	bigint		The maximum bandwidth of the listener. Unit: Mbit/s.
create_time	timestamp with time zone		The time when the SLB instance was created.
create_time_stamp	timestamp with time zone		The timestamp when the instance was created.
delete_protection	text		Indicates whether deletion protection is enabled for the SLB instance.
internet_charge_type	text	=	The metering method of Internet data transfer. Valid values: paybybandwidth\|paybytraffic.
internet_charge_type_alias	text		The alias for metering method of Internet data transfer.
load_balancer_id	text	=	The ID of the SLB instance.
load_balancer_name	text	=	The name of the SLB instance.
load_balancer_spec	text		The specification of the SLB instance.
load_balancer_status	text	=	The status of the SLB instance. Valid values: inactive\|active\|locked.
master_zone_id	text	=	The ID of the primary zone to which the SLB instance belongs.
modification_protection_reason	text		The reason why the configuration read-only mode is enabled.
modification_protection_status	text		Indicates whether the configuration read-only mode is enabled for the SLB instance.
network_type	text	=	The network type of the internal-facing SLB instance. Valid values: vpc\|classic.
pay_type	text		The billing method of the SLB instance. Valid values: PayOnDemand.
region	text		The Alicloud region in which the resource is located.
resource_group_id	text	=	The ID of the resource group.
slave_zone_id	text		The ID of the secondary zone to which the SLB instance belongs.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	text		A map of tags for the resource.
tags_src	jsonb		A list of tags.
title	text		Title of the resource.
v_switch_id	text	=	The ID of the vSwitch to which the SLB instance belongs.
vpc_id	text	=	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