Skip to main content

certificates

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

Overview

Namecertificates
TypeResource
Idazure.automation.certificates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectGets or sets the properties of the certificate.

Methods

The following methods are available for this resource:

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

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.
certificateNamestringThe name of certificate.
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 certificate identified by certificate name.

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

INSERT examples

Create a certificate.

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

UPDATE examples

Update a certificate.

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

DELETE examples

Delete the certificate.

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