tem_naabu_result

Column	Type
uniform_resource_id	TEXT
tenant_id	TEXT
tenant_name	TEXT
ur_ingest_session_id	TEXT
host
ip
timestamp
port
protocol
tls

SQL DDL

CREATE VIEW tem_naabu_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, '$.ip') AS ip,
  json_extract(ur.content, '$.timestamp') AS timestamp,
  json_extract(ur.content, '$.port') AS port,
  json_extract(ur.content, '$.protocol') AS protocol,
  json_extract(ur.content, '$.tls') AS tls
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 '%/naabu/%'