Skip to main content

discovered_assets

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

Overview

Namediscovered_assets
TypeResource
Idazure.device_registry.discovered_assets

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectThe extended location.
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, discoveredAssetNameGet a DiscoveredAsset
list_by_resource_groupselectsubscriptionId, resourceGroupNameList DiscoveredAsset resources by resource group
list_by_subscriptionselectsubscriptionIdList DiscoveredAsset resources by subscription ID
create_or_replaceinsertsubscriptionId, resourceGroupName, discoveredAssetName, data__extendedLocationCreate a DiscoveredAsset
updateupdatesubscriptionId, resourceGroupName, discoveredAssetNameUpdate a DiscoveredAsset
deletedeletesubscriptionId, resourceGroupName, discoveredAssetNameDelete a DiscoveredAsset

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
discoveredAssetNamestringDiscovered Asset name parameter.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a DiscoveredAsset

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.device_registry.discovered_assets
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND discoveredAssetName = '{{ discoveredAssetName }}' -- required
;

INSERT examples

Create a DiscoveredAsset

INSERT INTO azure.device_registry.discovered_assets (
data__properties,
data__extendedLocation,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
discoveredAssetName
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ discoveredAssetName }}'
RETURNING
extendedLocation,
location,
properties,
tags
;

UPDATE examples

Update a DiscoveredAsset

UPDATE azure.device_registry.discovered_assets
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND discoveredAssetName = '{{ discoveredAssetName }}' --required
RETURNING
extendedLocation,
location,
properties,
tags;

DELETE examples

Delete a DiscoveredAsset

DELETE FROM azure.device_registry.discovered_assets
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND discoveredAssetName = '{{ discoveredAssetName }}' --required
;