storage_appliances

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

Overview

Name	storage_appliances
Type	Resource
Id	azure.nexus.storage_appliances

Fields

vw_storage_appliances

Name	Datatype	Description
administrator_credentials	text	field from the properties object
capacity	text	field from the properties object
capacity_used	text	field from the properties object
cluster_id	text	field from the properties object
detailed_status	text	field from the properties object
detailed_status_message	text	field from the properties object
extended_location	text	field from the properties object
location	text	The geo-location where the resource lives
management_ipv4_address	text	field from the properties object
manufacturer	text	field from the properties object
model	text	field from the properties object
provisioning_state	text	field from the properties object
rack_id	text	field from the properties object
rack_slot	text	field from the properties object
remote_vendor_management_feature	text	field from the properties object
remote_vendor_management_status	text	field from the properties object
resourceGroupName	text	field from the properties object
secret_rotation_status	text	field from the properties object
serial_number	text	field from the properties object
storageApplianceName	text	field from the properties object
storage_appliance_sku_id	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
version	text	field from the properties object

storage_appliances

Name	Datatype	Description
extendedLocation	object
location	string	The geo-location where the resource lives
properties	object
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, storageApplianceName, subscriptionId	Get properties of the provided storage appliance.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Get a list of storage appliances in the provided resource group.
list_by_subscription	SELECT	subscriptionId	Get a list of storage appliances in the provided subscription.
create_or_update	INSERT	resourceGroupName, storageApplianceName, subscriptionId, data__extendedLocation, data__properties	Create a new storage appliance or update the properties of the existing one.
All customer initiated requests will be rejected as the life cycle of this resource is managed by the system.
delete	DELETE	resourceGroupName, storageApplianceName, subscriptionId	Delete the provided storage appliance.
All customer initiated requests will be rejected as the life cycle of this resource is managed by the system.
update	UPDATE	resourceGroupName, storageApplianceName, subscriptionId	Update properties of the provided storage appliance, or update tags associated with the storage appliance Properties and tag updates can be done independently.
disable_remote_vendor_management	EXEC	resourceGroupName, storageApplianceName, subscriptionId	Disable remote vendor management of the provided storage appliance.
enable_remote_vendor_management	EXEC	resourceGroupName, storageApplianceName, subscriptionId	Enable remote vendor management of the provided storage appliance.

SELECT examples

Get a list of storage appliances in the provided subscription.

vw_storage_appliances

SELECT
administrator_credentials,
capacity,
capacity_used,
cluster_id,
detailed_status,
detailed_status_message,
extended_location,
location,
management_ipv4_address,
manufacturer,
model,
provisioning_state,
rack_id,
rack_slot,
remote_vendor_management_feature,
remote_vendor_management_status,
resourceGroupName,
secret_rotation_status,
serial_number,
storageApplianceName,
storage_appliance_sku_id,
subscriptionId,
tags,
version
FROM azure.nexus.vw_storage_appliances
WHERE subscriptionId = '{{ subscriptionId }}';

storage_appliances

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.nexus.storage_appliances
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new storage_appliances resource.

All Properties

/*+ create */
INSERT INTO azure.nexus.storage_appliances (
resourceGroupName,
storageApplianceName,
subscriptionId,
data__extendedLocation,
data__properties,
extendedLocation,
properties,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ storageApplianceName }}',
'{{ subscriptionId }}',
'{{ data__extendedLocation }}',
'{{ data__properties }}',
'{{ extendedLocation }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: string
    - name: properties
      value:
        - name: administratorCredentials
          value:
            - name: password
              value: string
            - name: username
              value: string
        - name: capacity
          value: integer
        - name: capacityUsed
          value: integer
        - name: clusterId
          value: string
        - name: detailedStatus
          value: string
        - name: detailedStatusMessage
          value: string
        - name: managementIpv4Address
          value: string
        - name: manufacturer
          value: string
        - name: model
          value: string
        - name: provisioningState
          value: string
        - name: rackId
          value: string
        - name: rackSlot
          value: integer
        - name: remoteVendorManagementFeature
          value: string
        - name: remoteVendorManagementStatus
          value: string
        - name: secretRotationStatus
          value:
            - - name: expirePeriodDays
                value: integer
              - name: lastRotationTime
                value: string
              - name: rotationPeriodDays
                value: integer
              - name: secretArchiveReference
                value:
                  - name: keyVaultId
                    value: string
                  - name: secretName
                    value: string
                  - name: secretVersion
                    value: string
              - name: secretType
                value: string
        - name: serialNumber
          value: string
        - name: storageApplianceSkuId
          value: string
        - name: version
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a storage_appliances resource.

/*+ update */
UPDATE azure.nexus.storage_appliances
SET 
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND storageApplianceName = '{{ storageApplianceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified storage_appliances resource.

/*+ delete */
DELETE FROM azure.nexus.storage_appliances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND storageApplianceName = '{{ storageApplianceName }}'
AND subscriptionId = '{{ subscriptionId }}';