tem/tenant/finding.sql

            SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
            -- not including breadcrumbs from sqlpage_aide_navigation
            -- not including page title from sqlpage_aide_navigation
            

            SELECT 'title' AS component, (SELECT COALESCE(title, caption)
  FROM sqlpage_aide_navigation
 WHERE namespace = 'prime' AND path = 'tem/tenant/finding.sql/index.sql') as contents;
  ;
--- Display breadcrumb
SELECT
    'breadcrumb' AS component;
SELECT
    'Home' AS title,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'    AS link;
SELECT
    'Threat Exposure Management' AS title,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/tem/index.sql' AS link;  
SELECT 'Attack Surface Mapping By Tenant' AS title,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/tem/attack_surface_mapping_tenant.sql' AS link;
 SELECT tenant_name AS title,
        sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/tem/tenant/attack_surface_mapping_inner.sql?tenant_id=' || $tenant_id AS link FROM tem_tenant WHERE tenant_id=$tenant_id;
SELECT 'Findings' AS title,
    '#' AS link;

--- Dsply Page Title
SELECT
  'title'   as component,
  'Findings' as contents;

SELECT
  'text'              as component,
  'Detailed insights from each security tool, including scan results, fingerprints, DNS records, TLS details, subdomain enumeration, and vulnerability assessments, mapped per asset for better threat exposure analysis.' as contents;


SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
'Asset' as markdown;

SELECT
    '[' || tool_name || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '' || redirect_url || ')' AS Asset,
    tenant_name AS "Tenant Name",
    count
FROM tem_tenant_finding_link
WHERE tenant_id = $tenant_id;