ernw/openstack
steampipe plugin install ernw/openstack

Table: openstack_keypair

A key pair can contain SSH keys or X509 certificates. Key pairs can be attached to an instance on creation to configure the initial access via SSH.

Examples

Basic keypair info

select
name,
fingerprint,
public_key,
private_key,
user_id
from
openstack_keypair;

Keypair by name

select
name,
fingerprint,
public_key,
private_key,
user_id
from
openstack_keypair
where
name = 'keypairname';

All certificates

select
name,
fingerprint,
public_key,
private_key,
user_id
from
openstack_keypair
where
public_key like '-----BEGIN CERTIFICATE-----%';

Schema for openstack_keypair

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
fingerprinttextFingerprint is a short sequence of bytes that can be used to authenticate or validate a longer public key.
nametext=Name is used to refer to this keypair from other services within this region.
private_keytextPrivateKey is the private key from this pair, in PEM format.
public_keytextPublicKey is the public key from this pair, in OpenSSH format.
typetextThe type of the keypair.
user_idtextUserID is the user who owns this KeyPair.