turbot/scaleway
steampipe plugin install scaleway

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
allowed_actionsjsonbA list of allowed actions on the server.
archtextThe architecture the server is compatible with.
boot_scriptjsonbThe server bootscript
boot_typetextThe server boot type.
commercial_typetext=The server commercial type (eg. GP1-M).
creation_datetimestamp with time zoneThe time when the server was created.
dynamic_ip_requiredbooleanIndicates whether a dynamic IP is required, or not.
enable_ipv6booleanIndicates whether IPv6 is enabled, or not.
host_nametextThe hostname of the server.
idtext=An unique identifier of the server.
imagejsonbDescribes the information on the server image.
ipv6jsonbThe server IPv6 address.
locationjsonbSpecifies the server location.
maintenancesjsonbThe server planned maintenances.
modification_datetimestamp with time zoneThe time when the server was last modified.
nametext=The user-defined name of the server.
organizationtextThe ID of the organization where the server resides.
placement_groupjsonbThe server placement group.
private_ipinetThe private IP address of the server.
private_nicsjsonbThe server private NICs.
projecttextThe ID of the project where the server resides.
protectedbooleanIndicates whether the server protection option is activated, or not.
public_ipjsonbSpecifies the information about the public IP.
security_groupjsonbDescribes the server security group.
statetextThe current state of the server.
state_detailtextThe server state detail.
tagsjsonbA list of tags associated with the server.
titletextTitle of the resource.
volumesjsonbA list of server volumes.
zonetext=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