Skip to main content

storage_assets

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

Overview​

Namestorage_assets
TypeResource
Idazure.discovery.storage_assets

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.
descriptionstringThe description. Required.
locationstringThe geo-location where the resource lives. Required.
pathstringThe path to the data within its parent container. This should be relative to the root of the parent container.
provisioningStatestringThe status of the last operation. Known values are: "Succeeded", "Failed", "Canceled", "Accepted", "Provisioning", "Updating", and "Deleting". (Succeeded, Failed, Canceled, Accepted, Provisioning, Updating, Deleting)
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, storage_container_name, storage_asset_name, subscription_idGet a StorageAsset.
list_by_storage_containerselectresource_group_name, storage_container_name, subscription_idList StorageAsset resources by StorageContainer.
create_or_updateinsertresource_group_name, storage_container_name, storage_asset_name, subscription_id, locationCreate a StorageAsset.
updateupdateresource_group_name, storage_container_name, storage_asset_name, subscription_id, locationUpdate a StorageAsset.
create_or_updatereplaceresource_group_name, storage_container_name, storage_asset_name, subscription_id, locationCreate a StorageAsset.
deletedeleteresource_group_name, storage_container_name, storage_asset_name, subscription_idDelete a StorageAsset.

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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
storage_asset_namestringThe name of the StorageAsset. Required.
storage_container_namestringThe name of the StorageContainer. Required.
subscription_idstring

SELECT examples​

Get a StorageAsset.

SELECT
id,
name,
description,
location,
path,
provisioningState,
systemData,
tags,
type
FROM azure.discovery.storage_assets
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND storage_container_name = '{{ storage_container_name }}' -- required
AND storage_asset_name = '{{ storage_asset_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples​

Create a StorageAsset.

INSERT INTO azure.discovery.storage_assets (
tags,
location,
properties,
resource_group_name,
storage_container_name,
storage_asset_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ storage_container_name }}',
'{{ storage_asset_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples​

Update a StorageAsset.

UPDATE azure.discovery.storage_assets
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND storage_container_name = '{{ storage_container_name }}' --required
AND storage_asset_name = '{{ storage_asset_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples​

Create a StorageAsset.

REPLACE azure.discovery.storage_assets
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND storage_container_name = '{{ storage_container_name }}' --required
AND storage_asset_name = '{{ storage_asset_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples​

Delete a StorageAsset.

DELETE FROM azure.discovery.storage_assets
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND storage_container_name = '{{ storage_container_name }}' --required
AND storage_asset_name = '{{ storage_asset_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;