tem_nuclei_result

Column	Type
uniform_resource_id	TEXT
tenant_id	TEXT
tenant_name	TEXT
ur_ingest_session_id	TEXT
host
url
template_id
name
description
severity
ip
matched_path
timestamp

SQL DDL

CREATE VIEW tem_nuclei_result AS
SELECT
  ur.uniform_resource_id,
  t.tenant_id,
  t.tenant_name,
  ts.ur_ingest_session_id,
  json_extract(ur.content, '$.host') AS host,
  json_extract(ur.content, '$.url') AS url,
  json_extract(ur.content, '$.template-id') AS template_id,
  json_extract(ur.content, '$.info.name') AS name,
  json_extract(ur.content, '$.info.description') AS description,
  json_extract(ur.content, '$.info.severity') AS severity,
  json_extract(ur.content, '$.ip') AS ip,
  json_extract(ur.content, '$.meta.paths') AS matched_path,
  json_extract(ur.content, '$.timestamp') AS timestamp
FROM uniform_resource ur
INNER JOIN tem_tenant t ON t.device_id = ur.device_id
INNER JOIN tem_session ts ON ur.device_id = ts.device_id
WHERE ur.nature = 'jsonl'
  AND ur.uri LIKE '%/nuclei/%'