steampipe plugin install theapsgroup/vault

Table: vault_kv_secret

For working with paths for secrets in the kv engines

Note: This does not expose the contents of the secrets by design.

Examples

Get all secret keys from all kv engines

select
key,
path
from
vault_kv_secret;

Get all secret keys from a specific mounted kv engine (abc/ in this example)

select
key
from
vault_kv_secret
where
path = 'abc/';

Search for secret paths based on a fragment/keyword

select
*
from
vault_kv_secret
where
key like '%myapp%';

Schema for vault_kv_secret

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_timetimestamp with time zoneThe date and time the secret was created
deletion_timetimestamp with time zoneThe date and time the secret was destroyed, if destroyed
destroyedbooleanWhether the secret was destroyed
keytext=The key/path of the kv secret
pathtext=The path (mount point) of the secrets engine
versionbigintThe current version of the secret