certificate_profiles

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

Overview

Name	certificate_profiles
Type	Resource
Id	azure_extras.code_signing.certificate_profiles

Fields

vw_certificate_profiles

Name	Datatype	Description
accountName	text	field from the properties object
certificates	text	field from the properties object
city	text	field from the properties object
common_name	text	field from the properties object
country	text	field from the properties object
enhanced_key_usage	text	field from the properties object
identity_validation_id	text	field from the properties object
include_city	text	field from the properties object
include_country	text	field from the properties object
include_postal_code	text	field from the properties object
include_state	text	field from the properties object
include_street_address	text	field from the properties object
organization	text	field from the properties object
organization_unit	text	field from the properties object
postal_code	text	field from the properties object
profileName	text	field from the properties object
profile_type	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
status	text	field from the properties object
street_address	text	field from the properties object
subscriptionId	text	field from the properties object

certificate_profiles

Name	Datatype	Description
properties	object	Properties of the certificate profile.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, profileName, resourceGroupName, subscriptionId	Get details of a certificate profile.
list_by_code_signing_account	SELECT	accountName, resourceGroupName, subscriptionId	List certificate profiles under a trusted signing account.
create	INSERT	accountName, profileName, resourceGroupName, subscriptionId	Create a certificate profile.
delete	DELETE	accountName, profileName, resourceGroupName, subscriptionId	Delete a certificate profile.
revoke_certificate	EXEC	accountName, profileName, resourceGroupName, subscriptionId, data__effectiveAt, data__reason, data__serialNumber, data__thumbprint	Revoke a certificate under a certificate profile.

SELECT examples

List certificate profiles under a trusted signing account.

vw_certificate_profiles

SELECT
accountName,
certificates,
city,
common_name,
country,
enhanced_key_usage,
identity_validation_id,
include_city,
include_country,
include_postal_code,
include_state,
include_street_address,
organization,
organization_unit,
postal_code,
profileName,
profile_type,
provisioning_state,
resourceGroupName,
state,
status,
street_address,
subscriptionId
FROM azure_extras.code_signing.vw_certificate_profiles
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificate_profiles

SELECT
properties
FROM azure_extras.code_signing.certificate_profiles
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.code_signing.certificate_profiles (
accountName,
profileName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accountName }}',
'{{ profileName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: profileType
          value: []
        - name: commonName
          value: string
        - name: organization
          value: string
        - name: organizationUnit
          value: string
        - name: streetAddress
          value: string
        - name: includeStreetAddress
          value: boolean
        - name: city
          value: string
        - name: includeCity
          value: boolean
        - name: state
          value: string
        - name: includeState
          value: boolean
        - name: country
          value: string
        - name: includeCountry
          value: boolean
        - name: postalCode
          value: string
        - name: includePostalCode
          value: boolean
        - name: enhancedKeyUsage
          value: string
        - name: identityValidationId
          value: string
        - name: provisioningState
          value: []
        - name: status
          value: []
        - name: certificates
          value:
            - - name: serialNumber
                value: string
              - name: subjectName
                value: string
              - name: thumbprint
                value: string
              - name: createdDate
                value: string
              - name: expiryDate
                value: string
              - name: status
                value: []
              - name: revocation
                value:
                  - name: requestedAt
                    value: string
                  - name: effectiveAt
                    value: string
                  - name: reason
                    value: string
                  - name: remarks
                    value: string
                  - name: status
                    value: []
                  - name: failureReason
                    value: string

DELETE example

Deletes the specified certificate_profiles resource.

/*+ delete */
DELETE FROM azure_extras.code_signing.certificate_profiles
WHERE accountName = '{{ accountName }}'
AND profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';