monitors

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

Overview

Name	monitors
Type	Resource
Id	azure_isv.sap_workloads.monitors

Fields

vw_monitors

Name	Datatype	Description
app_location	text	field from the properties object
errors	text	field from the properties object
identity	text	A pre-created user assigned identity with appropriate roles assigned. To learn more on identity and roles required, visit the ACSS how-to-guide.
location	text	The geo-location where the resource lives
log_analytics_workspace_arm_id	text	field from the properties object
managed_resource_group_configuration	text	field from the properties object
monitorName	text	field from the properties object
monitor_subnet	text	field from the properties object
msi_arm_id	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
routing_preference	text	field from the properties object
storage_account_arm_id	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
zone_redundancy_preference	text	field from the properties object

monitors

Name	Datatype	Description
identity	object	A pre-created user assigned identity with appropriate roles assigned. To learn more on identity and roles required, visit the ACSS how-to-guide.
location	string	The geo-location where the resource lives
properties	object	Describes the properties of a SAP monitor.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	monitorName, resourceGroupName, subscriptionId	Gets properties of a SAP monitor for the specified subscription, resource group, and resource name.
list	SELECT	subscriptionId	Gets a list of SAP monitors in the specified subscription. The operations returns various properties of each SAP monitor.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets a list of SAP monitors in the specified resource group.
create	INSERT	monitorName, resourceGroupName, subscriptionId	Creates a SAP monitor for the specified subscription, resource group, and resource name.
delete	DELETE	monitorName, resourceGroupName, subscriptionId	Deletes a SAP monitor with the specified subscription, resource group, and SAP monitor name.
update	UPDATE	monitorName, resourceGroupName, subscriptionId	Patches the Tags field of a SAP monitor for the specified subscription, resource group, and SAP monitor name.

SELECT examples

Gets a list of SAP monitors in the specified subscription. The operations returns various properties of each SAP monitor.

vw_monitors

SELECT
app_location,
errors,
identity,
location,
log_analytics_workspace_arm_id,
managed_resource_group_configuration,
monitorName,
monitor_subnet,
msi_arm_id,
provisioning_state,
resourceGroupName,
routing_preference,
storage_account_arm_id,
subscriptionId,
tags,
zone_redundancy_preference
FROM azure_isv.sap_workloads.vw_monitors
WHERE subscriptionId = '{{ subscriptionId }}';

monitors

SELECT
identity,
location,
properties,
tags
FROM azure_isv.sap_workloads.monitors
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.sap_workloads.monitors (
monitorName,
resourceGroupName,
subscriptionId,
identity,
properties,
tags,
location
)
SELECT 
'{{ monitorName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ identity }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: identity
      value:
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: errors
          value: string
        - name: appLocation
          value: string
        - name: routingPreference
          value: string
        - name: zoneRedundancyPreference
          value: string
        - name: managedResourceGroupConfiguration
          value:
            - name: name
              value: string
        - name: logAnalyticsWorkspaceArmId
          value: string
        - name: monitorSubnet
          value: string
        - name: msiArmId
          value: string
        - name: storageAccountArmId
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a monitors resource.

/*+ update */
UPDATE azure_isv.sap_workloads.monitors
SET 
tags = '{{ tags }}',
identity = '{{ identity }}'
WHERE 
monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified monitors resource.

/*+ delete */
DELETE FROM azure_isv.sap_workloads.monitors
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';