tem/tenant_asset.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_asset.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,
     'tenant/attack_surface_mapping_inner.sql?tenant_id='|| $tenant_id AS link FROM tem_tenant WHERE tenant_id=$tenant_id;
 SELECT 'Assets' AS title,
     '#' AS link;

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

 SELECT
   'text'              as component,
   'Collection of reconnaissance and security assessment tools used for subdomain discovery, port scanning, DNS probing, web technology fingerprinting, TLS analysis, and vulnerability detection.' as contents;
 

 SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search;

 SELECT
     asset 
 FROM tem_eaa_asset_uri;