provider_instances

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

Overview

Name	provider_instances
Type	Resource
Id	azure_isv.hana_on_azure.provider_instances

Fields

vw_provider_instances

Name	Datatype	Description
metadata	text	field from the properties object
properties	text	Describes the properties of a provider instance.
providerInstanceName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sapMonitorName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	field from the properties object

provider_instances

Name	Datatype	Description
properties	object	Describes the properties of a provider instance.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	providerInstanceName, resourceGroupName, sapMonitorName, subscriptionId	The product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.
list	SELECT	resourceGroupName, sapMonitorName, subscriptionId	The product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.
create	INSERT	providerInstanceName, resourceGroupName, sapMonitorName, subscriptionId	The product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.
delete	DELETE	providerInstanceName, resourceGroupName, sapMonitorName, subscriptionId	The product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.

SELECT examples

The product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.

vw_provider_instances

SELECT
metadata,
properties,
providerInstanceName,
provisioning_state,
resourceGroupName,
sapMonitorName,
subscriptionId,
type
FROM azure_isv.hana_on_azure.vw_provider_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapMonitorName = '{{ sapMonitorName }}'
AND subscriptionId = '{{ subscriptionId }}';

provider_instances

SELECT
properties
FROM azure_isv.hana_on_azure.provider_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapMonitorName = '{{ sapMonitorName }}'
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.hana_on_azure.provider_instances (
providerInstanceName,
resourceGroupName,
sapMonitorName,
subscriptionId,
properties
)
SELECT 
'{{ providerInstanceName }}',
'{{ resourceGroupName }}',
'{{ sapMonitorName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: type
          value: string
        - name: properties
          value: string
        - name: metadata
          value: string
        - name: provisioningState
          value: string

DELETE example

Deletes the specified provider_instances resource.

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