accounts

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

Overview

Name	accounts
Type	Resource
Id	azure.automation.accounts

Fields

vw_accounts

Name	Datatype	Description
description	text	field from the properties object
automationAccountName	text	field from the properties object
automation_hybrid_service_url	text	field from the properties object
creation_time	text	field from the properties object
disable_local_auth	text	field from the properties object
encryption	text	field from the properties object
etag	text	Gets or sets the etag of the resource.
identity	text	Identity for the resource.
last_modified_by	text	field from the properties object
last_modified_time	text	field from the properties object
location	text	The geo-location where the resource lives
private_endpoint_connections	text	field from the properties object
public_network_access	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.

accounts

Name	Datatype	Description
etag	string	Gets or sets the etag of the resource.
identity	object	Identity for the resource.
location	string	The geo-location where the resource lives
properties	object	Definition of the account property.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, resourceGroupName, subscriptionId	Get information about an Automation Account.
list	SELECT	subscriptionId	Retrieve a list of accounts within a given subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Retrieve a list of accounts within a given resource group.
create_or_update	INSERT	automationAccountName, resourceGroupName, subscriptionId	Create or update automation account.
delete	DELETE	automationAccountName, resourceGroupName, subscriptionId	Delete an automation account.
update	UPDATE	automationAccountName, resourceGroupName, subscriptionId	Update an automation account.

SELECT examples

Retrieve a list of accounts within a given subscription.

vw_accounts

SELECT
description,
automationAccountName,
automation_hybrid_service_url,
creation_time,
disable_local_auth,
encryption,
etag,
identity,
last_modified_by,
last_modified_time,
location,
private_endpoint_connections,
public_network_access,
resourceGroupName,
sku,
state,
subscriptionId,
system_data,
tags
FROM azure.automation.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
etag,
identity,
location,
properties,
systemData,
tags
FROM azure.automation.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.automation.accounts (
automationAccountName,
resourceGroupName,
subscriptionId,
properties,
name,
location,
identity,
tags
)
SELECT 
'{{ automationAccountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ name }}',
'{{ location }}',
'{{ identity }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: sku
          value:
            - name: name
              value: string
            - name: tier
              value: []
            - name: size
              value: string
            - name: family
              value: string
            - name: capacity
              value: integer
        - name: encryption
          value:
            - name: keyVaultProperties
              value:
                - name: keyIdentifier
                  value: string
                - name: identity
                  value: string
            - name: keySource
              value: string
            - name: identity
              value: string
        - name: publicNetworkAccess
          value: boolean
        - name: disableLocalAuth
          value: boolean
    - name: name
      value: string
    - name: location
      value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: string
    - name: tags
      value: object

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure.automation.accounts
SET 
properties = '{{ properties }}',
name = '{{ name }}',
location = '{{ location }}',
identity = '{{ identity }}',
tags = '{{ tags }}'
WHERE 
automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

/*+ delete */
DELETE FROM azure.automation.accounts
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';