sap_virtual_instances

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

Overview

Name	sap_virtual_instances
Type	Resource
Id	azure_isv.sap_workloads.sap_virtual_instances

Fields

vw_sap_virtual_instances

Name	Datatype	Description
configuration	text	field from the properties object
environment	text	field from the properties object
errors	text	field from the properties object
health	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.
location	text	The geo-location where the resource lives
managed_resource_group_configuration	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sapVirtualInstanceName	text	field from the properties object
sap_product	text	field from the properties object
state	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

sap_virtual_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.
location	string	The geo-location where the resource lives
properties	object	Defines the Virtual Instance for SAP solutions resource properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sapVirtualInstanceName, subscriptionId	Gets a Virtual Instance for SAP solutions resource
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all Virtual Instances for SAP solutions resources in a Resource Group.
list_by_subscription	SELECT	subscriptionId	Gets all Virtual Instances for SAP solutions resources in a Subscription.
create	INSERT	resourceGroupName, sapVirtualInstanceName, subscriptionId, data__properties	Creates a Virtual Instance for SAP solutions (VIS) resource
delete	DELETE	resourceGroupName, sapVirtualInstanceName, subscriptionId	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.
update	UPDATE	resourceGroupName, sapVirtualInstanceName, subscriptionId	Updates a Virtual Instance for SAP solutions resource
start	EXEC	resourceGroupName, sapVirtualInstanceName, subscriptionId	Starts the SAP application, that is the Central Services instance and Application server instances.
stop	EXEC	resourceGroupName, sapVirtualInstanceName, subscriptionId	Stops the SAP Application, that is the Application server instances and Central Services instance.

SELECT examples

Gets all Virtual Instances for SAP solutions resources in a Subscription.

vw_sap_virtual_instances

SELECT
configuration,
environment,
errors,
health,
identity,
location,
managed_resource_group_configuration,
provisioning_state,
resourceGroupName,
sapVirtualInstanceName,
sap_product,
state,
status,
subscriptionId,
tags
FROM azure_isv.sap_workloads.vw_sap_virtual_instances
WHERE subscriptionId = '{{ subscriptionId }}';

sap_virtual_instances

SELECT
identity,
location,
properties,
tags
FROM azure_isv.sap_workloads.sap_virtual_instances
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.sap_workloads.sap_virtual_instances (
resourceGroupName,
sapVirtualInstanceName,
subscriptionId,
data__properties,
tags,
location,
identity,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ sapVirtualInstanceName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ tags }}',
'{{ location }}',
'{{ identity }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: identity
      value:
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: properties
      value:
        - name: environment
          value: []
        - name: sapProduct
          value: []
        - name: configuration
          value:
            - name: configurationType
              value: []
        - name: managedResourceGroupConfiguration
          value:
            - name: name
              value: string
        - name: status
          value: []
        - name: health
          value: []
        - name: state
          value: []
        - name: provisioningState
          value: []
        - name: errors
          value:
            - name: properties
              value:
                - name: code
                  value: string
                - name: message
                  value: string
                - name: details
                  value:
                    - - name: code
                        value: string
                      - name: message
                        value: string
                      - name: details
                        value:
                          - - name: code
                              value: string
                            - name: message
                              value: string
                            - name: details
                              value:
                                - - name: code
                                    value: string
                                  - name: message
                                    value: string
                                  - name: details
                                    value:
                                      - - name: code
                                          value: string
                                        - name: message
                                          value: string
                                        - name: details
                                          value:
                                            - - name: code
                                                value: string
                                              - name: message
                                                value: string
                                              - name: details
                                                value:
                                                  - - name: code
                                                      value: string
                                                    - name: message
                                                      value: string
                                                    - name: details
                                                      value:
                                                        - - name: code
                                                            value: string
                                                          - name: message
                                                            value: string
                                                          - name: details
                                                            value:
                                                              - []

UPDATE example

Updates a sap_virtual_instances resource.

/*+ update */
UPDATE azure_isv.sap_workloads.sap_virtual_instances
SET 
tags = '{{ tags }}',
identity = '{{ identity }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sap_virtual_instances resource.

/*+ delete */
DELETE FROM azure_isv.sap_workloads.sap_virtual_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';