theapsgroup/vault

steampipe plugin install theapsgroup/vaultsteampipe plugin install theapsgroup/vault

Table: vault_pki_cert

For querying PKI Certificates in the pki engines

Examples

Get all certificates in all pki mounts

select
*
from
vault_pki_cert;

Get certificates from a specific engine mount (example is pki/)

select
*
from
vault_pki_cert
where
path = 'pki/';

Get renewable certificates from the pki/ mount

select
*
from
vault_pki_cert
where
path = 'pki/'
and
renewable = 1;

.inspect vault_pki_cert

Vault PKI Certificates

NameTypeDescription
lease_durationbigintDuration of Lease in seconds (0 [infinite] if not set)
lease_idtextLease Identifier
pathtextThe path (mount point) of the engine containing the PKI certificate
renewablebooleanIndication if the certificate is renewable
request_idtextRequest Identifier
serialtextThe serial identifier of the certificate