Skip to main content

datastores

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

Overview

Namedatastores
TypeResource
Idazure_isv.avs.datastores

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.
diskPoolVolumeobjectAn iSCSI volume.
elasticSanVolumeobjectAn Elastic SAN volume.
netAppVolumeobjectAn Azure NetApp Files volume.
provisioningStatestringThe state of the datastore provisioning. Known values are: "Succeeded", "Failed", "Canceled", "Cancelled", "Pending", "Creating", "Updating", and "Deleting". (Succeeded, Failed, Canceled, Cancelled, Pending, Creating, Updating, Deleting)
pureStorageVolumeobjectA Pure Storage volume.
statusstringThe operational status of the datastore. Known values are: "Unknown", "Accessible", "Inaccessible", "Attached", "Detached", "LostCommunication", and "DeadOrError". (Unknown, Accessible, Inaccessible, Attached, Detached, LostCommunication, DeadOrError)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
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, private_cloud_name, cluster_name, datastore_name, subscription_idGet a Datastore.
listselectresource_group_name, private_cloud_name, cluster_name, subscription_idList Datastore resources by Cluster.
create_or_updateinsertresource_group_name, private_cloud_name, cluster_name, datastore_name, subscription_idCreate a Datastore.
create_or_updatereplaceresource_group_name, private_cloud_name, cluster_name, datastore_name, subscription_idCreate a Datastore.
deletedeleteresource_group_name, private_cloud_name, cluster_name, datastore_name, subscription_idDelete a Datastore.

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
cluster_namestringName of the cluster. Required.
datastore_namestringName of the datastore. Required.
private_cloud_namestringName of the private cloud. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get a Datastore.

SELECT
id,
name,
diskPoolVolume,
elasticSanVolume,
netAppVolume,
provisioningState,
pureStorageVolume,
status,
systemData,
type
FROM azure_isv.avs.datastores
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND private_cloud_name = '{{ private_cloud_name }}' -- required
AND cluster_name = '{{ cluster_name }}' -- required
AND datastore_name = '{{ datastore_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a Datastore.

INSERT INTO azure_isv.avs.datastores (
properties,
resource_group_name,
private_cloud_name,
cluster_name,
datastore_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ private_cloud_name }}',
'{{ cluster_name }}',
'{{ datastore_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create a Datastore.

REPLACE azure_isv.avs.datastores
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND private_cloud_name = '{{ private_cloud_name }}' --required
AND cluster_name = '{{ cluster_name }}' --required
AND datastore_name = '{{ datastore_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a Datastore.

DELETE FROM azure_isv.avs.datastores
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND private_cloud_name = '{{ private_cloud_name }}' --required
AND cluster_name = '{{ cluster_name }}' --required
AND datastore_name = '{{ datastore_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;