tem_tenant_finding_link

CREATE VIEW tem_tenant_finding_link AS
SELECT
    'What web data' AS tool_name,
    '/tem/tenant/what_web.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_what_web_result WHERE tenant_id = t.tenant_id) AS count
FROM tem_tenant t

UNION ALL
SELECT
    'DNSX Scan Results',
    '/tem/tenant/dnsx.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_dnsx_result WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'Nuclei Scan Findings',
    '/tem/tenant/nuclei.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_nuclei_result WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'Naabu Port Scan Results',
    '/tem/tenant/naabu.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_naabu_result WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'Subfinder Results',
    '/tem/tenant/subfinder.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_subfinder WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'HTTPX Toolkit Results',
    '/tem/tenant/httpx-toolkit.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_httpx_result WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'Nmap Scan Results',
    '/tem/tenant/nmap.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_nmap WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'Katana Scan Results',
    '/tem/tenant/katana.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_katana WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'TLS Certificate Results',
    '/tem/tenant/tlsx_certificate.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_tlsx_certificate WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'Dirsearch Web Path Enumeration Results',
    '/tem/tenant/dirsearch.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_dirsearch WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'TestSSL Report',
    '/tem/tenant/tssl_certificate.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_testssl_general WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'SSL/TLS Certificate Metadata',
    '/tem/tenant/openssl.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_openssl WHERE tenant_id = t.tenant_id)
FROM tem_tenant t

UNION ALL
SELECT
    'WAF Detection Results',
    '/tem/tenant/wafw00f.sql?tenant_id=' || tenant_id AS redirect_url,
    tenant_id,
    tenant_name,
    (SELECT COUNT(*) FROM tem_wafw00f WHERE tenant_id = t.tenant_id)
FROM tem_tenant t