v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

steampipe plugin install l-teles/detectifysteampipe plugin install l-teles/detectify

detectify_asset detectify_asset_full detectify_connector detectify_finding detectify_ip detectify_member detectify_policy detectify_port detectify_profile detectify_technology

Table: detectify_connector

This table contains information about connectors and their configurations in Detectify.

The token_v3 argument is required to use this table, meaning you need to create an API key for v3 on Detectify.

Examples

List all connectors

select
  id,
  name,
  team_token,
  provider,
  created_at,
  updated_at
from
  detectify_connector;

List connectors with their last run status

select
  id,
  name,
  last_run ->> 'status' as "last_run_status",
  last_run ->> 'error' as "last_run_error",
  last_run ->> 'completed_at' as "last_run_completed_at"
from
  detectify_connector;

Count connectors by provider

select
  count(*) as connectors,
  provider
from
  detectify_connector
group by
  provider;

Schema for detectify_connector

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		Timestamp when the connector was created.
id	text		Unique ID of the connector.
last_run	jsonb		Details of the last run of the connector.
name	text		Name of the connector.
provider	text		Provider of the connector.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team_token	text		Team token associated with the connector.
updated_at	timestamp with time zone		Timestamp when the connector was last updated.