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

Table: detectify_profile

This table contains information about web application scan profiles used by Detectify.

Examples

select
  name,
  endpoint,
  status,
  latest_scan
from
  detectify_profile;

select
  name,
  endpoint,
  status,
  latest_scan
from
  detectify_profile
where
  status != 'verified';

select
  count(*) as scans,
  latest_scan ->> 'status' as "status"
from
  detectify_profile
group by
  latest_scan ->> 'status';

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created	timestamp with time zone		Timestamp when the profile was created.
endpoint	text		Endpoint of the profile.
latest_scan	jsonb		Latest scan details
name	text		Name of the profile.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Status of the profile.
token	text		Token associated with the profile.