Table: gitguardian_source
Returns the sources monitored.
Examples
List sources
select id, urlfrom gitguardian_source;
List at risk sources
select id, url, healthfrom gitguardian_sourcewhere health = 'at_risk';
List unscanned sources
select id, url, healthfrom gitguardian_sourcewhere last_scan_date is null;
List sources where the last scan failed
select id, url, healthfrom gitguardian_sourcewhere last_scan_status = 'failed';
List source with open incidents
select id, url, open_incidents_countfrom gitguardian_sourcewhere open_incidents_count > 0;
Schema for gitguardian_source
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
closed_incidents_count | bigint | Number of closed secret incidents with at least one occurrence on this source. | |
full_name | text | The full name of the source. | |
health | text | Source health: safe, unknown or at_risk. | |
id | bigint | = | Unique identifier of the source. |
last_scan_date | timestamp with time zone | Creation date of this historical scan. | |
last_scan_status | text | Status of the last scan: pending, running, canceled, failed, too_large, timeout, finished. | |
open_incidents_count | bigint | Number of open secret incidents with at least one occurrence on this source. | |
type | text | Source type. | |
url | text | URL of the source. | |
visibility | text | The visibility of the source (public or private). |