Skip to main content

instances

Creates, updates, deletes, gets or lists an instances resource.

Overview

Nameinstances
TypeResource
Idazure.workload_orchestration.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.
activeStatestringState of instance. Known values are: "active" and "inactive". (active, inactive)
deploymentTimestampEpochintegerDeployment timestamp of instance.
eTagstringIf eTag is provided in the response body, it may also be provided as a header per the normal etag convention. Entity tags are used for comparing two or more entities from the same requested resource. HTTP/1.1 uses entity tags in the etag (section 14.19), If-Match (section 14.24), If-None-Match (section 14.26), and If-Range (section 14.27) header fields.
extendedLocationobject:vartype extended_location: ~azure.mgmt.workloadorchestration.models.ExtendedLocation
provisioningStatestringProvisioning state of resource. Known values are: "Succeeded", "Failed", "Canceled", "Initialized", "InProgress", and "Deleting". (Succeeded, Failed, Canceled, Initialized, InProgress, Deleting)
reconciliationPolicyobjectReconciliation policy of instance.
solutionScopestringScope of instance.
solutionVersionIdstringSolution version of instance. Required.
statusobjectStatus of instance.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
targetIdstringTarget of instance. Required.
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, target_name, solution_name, instance_name, subscription_idGet Instance Resource.
list_by_solutionselectresource_group_name, target_name, solution_name, subscription_idList Instance Resources.
create_or_updateinsertresource_group_name, target_name, solution_name, instance_name, subscription_idCreate or update Instance Resource.
updateupdateresource_group_name, target_name, solution_name, instance_name, subscription_idUpdate an Instance Resource.
create_or_updatereplaceresource_group_name, target_name, solution_name, instance_name, subscription_idCreate or update Instance Resource.
deletedeleteresource_group_name, target_name, solution_name, instance_name, subscription_idDelete Instance Resource.

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
instance_namestringName of the instance. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
solution_namestringName of the solution. Required.
subscription_idstring
target_namestringName of the target. Required.

SELECT examples

Get Instance Resource.

SELECT
id,
name,
activeState,
deploymentTimestampEpoch,
eTag,
extendedLocation,
provisioningState,
reconciliationPolicy,
solutionScope,
solutionVersionId,
status,
systemData,
targetId,
type
FROM azure.workload_orchestration.instances
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND target_name = '{{ target_name }}' -- required
AND solution_name = '{{ solution_name }}' -- required
AND instance_name = '{{ instance_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update Instance Resource.

INSERT INTO azure.workload_orchestration.instances (
properties,
extendedLocation,
resource_group_name,
target_name,
solution_name,
instance_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}',
'{{ resource_group_name }}',
'{{ target_name }}',
'{{ solution_name }}',
'{{ instance_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
eTag,
extendedLocation,
properties,
systemData,
type
;

UPDATE examples

Update an Instance Resource.

UPDATE azure.workload_orchestration.instances
SET
properties = '{{ properties }}',
extendedLocation = '{{ extendedLocation }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND target_name = '{{ target_name }}' --required
AND solution_name = '{{ solution_name }}' --required
AND instance_name = '{{ instance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
eTag,
extendedLocation,
properties,
systemData,
type;

REPLACE examples

Create or update Instance Resource.

REPLACE azure.workload_orchestration.instances
SET
properties = '{{ properties }}',
extendedLocation = '{{ extendedLocation }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND target_name = '{{ target_name }}' --required
AND solution_name = '{{ solution_name }}' --required
AND instance_name = '{{ instance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
eTag,
extendedLocation,
properties,
systemData,
type;

DELETE examples

Delete Instance Resource.

DELETE FROM azure.workload_orchestration.instances
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND target_name = '{{ target_name }}' --required
AND solution_name = '{{ solution_name }}' --required
AND instance_name = '{{ instance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;