steampipe plugin install francois2metz/gitguardian

Table: gitguardian_source

Returns the sources monitored.

Examples

List sources

select
id,
url
from
gitguardian_source;

List at risk sources

select
id,
url,
health
from
gitguardian_source
where
health = 'at_risk';

List unscanned sources

select
id,
url,
health
from
gitguardian_source
where
last_scan_date is null;

List sources where the last scan failed

select
id,
url,
health
from
gitguardian_source
where
last_scan_status = 'failed';

List source with open incidents

select
id,
url,
open_incidents_count
from
gitguardian_source
where
open_incidents_count > 0;

Schema for gitguardian_source

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
closed_incidents_countbigintNumber of closed secret incidents with at least one occurrence on this source.
full_nametextThe full name of the source.
healthtextSource health: safe, unknown or at_risk.
idbigint=Unique identifier of the source.
last_scan_datetimestamp with time zoneCreation date of this historical scan.
last_scan_statustextStatus of the last scan: pending, running, canceled, failed, too_large, timeout, finished.
open_incidents_countbigintNumber of open secret incidents with at least one occurrence on this source.
typetextSource type.
urltextURL of the source.
visibilitytextThe visibility of the source (public or private).