steampipe plugin install francois2metz/gitguardiansteampipe plugin install francois2metz/gitguardian

Table: gitguardian_secret_incident

Returns the leaked incidents detected.

Examples

select
  id,
  date,
  status
from
  gitguardian_secret_incident;

select
  id,
  date,
  status
from
  gitguardian_secret_incident
where
  status in ('TRIGGERED', 'ASSIGNED');

select
  id,
  date,
  status,
  share_url
from
  gitguardian_secret_incident
where
  share_url is not null;

select
  id,
  date,
  status,
  occurrences_count
from
  gitguardian_secret_incident
order by
  occurrences_count desc;

select
  id,
  date,
  status
from
  gitguardian_secret_incident
where
  date > (current_date - interval '1' month);

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
assignee_email	text	=	Assignee email.
date	timestamp with time zone	>, >=, =, <, <=	Last trigger date.
detector_display_name	text		Display of the detector.
detector_family	text		Family of the detector.
detector_group_display_name	text		Group display name of the detector.
detector_group_name	text		Group name of the detector.
detector_name	text		Name of the detector.
detector_nature	text		Nature of the detector.
gitguardian_url	text		The URL to gitguardian.
id	bigint	=	Unique identifier of the incident.
ignore_reason	text		The reason of the ignore status: test_credential, false_positive, low_risk
ignored_at	timestamp with time zone		The date where it has been ignored.
occurrences_count	bigint		Number of occurrences.
regression	boolean		True if it's a regression.
resolved_at	timestamp with time zone		The date where it has been resolved.
secret_hash	text		Unique hash.
secret_revoked	boolean		True if the secret has been revoked.
severity	text	=	Severity of the incident: critical, high, medium, low, info, unknown.
share_url	text		The public URL of the incident (if any).
status	text	=	Status of the incident: IGNORED, TRIGGERED, ASSIGNED, RESOLVED).
tags	jsonb		Can be FROM_HISTORICAL_SCAN, IGNORED_IN_CHECK_RUN, PUBLIC, REGRESSION, SENSITIVE_FILE or TEST_FILE
validity	text	=	The validity state: valid, invalid, failed_to_check, no_checker, unknown