dsc_nodes

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

Overview

Name	dsc_nodes
Type	Resource
Id	azure.automation.dsc_nodes

Fields

vw_dsc_nodes

Name	Datatype	Description
account_id	text	field from the properties object
automationAccountName	text	field from the properties object
etag	text	field from the properties object
extension_handler	text	field from the properties object
ip	text	field from the properties object
last_seen	text	field from the properties object
nodeId	text	field from the properties object
node_configuration	text	field from the properties object
node_id	text	field from the properties object
registration_time	text	field from the properties object
resourceGroupName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
total_count	text	field from the properties object

dsc_nodes

Name	Datatype	Description
properties	object	The properties of a DscNode

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, nodeId, resourceGroupName, subscriptionId	Retrieve the dsc node identified by node id.
list_by_automation_account	SELECT	automationAccountName, resourceGroupName, subscriptionId	Retrieve a list of dsc nodes.
delete	DELETE	automationAccountName, nodeId, resourceGroupName, subscriptionId	Delete the dsc node identified by node id.
update	UPDATE	automationAccountName, nodeId, resourceGroupName, subscriptionId	Update the dsc node.

SELECT examples

Retrieve a list of dsc nodes.

vw_dsc_nodes

SELECT
account_id,
automationAccountName,
etag,
extension_handler,
ip,
last_seen,
nodeId,
node_configuration,
node_id,
registration_time,
resourceGroupName,
status,
subscriptionId,
total_count
FROM azure.automation.vw_dsc_nodes
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

dsc_nodes

SELECT
properties
FROM azure.automation.dsc_nodes
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a dsc_nodes resource.

/*+ update */
UPDATE azure.automation.dsc_nodes
SET 
nodeId = '{{ nodeId }}',
properties = '{{ properties }}'
WHERE 
automationAccountName = '{{ automationAccountName }}'
AND nodeId = '{{ nodeId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified dsc_nodes resource.

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