Skip to main content

provider_instances

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

Overview

Nameprovider_instances
TypeResource
Idazure_isv.workloads.provider_instances

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
errorsobjectDefines the provider instance errors.
identityobject[currently not in use] Managed service identity(user assigned identities).
providerSettingsobjectDefines the provider specific properties.
provisioningStatestringState of provisioning of the provider instance. Known values are: "Accepted", "Creating", "Updating", "Failed", "Succeeded", "Deleting", and "Migrating".
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, monitor_name, provider_instance_name, subscription_idGets properties of a provider instance. Gets properties of a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.
listselectresource_group_name, monitor_name, subscription_idGets a list of provider instances in the specified SAP monitor. Gets a list of provider instances in the specified SAP monitor. The operations returns various properties of each provider instances.
createinsertresource_group_name, monitor_name, provider_instance_name, subscription_idCreates a provider instance. Creates a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.
deletedeleteresource_group_name, monitor_name, provider_instance_name, subscription_idDeletes a provider instance. Deletes a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

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
monitor_namestringName of the SAP monitor resource. Required.
provider_instance_namestringName of the provider instance. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets properties of a provider instance. Gets properties of a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

SELECT
id,
name,
errors,
identity,
providerSettings,
provisioningState,
systemData,
type
FROM azure_isv.workloads.provider_instances
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND monitor_name = '{{ monitor_name }}' -- required
AND provider_instance_name = '{{ provider_instance_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a provider instance. Creates a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

INSERT INTO azure_isv.workloads.provider_instances (
identity,
properties,
resource_group_name,
monitor_name,
provider_instance_name,
subscription_id
)
SELECT
'{{ identity }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ monitor_name }}',
'{{ provider_instance_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
properties,
systemData,
type
;

DELETE examples

Deletes a provider instance. Deletes a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

DELETE FROM azure_isv.workloads.provider_instances
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND monitor_name = '{{ monitor_name }}' --required
AND provider_instance_name = '{{ provider_instance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;