appliances

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

Overview

Name	appliances
Type	Resource
Id	azure.resource_connector.appliances

Fields

vw_appliances

Name	Datatype	Description
distro	text	field from the properties object
identity	text	Identity for the resource.
infrastructure_config	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
public_key	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
version	text	field from the properties object

appliances

Name	Datatype	Description
identity	object	Identity for the resource.
location	string	The geo-location where the resource lives
properties	object	Properties for an appliance.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId	Gets the details of an Appliance with a specified resource group and name.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets a list of Appliances in the specified subscription and resource group. The operation returns properties of each Appliance.
list_by_subscription	SELECT	subscriptionId	Gets a list of Appliances in the specified subscription. The operation returns properties of each Appliance
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId	Creates or updates an Appliance in the specified Subscription and Resource Group.
delete	DELETE	resourceGroupName, resourceName, subscriptionId	Deletes an Appliance with the specified Resource Name, Resource Group, and Subscription Id.
update	UPDATE	resourceGroupName, resourceName, subscriptionId	Updates an Appliance with the specified Resource Name in the specified Resource Group and Subscription.

SELECT examples

Gets a list of Appliances in the specified subscription. The operation returns properties of each Appliance

vw_appliances

SELECT
distro,
identity,
infrastructure_config,
location,
provisioning_state,
public_key,
resourceGroupName,
resourceName,
status,
subscriptionId,
tags,
version
FROM azure.resource_connector.vw_appliances
WHERE subscriptionId = '{{ subscriptionId }}';

appliances

SELECT
identity,
location,
properties,
tags
FROM azure.resource_connector.appliances
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.resource_connector.appliances (
resourceGroupName,
resourceName,
subscriptionId,
identity,
properties,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ identity }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: string
    - name: properties
      value:
        - name: distro
          value: string
        - name: infrastructureConfig
          value:
            - name: provider
              value: string
        - name: provisioningState
          value: string
        - name: publicKey
          value: string
        - name: status
          value: string
        - name: version
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a appliances resource.

/*+ update */
UPDATE azure.resource_connector.appliances
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified appliances resource.

/*+ delete */
DELETE FROM azure.resource_connector.appliances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';