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;