steampipe plugin install aiven

Table: aiven_project_event_log - Query Aiven Project Event Logs using SQL

Aiven Project Event Log is a resource within Aiven that allows you to monitor and track the history of events related to your cloud projects. It provides a detailed log of all project activities, including changes made, errors occurred, and actions taken. Aiven Project Event Log helps you stay informed about the status and performance of your projects and take appropriate actions when required.

Table Usage Guide

The aiven_project_event_log table provides insights into the event logs within Aiven Project. As a DevOps engineer, explore event-specific details through this table, including event type, time, and associated metadata. Utilize it to uncover information about project activities, such as the changes made, errors occurred, and actions taken, to maintain the health and performance of your projects.

Examples

Basic info

Explore which events occurred in your project, who performed them, and when. This allows you to track changes and maintain a comprehensive log of project activities.

select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log;
select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log;

Get user who deleted the service redis-turbot

Discover who was responsible for removing a specific service, in this case 'redis-turbot', by exploring the event logs. This can be particularly useful for auditing purposes or for troubleshooting when a service unexpectedly disappears.

select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log
where
service_name = 'redis-turbot'
and event_type = 'service_delete';
select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log
where
service_name = 'redis-turbot'
and event_type = 'service_delete';

List users who created service integration in last 7 days

Explore which users have established a new service integration within the past week. This is particularly useful to monitor recent system changes and maintain security compliance.

select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log
where
event_type = 'service_integration_create'
and time >= (now() - interval '7' day);
select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log
where
event_type = 'service_integration_create'
and time >= datetime('now', '-7 day');

List users who powered down the services

Identify instances where users have powered down services, providing valuable insights into project management and service usage patterns.

select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log
where
event_type = 'service_poweroff';
select
actor,
event_desc,
event_type,
project_name,
time
from
aiven_project_event_log
where
event_type = 'service_poweroff';

Schema for aiven_project_event_log

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
actortextInitiator of the event.
event_desctextThe event description.
event_typetextEvent type identifier.
project_nametext=The project name.
service_nametextThe service name.
timetimestamp with time zoneTimestamp in ISO 8601 format, always in UTC.

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

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

steampipe_export_aiven --config '<your_config>' aiven_project_event_log