Table: gandi_certificate
The gandi_certificate
table can be used to query information about your certificates.
Examples
List certificates
select cn, statusfrom gandi_certificate
List invalid certificates
select cn, statusfrom gandi_certificatewhere status != 'valid'
Schema for gandi_certificate
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
cn | text | Common Name. | |
expiration | timestamp with time zone | Expiration date. | |
id | text | = | UUID. |
package_name | text | ||
status | text | One of: 'pending', 'valid', 'revoked', 'replaced', 'replaced_rev', 'expired'. |