managed_gateways

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

Overview

Name	managed_gateways
Type	Resource
Id	azure.scom.managed_gateways

Fields

vw_managed_gateways

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
computer_name	text	field from the properties object
connection_status	text	field from the properties object
domain_name	text	field from the properties object
health_status	text	field from the properties object
install_type	text	field from the properties object
instanceName	text	field from the properties object
managedGatewayName	text	field from the properties object
management_server_endpoint	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_id	text	field from the properties object
resource_location	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
version	text	field from the properties object

managed_gateways

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	The properties of a gateway resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	instanceName, managedGatewayName, resourceGroupName, subscriptionId	Retrieve the details of the gateway resource.
create_or_update	INSERT	instanceName, managedGatewayName, resourceGroupName, subscriptionId	Create or update a gateway resource.
delete	DELETE	instanceName, managedGatewayName, resourceGroupName, subscriptionId	Remove a gateway resource.

SELECT examples

Retrieve the details of the gateway resource.

vw_managed_gateways

SELECT
id,
name,
computer_name,
connection_status,
domain_name,
health_status,
install_type,
instanceName,
managedGatewayName,
management_server_endpoint,
provisioning_state,
resourceGroupName,
resource_id,
resource_location,
subscriptionId,
type,
version
FROM azure.scom.vw_managed_gateways
WHERE instanceName = '{{ instanceName }}'
AND managedGatewayName = '{{ managedGatewayName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_gateways

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

INSERT example

Use the following StackQL query and manifest file to create a new managed_gateways resource.

All Properties

/*+ create */
INSERT INTO azure.scom.managed_gateways (
instanceName,
managedGatewayName,
resourceGroupName,
subscriptionId
)
SELECT 
'{{ instanceName }}',
'{{ managedGatewayName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}'
;

Manifest

- name: your_resource_model_name
  props: []

DELETE example

Deletes the specified managed_gateways resource.

/*+ delete */
DELETE FROM azure.scom.managed_gateways
WHERE instanceName = '{{ instanceName }}'
AND managedGatewayName = '{{ managedGatewayName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';