Table: openstack_server

A server is a VM that runs on a hypervisor. A server is launched from an image.

Examples

Basic server info

select
  name,
  updated,
  created,
  status,
  addresses,
  security_groups,
  attached_volumes
from
  openstack_server;

Server by ID

select
  name,
  updated,
  created,
  status,
  addresses,
  security_groups,
  attached_volumes
from
  openstack_server
where
  id = '544c2a99-fb22-4810-b08b-f9bf2eb6f991';

All servers not created in the last 30 days

select
  name,
  updated,
  created,
  status,
  addresses,
  security_groups,
  attached_volumes
from
  openstack_server
where
  date_part('day', current_date :: timestamp - created :: timestamp) <= 30;

All servers not updated in the last 90 days

select
  name,
  updated,
  created,
  status,
  addresses,
  security_groups,
  attached_volumes
from
  openstack_server
where
  date_part('day', current_date :: timestamp - updated :: timestamp) >= 90;

All shutoff servers

select
  name,
  updated,
  created,
  status,
  addresses,
  security_groups,
  attached_volumes
from
  openstack_server
where
  status = 'SHUTOFF';

All shelved servers

select
  name,
  updated,
  created,
  status,
  addresses,
  security_groups,
  attached_volumes
from
  openstack_server
where
  status = 'SHELVED_OFFLOADED';

Schema for openstack_server

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
access_ipv4	text		AccessIPv4 contains the IP address of the server.
access_ipv6	text		AccessIPv6 contains the IP address of the server.
addresses	jsonb		Addresses includes a list of all IP addresses assigned to the server, keyed by pool.
admin_pass	text		AdminPass will generally be empty (""). However, it will contain the administrative password chosen when provisioning a new server without a set AdminPass setting in the first place. Note that this is the ONLY time this field will be valid.
attached_volumes	text		AttachedVolumes includes the volume attachments of this instance.
created	timestamp with time zone		Created contain ISO-8601 timestamp of when the server was created.
fault	text		Fault contains failure information about a server.
flavor	jsonb		Flavor refers to a JSON object, which itself indicates the hardware configuration of the deployed server.
host_id	text		HostID is the host where the server is located in the cloud.
id	text	=	ID uniquely identifies this server.
image	jsonb		Image refers to a JSON object, which itself indicates the OS image used to deploy the server.
key_name	text		KeyName indicates which public key was injected into the server on launch.
links	jsonb		Links includes HTTP references to the itself, useful for passing along to other APIs that might want a server reference.
metadata	jsonb		Metadata includes a list of all user-specified key-value pairs attached to the server.
name	text		Name contains the human-readable name for the server.
progress	bigint		Progress ranges from 0..100. A request made against the server completes only once Progress reaches 100.
security_groups	jsonb		SecurityGroups includes the security groups that this instance has applied to it.
server_groups	text		ServerGroups is a slice of strings containing the UUIDs of the server groups to which the server belongs. Currently this can contain at most one entry. New in microversion 2.71.
status	text		Status contains the current operational status of the server, such as IN_PROGRESS or ACTIVE.
tags	text		Tags is a slice/list of string tags in a server. The requires microversion 2.26 or later.
tenant_id	text		TenantID identifies the tenant owning this server resource.
updated	timestamp with time zone		Updated contain ISO-8601 timestamp of when the state of the server last changed.
user_id	text		UserID uniquely identifies the user account owning the tenant.