steampipe plugin install azuresteampipe plugin install azure

Table: azure_express_route_circuit - Query Azure Express Route Circuits using SQL

Azure Express Route Circuits is a dedicated connectivity option in Microsoft Azure that enables users to create private connections between Azure datacenters and infrastructure on their premises or in a colocation environment. It provides a more reliable, faster, and lower-latency network connection than typical internet-based connections. Express Route Circuits are highly beneficial for bandwidth-heavy tasks, data migration, and secure connectivity needs.

Table Usage Guide

The azure_express_route_circuit table provides insights into Express Route Circuits within Microsoft Azure. As a Network Administrator, explore circuit-specific details through this table, including peering information, service provider details, and bandwidth. Utilize it to monitor the performance and status of each Express Route Circuit, ensuring optimal connectivity and performance for your Azure resources.

Examples

Basic info

Explore the status and settings of your Azure Express Route Circuits to understand their operational capabilities and provisioning state. This can assist in managing and optimizing your network connectivity.

select
  name,
  id,
  allow_classic_operations,
  circuit_provisioning_state
from
  azure_express_route_circuit;

select
  name,
  id,
  allow_classic_operations,
  circuit_provisioning_state
from
  azure_express_route_circuit;

List express route circuits with global reach enabled

Explore the express route circuits in your Azure environment that have global reach enabled. This is useful for assessing the scale of your network connectivity and understanding the associated costs.

select
  name,
  sku_tier,
  sku_name
from
  azure_express_route_circuit
where
  global_reach_enabled;

select
  name,
  sku_tier,
  sku_name
from
  azure_express_route_circuit
where
  global_reach_enabled = 1;

List premium express route circuits

Explore which express route circuits in your Azure environment are categorized as 'Premium'. This can be useful for understanding your network infrastructure and identifying areas for potential cost optimization.

select
  name,
  sku_tier,
  sku_name
from
  azure_express_route_circuit
where
  sku_tier = 'Premium';

select
  name,
  sku_tier,
  sku_name
from
  azure_express_route_circuit
where
  sku_tier = 'Premium';

Query examples

Schema for azure_express_route_circuit

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
allow_classic_operations	boolean		Allow classic operations.
authorizations	jsonb		The list of authorizations.
bandwidth_in_gbps	double precision		The bandwidth of the circuit when the circuit is provisioned on an ExpressRoutePort resource.
circuit_provisioning_state	text		The CircuitProvisioningState state of the resource.
cloud_environment	text		The Azure Cloud Environment.
etag	text		An unique read-only string that changes whenever the resource is updated.
express_route_port	jsonb		The reference to the ExpressRoutePort resource when the circuit is provisioned on an ExpressRoutePort resource.
global_reach_enabled	boolean		Flag denoting global reach status.
id	text		Resource ID.
name	text	=	The friendly name that identifies the circuit.
peerings	jsonb		The list of peerings.
provisioning_state	text		The provisioning state of the express route circuit resource. Possible values include: 'Succeeded', 'Updating', 'Deleting', 'Failed'.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
service_key	text		The ServiceKey.
service_provider_notes	text		The ServiceProviderNotes.
service_provider_properties	jsonb		The ServiceProviderProperties.
service_provider_provisioning_state	text		The ServiceProviderProvisioningState state of the resource. Possible values include: 'NotProvisioned', 'Provisioning', 'Provisioned', 'Deprovisioning'.
sku_family	text		The family of the SKU. Possible values include: 'UnlimitedData', 'MeteredData'.
sku_name	text		The name of the SKU.
sku_tier	text		The tier of the SKU. Possible values include: 'Standard', 'Premium', 'Basic', 'Local'.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.

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)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_express_route_circuit