Table: steampipecloud_audit_log

Audit logs record series of events performed on the identity.

Note: You must specify an organization or user ID, or an organization or user handle, in the where or join clause using the identity_id or identity_handle columns respectively.

Examples

List audit logs for a user handle

select
  id,
  action_type,
  jsonb_pretty(data) as data
from
  steampipecloud_audit_log
where
  identity_handle = 'myuser';

List audit logs for a user ID

select
  id,
  action_type,
  jsonb_pretty(data) as data
from
  steampipecloud_audit_log
where
  identity_id = 'u_c6fdjke232example';

List audit logs for an organization handle

select
  id,
  action_type,
  jsonb_pretty(data) as data
from
  steampipecloud_audit_log
where
  identity_handle = 'myorg';

List audit logs for an organization ID

select
  id,
  action_type,
  jsonb_pretty(data) as data
from
  steampipecloud_audit_log
where
  identity_id = 'o_c6qjjsaa6guexample';

Schema for steampipecloud_audit_log

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
action_type	text		The action performed on the resource.
actor_avatar_url	text		The avatar of an actor who has performed the action.
actor_display_name	text		The display name of an actor.
actor_handle	text		The handle name of an actor.
actor_id	text		The unique identifier of an actor.
actor_ip	text		The IP address of the actor.
created_at	timestamp with time zone		The time when the action was performed.
data	jsonb		The data which has been modified on the entity.
id	text		The unique identifier for an audit log.
identity_handle	text	=	The handle name for an identity where the action has been performed.
identity_id	text	=	The unique identifier for an identity where the action has been performed.
process_id	text		The process id which this entry is a part of.
target_handle	text		The handle name of the entity where the action has been performed.
target_id	text		The unique identifier of the entity where the action has been performed.