Table: scaleway_instance_server - Query Scaleway Instances using SQL

Scaleway Instances is a service offered by Scaleway that allows you to deploy virtual instances in seconds. These instances are scalable, powerful, and reliable cloud servers designed for developers. They are equipped with SSD disks, high-end Intel CPUs, and come with a variety of OS and Apps.

Table Usage Guide

The scaleway_instance_server table provides insights into the instances within Scaleway. As a system administrator or a developer, explore server-specific details through this table, including server configurations, statuses, and other related information. Utilize it to uncover information about servers, such as their commercial type, creation date, dynamic IP required status, and more.

Examples

Basic info

Explore which Scaleway servers are currently active, when they were created, and where they are located. This is useful for gaining insights into resource allocation and server management across different projects and organizations.

select
  name,
  id,
  state,
  creation_date,
  zone,
  project,
  organization
from
  scaleway_instance_server;

select
  name,
  id,
  state,
  creation_date,
  zone,
  project,
  organization
from
  scaleway_instance_server;

List stopped instance servers

Identify instances where Scaleway servers are in a 'stopped' state. This is useful to manage resources and maintain operational efficiency by pinpointing idle servers.

select
  name,
  id,
  state,
  zone project,
  organization
from
  scaleway_instance_server
where
  state = 'stopped';

select
  name,
  id,
  state,
  zone,
  project,
  organization
from
  scaleway_instance_server
where
  state = 'stopped';

List instance servers older than 90 days

Determine the areas in which instance servers have been running for more than 90 days. This is useful for identifying potential areas for resource optimization and cost-saving by assessing long-running servers.

select
  name,
  id,
  state,
  extract(
    day
    from
      current_timestamp - creation_date
  ) as age,
  zone,
  project,
  organization
from
  scaleway_instance_server
where
  state = 'running'
  and extract(
    day
    from
      current_timestamp - creation_date
  ) > 90;

select
  name,
  id,
  state,
  julianday('now') - julianday(creation_date) as age,
  zone,
  project,
  organization
from
  scaleway_instance_server
where
  state = 'running'
  and julianday('now') - julianday(creation_date) > 90;

Schema for scaleway_instance_server

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
allowed_actions	jsonb		A list of allowed actions on the server.
arch	text		The architecture the server is compatible with.
boot_script	jsonb		The server bootscript
boot_type	text		The server boot type.
commercial_type	text	=	The server commercial type (eg. GP1-M).
creation_date	timestamp with time zone		The time when the server was created.
dynamic_ip_required	boolean		Indicates whether a dynamic IP is required, or not.
enable_ipv6	boolean		Indicates whether IPv6 is enabled, or not.
host_name	text		The hostname of the server.
id	text	=	An unique identifier of the server.
image	jsonb		Describes the information on the server image.
ipv6	jsonb		The server IPv6 address.
location	jsonb		Specifies the server location.
maintenances	jsonb		The server planned maintenances.
modification_date	timestamp with time zone		The time when the server was last modified.
name	text	=	The user-defined name of the server.
organization	text		The ID of the organization where the server resides.
placement_group	jsonb		The server placement group.
private_ip	inet		The private IP address of the server.
private_nics	jsonb		The server private NICs.
project	text		The ID of the project where the server resides.
protected	boolean		Indicates whether the server protection option is activated, or not.
public_ip	jsonb		Specifies the information about the public IP.
security_group	jsonb		Describes the server security group.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The current state of the server.
state_detail	text		The server state detail.
tags	jsonb		A list of tags associated with the server.
title	text		Title of the resource.
volumes	jsonb		A list of server volumes.
zone	text	=	Specifies the zone where the server resides.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- scaleway

You can pass the configuration to the command with the --config argument:

steampipe_export_scaleway --config '<your_config>' scaleway_instance_server