provider_instances

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

Overview

Name	provider_instances
Type	Resource
Id	azure_isv.sap_workloads.provider_instances

Fields

vw_provider_instances

Name	Datatype	Description
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.
monitorName	text	field from the properties object
providerInstanceName	text	field from the properties object
provider_settings	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

provider_instances

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.
properties	object	Describes the properties of a provider instance.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	monitorName, providerInstanceName, resourceGroupName, subscriptionId	Gets properties of a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.
list	SELECT	monitorName, resourceGroupName, subscriptionId	Gets a list of provider instances in the specified SAP monitor. The operations returns various properties of each provider instances.
create	INSERT	monitorName, providerInstanceName, resourceGroupName, subscriptionId	Creates a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.
delete	DELETE	monitorName, providerInstanceName, resourceGroupName, subscriptionId	Deletes a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

SELECT examples

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

vw_provider_instances

SELECT
errors,
identity,
monitorName,
providerInstanceName,
provider_settings,
provisioning_state,
resourceGroupName,
subscriptionId
FROM azure_isv.sap_workloads.vw_provider_instances
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

provider_instances

SELECT
identity,
properties
FROM azure_isv.sap_workloads.provider_instances
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

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: providerSettings
          value:
            - name: providerType
              value: string

DELETE example

Deletes the specified provider_instances resource.

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