Table: tfe_ssh_key - Query Terraform Enterprise SSH Keys using SQL

Terraform Enterprise is a collaborative, scalable, and enterprise-friendly service offered by HashiCorp that provides workflow and automation control for infrastructure as code (IaC). It supports the management of SSH keys, which are essential for secure server communication and access control. These keys are crucial for the security of your infrastructure, and Terraform Enterprise provides a way to manage and monitor them.

Table Usage Guide

The tfe_ssh_key table provides insights into SSH keys within Terraform Enterprise. As a DevOps engineer, explore key-specific details through this table, including key ID, name, and associated metadata. Utilize it to uncover information about keys, such as their creation and last usage time, which can be crucial for auditing and security purposes.

Examples

Basic info

Explore the SSH keys in your environment to understand their role and usage. This is crucial for maintaining secure access to your systems.

select
  *
from
  tfe_ssh_key;

select
  *
from
  tfe_ssh_key;

Get SSH key by ID

Identify specific SSH keys by their unique identifiers to quickly access and manage them, enhancing security and control over your system.

select
  *
from
  tfe_ssh_key
where
  id = 'sshkey-1NSDCvowf3WtbStu';

select
  *
from
  tfe_ssh_key
where
  id = 'sshkey-1NSDCvowf3WtbStu';

Schema for tfe_ssh_key

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
id	text	=	ID of the ssh key.
name	text		Name of the ssh key.
organization_name	text	=, !=, ~~, ~~, !~~, !~~	Name of the organization containing the ssh key.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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)" -- tfe

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

steampipe_export_tfe --config '<your_config>' tfe_ssh_key