certificates

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

Overview

Name	certificates
Type	Resource
Id	azure.sphere.certificates

Fields

vw_certificates

Name	Datatype	Description
catalogName	text	field from the properties object
certificate	text	field from the properties object
expiry_utc	text	field from the properties object
not_before_utc	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serialNumber	text	field from the properties object
status	text	field from the properties object
subject	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	The properties of certificate

Methods

Name	Accessible by	Required Params	Description
get	SELECT	catalogName, resourceGroupName, serialNumber, subscriptionId	Get a Certificate
list_by_catalog	SELECT	catalogName, resourceGroupName, subscriptionId	List Certificate resources by Catalog
retrieve_cert_chain	EXEC	catalogName, resourceGroupName, serialNumber, subscriptionId	Retrieves cert chain.
retrieve_proof_of_possession_nonce	EXEC	catalogName, resourceGroupName, serialNumber, subscriptionId, data__proofOfPossessionNonce	Gets the proof of possession nonce.

SELECT examples

List Certificate resources by Catalog

vw_certificates

SELECT
catalogName,
certificate,
expiry_utc,
not_before_utc,
provisioning_state,
resourceGroupName,
serialNumber,
status,
subject,
subscriptionId,
thumbprint
FROM azure.sphere.vw_certificates
WHERE catalogName = '{{ catalogName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificates

SELECT
properties
FROM azure.sphere.certificates
WHERE catalogName = '{{ catalogName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';