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_keywhere label = 'Dwight';
select *from equinix_metal_ssh_keywhere label = 'Dwight';
Schema for equinix_metal_ssh_key
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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. | |
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