turbot/azure

steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_api_managementazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_application_security_groupazure_compute_availability_setazure_compute_diskazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_diagnostic_settingazure_express_route_circuitazure_firewallazure_key_vaultazure_key_vault_keyazure_key_vault_secretazure_kubernetes_clusterazure_locationazure_log_alertazure_log_profileazure_management_lockazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_resource_groupazure_role_assignmentazure_role_definitionazure_route_tableazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_settingazure_security_center_subscription_pricingazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_express_route_circuit

An ExpressRoute circuit represents a logical connection between your on-premises infrastructure and Microsoft cloud services through a connectivity provider. You can order multiple ExpressRoute circuits. Each circuit can be in the same or different regions, and can be connected to your premises through different connectivity providers.

Examples

Basic info

select
name,
id,
allow_classic_operations,
circuit_provisioning_state
from
azure_express_route_circuit;

List express route circuits with global reach enabled

select
name,
sku_tier,
sku_name
from
azure_express_route_circuit
where
global_reach_enabled;

List premium express route circuits

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

.inspect azure_express_route_circuit

Azure Express Route Circuit

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
allow_classic_operationsbooleanAllow classic operations.
authorizationsjsonbThe list of authorizations.
bandwidth_in_gbpsdouble precisionThe bandwidth of the circuit when the circuit is provisioned on an ExpressRoutePort resource.
circuit_provisioning_statetextThe CircuitProvisioningState state of the resource.
etagtextAn unique read-only string that changes whenever the resource is updated.
express_route_portjsonbThe reference to the ExpressRoutePort resource when the circuit is provisioned on an ExpressRoutePort resource.
global_reach_enabledbooleanFlag denoting global reach status.
idtextResource ID.
nametextThe friendly name that identifies the circuit.
peeringsjsonbThe list of peerings.
provisioning_statetextThe provisioning state of the express route circuit resource. Possible values include: 'Succeeded', 'Updating', 'Deleting', 'Failed'.
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
service_keytextThe ServiceKey.
service_provider_notestextThe ServiceProviderNotes.
service_provider_propertiesjsonbThe ServiceProviderProperties.
service_provider_provisioning_statetextThe ServiceProviderProvisioningState state of the resource. Possible values include: 'NotProvisioned', 'Provisioning', 'Provisioned', 'Deprovisioning'.
sku_familytextThe family of the SKU. Possible values include: 'UnlimitedData', 'MeteredData'.
sku_nametextThe name of the SKU.
sku_tiertextThe tier of the SKU. Possible values include: 'Standard', 'Premium', 'Basic', 'Local'.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.