Table: scaleway_instance_ip - Query Scaleway Instance IPs using SQL

Scaleway Instance IP is a resource within Scaleway that allows you to manage and configure IP addresses associated with your instances. It provides a centralized way to set up and manage IP addresses for various Scaleway resources, including Bare Metal servers, Development Instances, and more. Scaleway Instance IP helps you stay informed about the network configurations of your Scaleway resources, and take appropriate actions when necessary.

Table Usage Guide

The scaleway_instance_ip table provides insights into IP addresses associated with instances within Scaleway. As a network administrator, explore IP-specific details through this table, including server IDs, public and private IP addresses, and associated metadata. Utilize it to uncover information about network configurations, such as those with specific server IDs, the relationships between servers and IP addresses, and the verification of IP status.

Examples

Basic info

Explore which instances in your Scaleway project are associated with specific IP addresses, to better manage your resources and ensure optimal project performance. This could be particularly useful for identifying potential bottlenecks or understanding the distribution of your resources.

select
  id,
  address,
  zone,
  project
from
  scaleway_instance_ip;

select
  id,
  address,
  zone,
  project
from
  scaleway_instance_ip;

List unused instance IPs

Discover the segments that contain unused IP addresses within your Scaleway instances. This can be useful for optimizing resource usage and reducing unnecessary costs.

select
  id,
  address,
  zone,
  project
from
  scaleway_instance_ip
where
  server is null
  and reverse is null;

select
  id,
  address,
  zone,
  project
from
  scaleway_instance_ip
where
  server is null
  and reverse is null;

Schema for scaleway_instance_ip

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
address	inet		Specifies the IP address.
id	text	=	An unique identifier of the IP address.
organization	text		The ID of the organization where the IP address resides.
project	text		The ID of the project where the IP address resides.
reverse	text		The reverse dns attached to this IP address.
server	jsonb		Specifies the server attached to the IP address.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A list of tags attached with the IP address.
title	text		Title of the resource.
zone	text	=	Specifies the zone where the IP address 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_ip