Table: scaleway_account_ssh_key - Query Scaleway Account SSH Keys using SQL

Scaleway is a cloud computing company that provides a range of scalable computing resources, including bare metal servers, development platforms, and storage options. Among these resources, Scaleway Account SSH Keys are used to ensure secure shell access to instances. These keys are critical for maintaining the security and integrity of user data and operations within the Scaleway environment.

Table Usage Guide

The scaleway_account_ssh_key table provides insights into the SSH keys associated with a Scaleway account. As a DevOps engineer, explore key-specific details through this table, including key fingerprints, creation dates, and associated metadata. Utilize it to uncover information about keys, such as their usage across instances, their creation and modification history, and the overall security posture of your Scaleway account.

Examples

Basic info

Explore the creation dates and unique identifiers of your Scaleway account's SSH keys. This allows you to manage and track the keys more effectively.

select
  name,
  id,
  created_at,
  fingerprint
from
  scaleway_account_ssh_key;

select
  name,
  id,
  created_at,
  fingerprint
from
  scaleway_account_ssh_key;

List SSH keys older than 90 days

Discover the SSH keys that have been in use for more than 90 days. This is useful in understanding potential security risks associated with outdated keys and aids in maintaining optimal security practices.

select
  name,
  id,
  created_at,
  fingerprint,
  extract(
    day
    from
      current_timestamp - created_at
  ) as age
from
  scaleway_account_ssh_key
where
  extract(
    day
    from
      current_timestamp - created_at
  ) > 90;

select
  name,
  id,
  created_at,
  fingerprint,
  cast(
    (julianday('now') - julianday(created_at)) as integer
  ) as age
from
  scaleway_account_ssh_key
where
  cast(
    (julianday('now') - julianday(created_at)) as integer
  ) > 90;

Schema for scaleway_account_ssh_key

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		The time when the key was created.
creation_info	jsonb		Describes the key creation configuration.
fingerprint	text		Specifies the key fingerprint.
id	text	=	The ID of the SSH key.
name	text	=	The name of the SSH key.
organization	text		The ID of the organization where the server resides.
project	text		The ID of the project where the server resides.
public_key	text		The SSH public key string
title	text		Title of the resource.
updated_at	timestamp with time zone		The time when the key was last updated.

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_account_ssh_key