sap_central_instances

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

Overview

Name	sap_central_instances
Type	Resource
Id	azure_isv.sap_workloads.sap_central_instances

Fields

vw_sap_central_instances

Name	Datatype	Description
centralInstanceName	text	field from the properties object
enqueue_replication_server_properties	text	field from the properties object
enqueue_server_properties	text	field from the properties object
errors	text	field from the properties object
gateway_server_properties	text	field from the properties object
health	text	field from the properties object
instance_no	text	field from the properties object
kernel_patch	text	field from the properties object
kernel_version	text	field from the properties object
load_balancer_details	text	field from the properties object
location	text	The geo-location where the resource lives
message_server_properties	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
status	text	field from the properties object
subnet	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
vm_details	text	field from the properties object

sap_central_instances

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Defines the SAP Central Services Instance properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	centralInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Gets the SAP Central Services Instance resource.
list	SELECT	resourceGroupName, sapVirtualInstanceName, subscriptionId	Lists the SAP Central Services Instance resource for the given Virtual Instance for SAP solutions resource.
create	INSERT	centralInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Creates the SAP Central Services Instance resource. This will be used by service only. PUT operation on this resource by end user will return a Bad Request error.
delete	DELETE	centralInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Deletes the SAP Central Services Instance resource. This will be used by service only. Delete operation on this resource by end user will return a Bad Request error. You can delete the parent resource, which is the Virtual Instance for SAP solutions resource, using the delete operation on it.
update	UPDATE	centralInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Updates the SAP Central Services Instance resource. This can be used to update tags on the resource.
start_instance	EXEC	centralInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Starts the SAP Central Services Instance.
stop_instance	EXEC	centralInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Stops the SAP Central Services Instance.

SELECT examples

Lists the SAP Central Services Instance resource for the given Virtual Instance for SAP solutions resource.

vw_sap_central_instances

SELECT
centralInstanceName,
enqueue_replication_server_properties,
enqueue_server_properties,
errors,
gateway_server_properties,
health,
instance_no,
kernel_patch,
kernel_version,
load_balancer_details,
location,
message_server_properties,
provisioning_state,
resourceGroupName,
sapVirtualInstanceName,
status,
subnet,
subscriptionId,
tags,
vm_details
FROM azure_isv.sap_workloads.vw_sap_central_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

sap_central_instances

SELECT
location,
properties,
tags
FROM azure_isv.sap_workloads.sap_central_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: instanceNo
          value: string
        - name: subnet
          value: string
        - name: messageServerProperties
          value:
            - name: msPort
              value: integer
            - name: internalMsPort
              value: integer
            - name: httpPort
              value: integer
            - name: httpsPort
              value: integer
            - name: hostname
              value: string
            - name: ipAddress
              value: string
            - name: health
              value: []
        - name: enqueueServerProperties
          value:
            - name: hostname
              value: string
            - name: ipAddress
              value: string
            - name: port
              value: integer
        - name: gatewayServerProperties
          value:
            - name: port
              value: integer
        - name: enqueueReplicationServerProperties
          value:
            - name: ersVersion
              value: []
            - name: instanceNo
              value: string
            - name: hostname
              value: string
            - name: kernelVersion
              value: string
            - name: kernelPatch
              value: string
            - name: ipAddress
              value: string
        - name: kernelVersion
          value: string
        - name: kernelPatch
          value: string
        - name: loadBalancerDetails
          value:
            - name: id
              value: string
        - name: vmDetails
          value:
            - - name: type
                value: []
              - name: virtualMachineId
                value: string
              - name: storageDetails
                value:
                  - - name: id
                      value: string
        - name: status
          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_central_instances resource.

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

DELETE example

Deletes the specified sap_central_instances resource.

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