Skip to main content

credentials

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

Overview

Namecredentials
TypeResource
Idazure.automation.credentials

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectGets or sets the properties of the credential.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, automationAccountName, credentialName, subscriptionIdRetrieve the credential identified by credential name.
list_by_automation_accountselectresourceGroupName, automationAccountName, subscriptionIdRetrieve a list of credentials.
create_or_updateinsertresourceGroupName, automationAccountName, credentialName, subscriptionId, data__name, data__propertiesCreate a credential.
updateupdateresourceGroupName, automationAccountName, credentialName, subscriptionIdUpdate a credential.
deletedeleteresourceGroupName, automationAccountName, credentialName, subscriptionIdDelete the credential.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
automationAccountNamestringThe name of the automation account.
credentialNamestringThe name of credential.
resourceGroupNamestringName of an Azure Resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Retrieve the credential identified by credential name.

SELECT
properties
FROM azure.automation.credentials
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND automationAccountName = '{{ automationAccountName }}' -- required
AND credentialName = '{{ credentialName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Create a credential.

INSERT INTO azure.automation.credentials (
data__name,
data__properties,
resourceGroupName,
automationAccountName,
credentialName,
subscriptionId
)
SELECT
'{{ name }}' /* required */,
'{{ properties }}' /* required */,
'{{ resourceGroupName }}',
'{{ automationAccountName }}',
'{{ credentialName }}',
'{{ subscriptionId }}'
RETURNING
properties
;

UPDATE examples

Update a credential.

UPDATE azure.automation.credentials
SET
data__name = '{{ name }}',
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND automationAccountName = '{{ automationAccountName }}' --required
AND credentialName = '{{ credentialName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
properties;

DELETE examples

Delete the credential.

DELETE FROM azure.automation.credentials
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND automationAccountName = '{{ automationAccountName }}' --required
AND credentialName = '{{ credentialName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;