Skip to main content

express_route_gateways

Creates, updates, deletes, gets or lists an express_route_gateways resource.

Overview

Nameexpress_route_gateways
TypeResource
Idazure.network.express_route_gateways

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
endTimeUtcstringTime when the test was completed.
failoverConnectionDetailsarrayList of all the failover connections for this peering location.
nonRedundantRoutesarrayList of al the routes that were received only from this peering location.
peeringLocationstringPeering location of the test.
redundantRoutesarrayList of routes received from this peering as well as some other peering location.
startTimeUtcstringTime when the test was started.
statusstringThe current status of the test. Known values are: "NotStarted", "Starting", "Running", "StartFailed", "Stopping", "Completed", "StopFailed", "Invalid", and "Expired". (NotStarted, Starting, Running, StartFailed, Stopping, Completed, StopFailed, Invalid, Expired)
wasSimulationSuccessfulbooleanWhether the failover simulation was successful or not.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_failover_single_test_detailsselectresource_group_name, express_route_gateway_name, subscription_id, peeringLocation, failoverTestIdRetrieves the details of a particular failover test performed on the ExpressRoute gateway based on the test Guid.
getselectresource_group_name, express_route_gateway_name, subscription_idFetches the details of a ExpressRoute gateway in a resource group.
list_by_resource_groupselectresource_group_name, subscription_idLists ExpressRoute gateways in a given resource group.
list_by_subscriptionselectsubscription_idLists ExpressRoute gateways under a given subscription.
create_or_updateinsertresource_group_name, express_route_gateway_name, subscription_idCreates or updates a ExpressRoute gateway in a specified resource group.
update_tagsupdateresource_group_name, express_route_gateway_name, subscription_idUpdates express route gateway tags.
create_or_updatereplaceresource_group_name, express_route_gateway_name, subscription_idCreates or updates a ExpressRoute gateway in a specified resource group.
deletedeleteresource_group_name, express_route_gateway_name, subscription_idDeletes the specified ExpressRoute gateway in a resource group. An ExpressRoute gateway resource can only be deleted when there are no connection subresources.
get_failover_all_tests_detailsexecresource_group_name, express_route_gateway_name, subscription_idtype, fetchLatestRetrieves the details of all the failover tests performed on the ExpressRoute gateway for different peering locations.
get_routes_informationexecresource_group_name, express_route_gateway_name, subscription_idattemptRefreshRetrieves the route sets information for the ExpressRoute gateway.
get_resiliency_informationexecresource_group_name, express_route_gateway_name, subscription_idattemptRefreshRetrieves the resiliency information for the ExpressRoute gateway.
start_site_failover_testexecresource_group_name, express_route_gateway_name, subscription_id, peeringLocationStarts failover simulation on the ExpressRoute gateway for the specified peering location.
stop_site_failover_testexecresource_group_name, express_route_gateway_name, subscription_idStops failover simulation on the ExpressRoute gateway for the specified peering location.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
express_route_gateway_namestringThe name of the ExpressRoute gateway. Required.
failoverTestIdstringThe unique Guid value which identifies the test. Required.
peeringLocationstringPeering location of the test. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
attemptRefreshbooleanWhether to attempt a refresh of the resiliency information. Default value is None.
fetchLatestbooleanFetch only the latest tests for each peering location. Default value is None.
typestringThe type of failover test. Default value is None.

SELECT examples

Retrieves the details of a particular failover test performed on the ExpressRoute gateway based on the test Guid.

SELECT
endTimeUtc,
failoverConnectionDetails,
nonRedundantRoutes,
peeringLocation,
redundantRoutes,
startTimeUtc,
status,
wasSimulationSuccessful
FROM azure.network.express_route_gateways
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND peeringLocation = '{{ peeringLocation }}' -- required
AND failoverTestId = '{{ failoverTestId }}' -- required
;

INSERT examples

Creates or updates a ExpressRoute gateway in a specified resource group.

INSERT INTO azure.network.express_route_gateways (
id,
location,
tags,
properties,
resource_group_name,
express_route_gateway_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ express_route_gateway_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
location,
properties,
tags,
type
;

UPDATE examples

Updates express route gateway tags.

UPDATE azure.network.express_route_gateways
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

REPLACE examples

Creates or updates a ExpressRoute gateway in a specified resource group.

REPLACE azure.network.express_route_gateways
SET
id = '{{ id }}',
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

DELETE examples

Deletes the specified ExpressRoute gateway in a resource group. An ExpressRoute gateway resource can only be deleted when there are no connection subresources.

DELETE FROM azure.network.express_route_gateways
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Retrieves the details of all the failover tests performed on the ExpressRoute gateway for different peering locations.

EXEC azure.network.express_route_gateways.get_failover_all_tests_details 
@resource_group_name='{{ resource_group_name }}' --required,
@express_route_gateway_name='{{ express_route_gateway_name }}' --required,
@subscription_id='{{ subscription_id }}' --required,
@type='{{ type }}',
@fetchLatest={{ fetchLatest }}
;