Table: scaleway_baremetal_server - Query Scaleway Baremetal Servers using SQL

A Scaleway Baremetal Server is a physical server provided by Scaleway, a cloud computing company. These servers offer high-performance capabilities and full control over the hardware, making them ideal for compute-intensive workloads. They can be customized according to the user's needs, with a variety of CPUs, memory, and storage options available.

Table Usage Guide

The scaleway_baremetal_server table offers insights into the Baremetal Servers within Scaleway. As a system administrator, you can explore server-specific details through this table, including server status, location, and configuration. Use this table to monitor the performance and health of your servers, verify their configurations, and ensure they are optimally located for their intended workloads.

Examples

Basic info

Explore the status and timeline of your Scaleway baremetal servers across different projects and organizations. This aids in understanding the distribution and upkeep of your servers, assisting in resource management and operational efficiency.

select
  name,
  id,
  status,
  updated_at,
  created_date,
  zone,
  project,
  organization
from
  scaleway_baremetal_server;

select
  name,
  id,
  status,
  updated_at,
  created_date,
  zone,
  project,
  organization
from
  scaleway_baremetal_server;

List stopped bare metal servers

Discover the segments that include inactive bare metal servers across various zones, projects, and organizations. This can be useful for assessing resource utilization and identifying potential areas for cost savings.

select
  name,
  id,
  status,
  zone project,
  organization
from
  scaleway_baremetal_server
where
  status = 'stopped';

select
  name,
  id,
  status,
  zone,
  project,
  organization
from
  scaleway_baremetal_server
where
  status = 'stopped';

List bare metal servers older than 90 days

Determine the areas in which bare metal servers have been running for over 90 days. This is useful for assessing long-term usage and identifying potential areas for resource optimization.

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

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

Schema for scaleway_baremetal_server

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
boot_type	text		The server boot type.
created_at	timestamp with time zone		The time when the server was created.
description	text		The description of the server.
domain	text		The domain of the server.
id	text	=	A unique identifier of the server.
install	jsonb		The install of the server.
ips	jsonb		A list of IPs associated with the server.
name	text	=	The user-defined name of the server.
offer_id	text		The offer ID of the server.
offer_name	text		The offer name of the server.
options	jsonb		The options of the server.
organization	text		The ID of the organization where the server resides.
ping_status	text		The status of the ping.
project	text		The ID of the project where the server resides.
rescue_server	jsonb		The rescue boot of the server.
status	text		The current state of the server.
tags	jsonb		A list of tags associated with the server.
title	text		Title of the resource.
updated_at	timestamp with time zone		The time when the server was updated.
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_baremetal_server