tem/attack_surface_mapping_session.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
    SELECT
        COALESCE(abbreviated_caption, caption) AS title,
        COALESCE(url, path) AS link,
        parent_path, 0 AS level,
        namespace
    FROM sqlpage_aide_navigation
    WHERE namespace = 'prime' AND path='tem/attack_surface_mapping_session.sql'
    UNION ALL
    SELECT
        COALESCE(nav.abbreviated_caption, nav.caption) AS title,
        COALESCE(nav.url, nav.path) AS link,
        nav.parent_path, b.level + 1, nav.namespace
    FROM sqlpage_aide_navigation nav
    INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,      
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link        
FROM breadcrumbs ORDER BY level DESC;
              -- 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/attack_surface_mapping_session.sql/index.sql') as contents;
    ;


--- Dsply Page Title
SELECT
    'title'   as component,
    'Attack Surface Mapping By Session' contents;

SELECT
    'text'              as component,
    "This page presents the attack surface data collected during a specific session. It consolidates results from scanning and reconnaissance tools, showing discovered hosts, services, protocols, and exposed endpoints. This allows users to analyze session-specific findings, track changes over time, and prioritize security actions based on session-based activities." as contents;

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

SELECT 
    '[' || session_name || ']('||sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/tem/session/finding.sql?session_id=' || ur_ingest_session_id || ')' AS "Session",
    (SELECT COUNT(tool_name) FROM tem_session_finding_link WHERE ts.ur_ingest_session_id=ur_ingest_session_id) AS "Analysis Tools",
    IFNULL(ingest_started_at, '-') AS "Session Start Date",
    IFNULL(ingest_finished_at, '-') AS "Session End Date",
    IFNULL(agent, '-') AS "Agent",
    IFNULL(version, '-') AS "Version"
FROM tem_session ts;