certificates

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

Overview

Name	certificates
Type	Resource
Id	azure.automation.certificates

Fields

vw_certificates

Name	Datatype	Description
description	text	field from the properties object
automationAccountName	text	field from the properties object
certificateName	text	field from the properties object
creation_time	text	field from the properties object
expiry_time	text	field from the properties object
is_exportable	text	field from the properties object
last_modified_time	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
thumbprint	text	field from the properties object

certificates

Name	Datatype	Description
properties	object	Properties of the certificate.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, certificateName, resourceGroupName, subscriptionId	Retrieve the certificate identified by certificate name.
list_by_automation_account	SELECT	automationAccountName, resourceGroupName, subscriptionId	Retrieve a list of certificates.
create_or_update	INSERT	automationAccountName, certificateName, resourceGroupName, subscriptionId, data__name, data__properties	Create a certificate.
delete	DELETE	automationAccountName, certificateName, resourceGroupName, subscriptionId	Delete the certificate.
update	UPDATE	automationAccountName, certificateName, resourceGroupName, subscriptionId	Update a certificate.

SELECT examples

Retrieve a list of certificates.

vw_certificates

SELECT
description,
automationAccountName,
certificateName,
creation_time,
expiry_time,
is_exportable,
last_modified_time,
resourceGroupName,
subscriptionId,
thumbprint
FROM azure.automation.vw_certificates
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificates

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: properties
      value:
        - name: base64Value
          value: string
        - name: description
          value: string
        - name: thumbprint
          value: string
        - name: isExportable
          value: boolean

UPDATE example

Updates a certificates resource.

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

DELETE example

Deletes the specified certificates resource.

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