tem_what_web_result

Column	Type
uniform_resource_id	TEXT
tenant_id	TEXT
tenant_name	TEXT
ur_ingest_session_id	TEXT
target_url
http_status
ip_address
http_server
page_title
uncommon_headers
country
module
strict_transport_security
x_frame_options

SQL DDL

CREATE VIEW tem_what_web_result AS
SELECT
    uw.uniform_resource_id,
    t.tenant_id,
    t.tenant_name,
    ts.ur_ingest_session_id,
    json_extract(uw.object, '$.target') AS target_url,
    json_extract(uw.object, '$.http_status') AS http_status,
    json_extract(uw.object, '$.plugins.IP.string[0]') AS ip_address,
    json_extract(uw.object, '$.plugins.HTTPServer.string[0]') AS http_server,
    json_extract(uw.object, '$.plugins.Title.string[0]') AS page_title,
    json_extract(uw.object, '$.plugins.UncommonHeaders.string[0]') AS uncommon_headers,
    json_extract(uw.object, '$.plugins.Country.string[0]') AS country,
    json_extract(uw.object, '$.plugins.Country.module[0]') AS module,
    json_extract(uw.object, '$.plugins.Strict-Transport-Security.string[0]') AS strict_transport_security,
    json_extract(uw.object, '$.plugins.X-Frame-Options.string[0]') AS x_frame_options
FROM tem_what_web_result_original_json uw
INNER JOIN uniform_resource ur ON ur.uniform_resource_id = uw.uniform_resource_id
INNER JOIN tem_tenant t ON t.device_id = ur.device_id
INNER JOIN tem_session ts ON ur.device_id = ts.device_id