Skip to main content

provider_instances

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

Overview

Nameprovider_instances
TypeResource
Idazure_isv.hana_on_azure.provider_instances

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectProvider Instance properties

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, sapMonitorName, providerInstanceNameThe product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.
listselectsubscriptionId, resourceGroupName, sapMonitorNameThe product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.
createinsertsubscriptionId, resourceGroupName, sapMonitorName, providerInstanceNameThe product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.
deletedeletesubscriptionId, resourceGroupName, sapMonitorName, providerInstanceNameThe product Microsoft.Workloads/sapMonitors (AMS Classic) is officially retired as of May 31, 2023.

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
providerInstanceNamestringName of the provider instance.
resourceGroupNamestringName of the resource group.
sapMonitorNamestringName of the SAP monitor resource.
subscriptionIdstringSubscription ID which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

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

SELECT
properties
FROM azure_isv.hana_on_azure.provider_instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND sapMonitorName = '{{ sapMonitorName }}' -- required
AND providerInstanceName = '{{ providerInstanceName }}' -- required
;

INSERT examples

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

INSERT INTO azure_isv.hana_on_azure.provider_instances (
data__properties,
subscriptionId,
resourceGroupName,
sapMonitorName,
providerInstanceName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ sapMonitorName }}',
'{{ providerInstanceName }}'
RETURNING
properties
;

DELETE examples

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

DELETE FROM azure_isv.hana_on_azure.provider_instances
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND sapMonitorName = '{{ sapMonitorName }}' --required
AND providerInstanceName = '{{ providerInstanceName }}' --required
;