racks

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

Overview

Name	racks
Type	Resource
Id	azure.nexus.racks

Fields

vw_racks

Name	Datatype	Description
availability_zone	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
provisioning_state	text	field from the properties object
rackName	text	field from the properties object
rack_location	text	field from the properties object
rack_serial_number	text	field from the properties object
rack_sku_id	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

racks

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	rackName, resourceGroupName, subscriptionId	Get properties of the provided rack.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Get a list of racks in the provided resource group.
list_by_subscription	SELECT	subscriptionId	Get a list of racks in the provided subscription.
create_or_update	INSERT	rackName, resourceGroupName, subscriptionId, data__extendedLocation, data__properties	Create a new rack or update 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	rackName, resourceGroupName, subscriptionId	Delete the provided rack.
All customer initiated requests will be rejected as the life cycle of this resource is managed by the system.
update	UPDATE	rackName, resourceGroupName, subscriptionId	Patch properties of the provided rack, or update the tags associated with the rack. Properties and tag updates can be done independently.

SELECT examples

Get a list of racks in the provided subscription.

vw_racks

SELECT
availability_zone,
cluster_id,
detailed_status,
detailed_status_message,
extended_location,
location,
provisioning_state,
rackName,
rack_location,
rack_serial_number,
rack_sku_id,
resourceGroupName,
subscriptionId,
tags
FROM azure.nexus.vw_racks
WHERE subscriptionId = '{{ subscriptionId }}';

racks

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.nexus.racks (
rackName,
resourceGroupName,
subscriptionId,
data__extendedLocation,
data__properties,
extendedLocation,
properties,
tags,
location
)
SELECT 
'{{ rackName }}',
'{{ resourceGroupName }}',
'{{ 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: availabilityZone
          value: string
        - name: clusterId
          value: string
        - name: detailedStatus
          value: string
        - name: detailedStatusMessage
          value: string
        - name: provisioningState
          value: string
        - name: rackLocation
          value: string
        - name: rackSerialNumber
          value: string
        - name: rackSkuId
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a racks resource.

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

DELETE example

Deletes the specified racks resource.

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