Table: linode_event - Query Linode Events using SQL

Linode Events are system events that occur on your Linode instances. They can include actions such as booting, shutting down, or resizing a Linode, and can be used to track changes and incidents in your environment. These events provide important information about the activity and performance of your resources.

Table Usage Guide

The linode_event table provides insights into system events related to Linode instances. As a system administrator or DevOps engineer, explore event-specific details through this table, including event types, timestamps, and associated metadata. Utilize it to monitor system activity, track changes, and identify potential issues related to your Linode instances.

Examples

List token create events

Explore which events are related to the creation of tokens. This can be useful in understanding and auditing security measures, as token creation often relates to authentication processes.

select
  *
from
  linode_event
where
  action = 'token_create';

select
  *
from
  linode_event
where
  action = 'token_create';

Discover the segments that pertain to a specific domain, enabling you to analyze and understand events related to that particular domain.

select
  *
from
  linode_event
where
  entity ->> 'type' = 'domain'
  and entity ->> 'label' = 'steampipe.io';

select
  *
from
  linode_event
where
  json_extract(entity, '$.type') = 'domain'
  and json_extract(entity, '$.label') = 'steampipe.io';

Schema for linode_event

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
action	text	=	The action that caused this Event. New actions may be added in the future.
created	timestamp with time zone		The date and time this event was created.
entity	jsonb		Detailed information about the Event's entity, including ID, type, label, and URL used to access it.
filter	text	=	Raw Linode list filter string in JSON format.
id	bigint	=	The unique ID of this Event.
percent_complete	bigint		A percentage estimating the amount of time remaining for an Event. Returns null for notification events.
rate	text		The rate of completion of the Event. Only some Events will return rate; for example, migration and resize Events.
read	boolean		If this Event has been read.
secondary_entity	jsonb		Detailed information about the Event's secondary or related entity, including ID, type, label, and URL used to access it.
seen	boolean		If this Event has been seen.
status	text		Current status of the Event, Enum: 'failed' 'finished' 'notification' 'scheduled' 'started'.
time_remaining	bigint		The estimated time remaining until the completion of this Event. This value is only returned for in-progress events.
username	text		The username of the User who caused 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)" -- linode

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

steampipe_export_linode --config '<your_config>' linode_event