tem_session_finding_link

CREATE VIEW tem_session_finding_link AS
SELECT
    'What web data' AS tool_name,
    '/tem/session/what_web.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_what_web_result WHERE ur_ingest_session_id = s.ur_ingest_session_id) AS count
FROM tem_session s

UNION ALL
SELECT
    'DNSX Scan Results',
    '/tem/session/dnsx.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_dnsx_result WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'Nuclei Scan Findings',
    '/tem/session/nuclei.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_nuclei_result WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'Naabu Port Scan Results',
    '/tem/session/naabu.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_naabu_result WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'Subfinder Results',
    '/tem/session/subfinder.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_subfinder WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'HTTPX Toolkit Results',
    '/tem/session/httpx-toolkit.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_httpx_result WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'Nmap Scan Results',
    '/tem/session/nmap.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_nmap WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'Katana Scan Results',
    '/tem/session/katana.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_katana WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'TLS Certificate Results',
    '/tem/session/tlsx_certificate.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_tlsx_certificate WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'Dirsearch Web Path Enumeration Results',
    '/tem/session/dirsearch.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_dirsearch WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'TestSSL Report',
    '/tem/session/tssl_certificate.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_testssl_general WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'SSL/TLS Certificate Metadata',
    '/tem/session/openssl.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_openssl WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s

UNION ALL
SELECT
    'WAF Detection Results',
    '/tem/session/wafw00f.sql?session_id=' || ur_ingest_session_id AS redirect_url,
    ur_ingest_session_id,
    session_name,
    (SELECT COUNT(*) FROM tem_wafw00f WHERE ur_ingest_session_id = s.ur_ingest_session_id)
FROM tem_session s