Skip to main content

sap_virtual_instances

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

Overview

Namesap_virtual_instances
TypeResource
Idazure_isv.sap_workloads.sap_virtual_instances

Fields

The following fields are returned by SELECT queries:

Describes the Virtual Instance for SAP solutions resource

NameDatatypeDescription
identityobjectA pre-created user assigned identity with appropriate roles assigned. To learn more on identity and roles required, visit the ACSS how-to-guide.
locationstringThe geo-location where the resource lives
propertiesobjectDefines the Virtual Instance for SAP solutions resource properties.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, sapVirtualInstanceNameGets a Virtual Instance for SAP solutions resource
list_by_resource_groupselectsubscriptionId, resourceGroupNameGets all Virtual Instances for SAP solutions resources in a Resource Group.
list_by_subscriptionselectsubscriptionIdGets all Virtual Instances for SAP solutions resources in a Subscription.
createinsertsubscriptionId, resourceGroupName, sapVirtualInstanceName, data__propertiesCreates a Virtual Instance for SAP solutions (VIS) resource
updateupdatesubscriptionId, resourceGroupName, sapVirtualInstanceNameUpdates a Virtual Instance for SAP solutions resource
deletedeletesubscriptionId, resourceGroupName, sapVirtualInstanceNameDeletes a Virtual Instance for SAP solutions resource and its child resources, that is the associated Central Services Instance, Application Server Instances and Database Instance.
startexecsubscriptionId, resourceGroupName, sapVirtualInstanceNameStarts the SAP application, that is the Central Services instance and Application server instances.
stopexecsubscriptionId, resourceGroupName, sapVirtualInstanceNameStops the SAP Application, that is the Application server instances and Central Services instance.

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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
sapVirtualInstanceNamestringThe name of the Virtual Instances for SAP solutions resource
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets a Virtual Instance for SAP solutions resource

SELECT
identity,
location,
properties,
tags
FROM azure_isv.sap_workloads.sap_virtual_instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}' -- required
;

INSERT examples

Creates a Virtual Instance for SAP solutions (VIS) resource

INSERT INTO azure_isv.sap_workloads.sap_virtual_instances (
data__tags,
data__location,
data__identity,
data__properties,
subscriptionId,
resourceGroupName,
sapVirtualInstanceName
)
SELECT
'{{ tags }}',
'{{ location }}',
'{{ identity }}',
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ sapVirtualInstanceName }}'
RETURNING
identity,
location,
properties,
tags
;

UPDATE examples

Updates a Virtual Instance for SAP solutions resource

UPDATE azure_isv.sap_workloads.sap_virtual_instances
SET
data__tags = '{{ tags }}',
data__identity = '{{ identity }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}' --required
RETURNING
identity,
location,
properties,
tags;

DELETE examples

Deletes a Virtual Instance for SAP solutions resource and its child resources, that is the associated Central Services Instance, Application Server Instances and Database Instance.

DELETE FROM azure_isv.sap_workloads.sap_virtual_instances
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}' --required
;

Lifecycle Methods

Starts the SAP application, that is the Central Services instance and Application server instances.

EXEC azure_isv.sap_workloads.sap_virtual_instances.start 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@sapVirtualInstanceName='{{ sapVirtualInstanceName }}' --required
;