Table: equinix_metal_ssh_key - Query Equinix Metal SSH Keys using SQL

Equinix Metal SSH Keys are resources within the Equinix Metal service that enable secure shell (SSH) access to devices. They are used to authenticate users and ensure secure communication between devices within the network. SSH Keys are crucial for managing and controlling access to devices, and ensuring the security of communications.

Table Usage Guide

The equinix_metal_ssh_key table provides insights into SSH Keys within the Equinix Metal service. As a network administrator, you can explore key-specific details through this table, including their labels, IDs, and created and updated timestamps. Utilize it to uncover information about keys, such as their ownership, usage, and the devices they are associated with, helping you manage access control and maintain the security of your network.

Examples

List all SSH keys

Explore the full range of SSH keys available in your Equinix Metal environment with this query. It's useful for verifying key access and ensuring appropriate security measures are in place.

select
  *
from
  equinix_metal_ssh_key;

select
  *
from
  equinix_metal_ssh_key;

Get SSH keys labelled Dwight

Discover the segments that use SSH keys labelled 'Dwight'. This can be beneficial in understanding the distribution and usage of specific SSH keys within your infrastructure, enhancing overall security management.

select
  *
from
  equinix_metal_ssh_key
where
  label = 'Dwight';

select
  *
from
  equinix_metal_ssh_key
where
  label = 'Dwight';

Schema for equinix_metal_ssh_key

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
created_at	timestamp with time zone		When the SSH key was created.
fingerprint	text		Fingerprint of the SSH key.
href	text		URL of the SSH key.
id	text	=	ID of the SSH key.
label	text		Label for the SSH key.
public_key	text		Public key.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
updated_at	timestamp with time zone		When the SSH key was 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)" -- equinix

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

steampipe_export_equinix --config '<your_config>' equinix_metal_ssh_key