Skip to main content

device_groups

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

Overview

Namedevice_groups
TypeResource
Idazure.sphere.device_groups

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, catalogName, productName, deviceGroupNameGet a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.
list_by_productselectsubscriptionId, resourceGroupName, catalogName, productName$filter, $top, $skip, $maxpagesizeList DeviceGroup resources by Product. '.default' and '.unassigned' are system defined values and cannot be used for product name.
create_or_updateinsertsubscriptionId, resourceGroupName, catalogName, productName, deviceGroupNameCreate a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.
updateupdatesubscriptionId, resourceGroupName, catalogName, productName, deviceGroupNameUpdate a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.
deletedeletesubscriptionId, resourceGroupName, catalogName, productName, deviceGroupNameDelete a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.
claim_devicesexecsubscriptionId, resourceGroupName, catalogName, productName, deviceGroupName, deviceIdentifiersBulk claims the devices. Use '.unassigned' or '.default' for the device group and product names when bulk claiming devices to a catalog only.
count_devicesexecsubscriptionId, resourceGroupName, catalogName, productName, deviceGroupNameCounts devices in device group. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.

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
catalogNamestringName of catalog
deviceGroupNamestringName of device group.
productNamestringName of product.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.
$filterstringFilter the result list using the given expression
$maxpagesizeinteger (int32)The maximum number of result items per page.
$skipinteger (int32)The number of result items to skip.
$topinteger (int32)The number of result items to return.

SELECT examples

Get a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.

SELECT
properties
FROM azure.sphere.device_groups
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND catalogName = '{{ catalogName }}' -- required
AND productName = '{{ productName }}' -- required
AND deviceGroupName = '{{ deviceGroupName }}' -- required
;

INSERT examples

Create a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.

INSERT INTO azure.sphere.device_groups (
data__properties,
subscriptionId,
resourceGroupName,
catalogName,
productName,
deviceGroupName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ catalogName }}',
'{{ productName }}',
'{{ deviceGroupName }}'
RETURNING
properties
;

UPDATE examples

Update a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.

UPDATE azure.sphere.device_groups
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND catalogName = '{{ catalogName }}' --required
AND productName = '{{ productName }}' --required
AND deviceGroupName = '{{ deviceGroupName }}' --required
RETURNING
properties;

DELETE examples

Delete a DeviceGroup. '.default' and '.unassigned' are system defined values and cannot be used for product or device group name.

DELETE FROM azure.sphere.device_groups
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND catalogName = '{{ catalogName }}' --required
AND productName = '{{ productName }}' --required
AND deviceGroupName = '{{ deviceGroupName }}' --required
;

Lifecycle Methods

Bulk claims the devices. Use '.unassigned' or '.default' for the device group and product names when bulk claiming devices to a catalog only.

EXEC azure.sphere.device_groups.claim_devices 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@catalogName='{{ catalogName }}' --required,
@productName='{{ productName }}' --required,
@deviceGroupName='{{ deviceGroupName }}' --required
@@json=
'{
"deviceIdentifiers": "{{ deviceIdentifiers }}"
}'
;