Skip to main content

managed_gateways

Creates, updates, deletes, gets or lists a managed_gateways resource.

Overview

Namemanaged_gateways
TypeResource
Idazure.scom.managed_gateways

Fields

The following fields are returned by SELECT queries:

Managed gateway retrieved successfully.

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectThe properties of a gateway resource.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, instanceName, managedGatewayNameRetrieve the details of the gateway resource.
create_or_updateinsertsubscriptionId, resourceGroupName, instanceName, managedGatewayNameCreate or update a gateway resource.
deletedeletesubscriptionId, resourceGroupName, instanceName, managedGatewayNameRemove a gateway resource.

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
instanceNamestringName of the SCOM managed instance.
managedGatewayNamestringThe gateway resource name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Retrieve the details of the gateway resource.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.scom.managed_gateways
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND instanceName = '{{ instanceName }}' -- required
AND managedGatewayName = '{{ managedGatewayName }}' -- required
;

INSERT examples

Create or update a gateway resource.

INSERT INTO azure.scom.managed_gateways (
subscriptionId,
resourceGroupName,
instanceName,
managedGatewayName
)
SELECT
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ instanceName }}',
'{{ managedGatewayName }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Remove a gateway resource.

DELETE FROM azure.scom.managed_gateways
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND instanceName = '{{ instanceName }}' --required
AND managedGatewayName = '{{ managedGatewayName }}' --required
;