Skip to main content

instances

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

Overview

Nameinstances
TypeResource
Idazure.device_update.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.
accountNamestringParent Device Update Account name which Instance belongs to.
diagnosticStoragePropertiesobjectCustomer-initiated diagnostic log collection storage properties.
enableDiagnosticsbooleanEnables or Disables the diagnostic logs collection.
iotHubsarrayList of IoT Hubs associated with the account.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringProvisioning state. Known values are: "Succeeded", "Deleted", "Failed", "Canceled", "Accepted", and "Creating".
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
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, account_name, instance_name, subscription_idReturns instance details for the given instance and account name.
list_by_accountselectresource_group_name, account_name, subscription_idReturns instances for the given account name.
createinsertresource_group_name, account_name, instance_name, subscription_id, locationCreates or updates instance.
updateupdateresource_group_name, account_name, instance_name, subscription_idUpdates instance's tags.
deletedeleteresource_group_name, account_name, instance_name, subscription_idDeletes instance.
headexecresource_group_name, account_name, instance_name, subscription_idChecks whether instance exists.

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
account_namestringAccount name. Required.
instance_namestringInstance name. Required.
resource_group_namestringThe resource group name. Required.
subscription_idstring

SELECT examples

Returns instance details for the given instance and account name.

SELECT
id,
name,
accountName,
diagnosticStorageProperties,
enableDiagnostics,
iotHubs,
location,
provisioningState,
systemData,
tags,
type
FROM azure.device_update.instances
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND instance_name = '{{ instance_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates instance.

INSERT INTO azure.device_update.instances (
tags,
location,
properties,
resource_group_name,
account_name,
instance_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ instance_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Updates instance's tags.

UPDATE azure.device_update.instances
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND instance_name = '{{ instance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Deletes instance.

DELETE FROM azure.device_update.instances
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND instance_name = '{{ instance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Checks whether instance exists.

EXEC azure.device_update.instances.head 
@resource_group_name='{{ resource_group_name }}' --required,
@account_name='{{ account_name }}' --required,
@instance_name='{{ instance_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;