steampipe plugin install francois2metz/gitguardiansteampipe plugin install francois2metz/gitguardian

Table: gitguardian_audit_log

Returns the audit log.

Examples

select
  id,
  date,
  event_name,
  action_type
from
  gitguardian_audit_log
order by
  date;

select
  id,
  date,
  event_name,
  action_type
from
  gitguardian_audit_log
where
  action_type = 'DELETE';

select
  id,
  date,
  event_name,
  action_type
from
  gitguardian_audit_log
where
  member_email = 'test@example.net';

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
action_type	text		Type of the action: READ, CREATE, UPDATE, DELETE, OTHER.
api_token_id	bigint		ID of the API token associated to the event if it was done through the API.
data	jsonb		Additional data associated to the event.
date	timestamp with time zone	>, >=, =, <, <=	Date the event occurred.
event_name	text	=	The name of the event.
id	bigint		Unique identifier of the log.
ip_address	inet		The ip address.
member_email	text	=	Email of the member at the time he/she did the event.
member_id	bigint	=	ID of the member that did the event. Can be null if the member has been deleted since then.
member_name	text	=	Name of the member at the time he/she did the event.