Table: equinix_metal_event - Query Equinix Metal Events using SQL

Equinix Metal Events is a feature within the Equinix Metal platform that provides users with real-time information regarding the status and details of various events occurring within their infrastructure. This includes, but is not limited to, device state changes, operating system provisioning, and network maintenance events. It is a crucial tool for maintaining visibility and control over the infrastructure.

Table Usage Guide

The equinix_metal_event table provides insights into events within the Equinix Metal platform. As a system administrator, you can explore event-specific details through this table, including event types, status, and associated metadata. Utilize it to monitor your infrastructure, track system changes, and respond to events in a timely manner.

Examples

List all events

Explore all events within your Equinix Metal environment to gain insights into past activities and changes. This can be useful for auditing, troubleshooting, and understanding the history of your infrastructure.

select
  *
from
  equinix_metal_event;

select
  *
from
  equinix_metal_event;

All SSH key events

Uncover the details of all events related to SSH keys. This is useful for tracking changes and maintaining security within your network.

select
  *
from
  equinix_metal_event
where
  type like 'ssh_key.%';

select
  *
from
  equinix_metal_event
where
  type like 'ssh_key.%';

Schema for equinix_metal_event

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
body	text		Body of the event.
created_at	timestamp with time zone		When the event was created.
href	text		URL for this event.
id	text	=	ID of the event.
relationships	jsonb		Relationships from this event.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		State of the event.
type	text		Type of the event.

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_event