Table: detectify_asset_full

An asset in Detectify refers to any domain or subdomain that is monitored and scanned for vulnerabilities by the surface monitoring module, web application scanner or both.

Examples

List all assets

select
  name,
  status,
  last_seen,
  monitored
from
  detectify_asset_full;

List the non-monitored assets

select
  name,
  status,
  last_seen,
  monitored
from
  detectify_asset_full
where
  monitored = 'false';

Group assets by monitored status

select
  count(*) as assets,
  monitored
from
  detectify_asset_full
group by
  monitored;