ernw/openstack

GitHub
steampipe plugin install ernw/openstacksteampipe plugin install ernw/openstack

Table: openstack_user

A user is an individual API consumer who can authenticate and access cloud resources. A user is part of only one domain and the username must be unique to the domain.

Examples

Basic user info

select
name,
description,
email,
enabled,
lock_password,
domain_id,
password_expires_at,
default_project_id
from
openstack_user;

User by ID

select
name,
description,
email,
enabled,
lock_password,
domain_id,
password_expires_at,
default_project_id
from
openstack_user
where
id = 'e021d695cc604acdb8866686b51f6321';

All disabled users

select
name,
description,
email,
enabled,
lock_password,
domain_id,
password_expires_at,
default_project_id
from
openstack_user
where
enabled = false;

All users with no password expiry date

select
name,
description,
email,
enabled,
lock_password,
domain_id,
password_expires_at,
default_project_id
from
openstack_user
where
password_expires_at is null;

.inspect openstack_user

Table of all users.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
default_project_idtextDefaultProjectID is the ID of the default project of the user.
descriptiontextDescription is the description of the user.
domain_idtextDomainID is the domain ID the user belongs to.
emailtextEmail is the email configured for the user.
enabledbooleanEnabled is whether or not the user is enabled.
idtextID is the unique ID of the user.
lock_passwordtextDisables the ability for a user to change its password through self-service APIs if set to true.
nametextName is the name of the user.
password_expires_attimestamp with time zonePasswordExpiresAt is the timestamp when the user's password expires.