ms/index.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='ms/index.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, 'All Registered Nodes' as contents;
  SELECT 'table' AS component,
      'Node' as markdown,
      'Issues' as markdown,
      TRUE as sort,
      TRUE as search;
  
 SELECT 
    '[' || host_identifier || '](node.sql?key=' || node_key || '&host_id=' || host_identifier || ')' AS "Node",
    node_status AS "Status",
    CONCAT('[', issues, '](node.sql?key=', node_key, '&host_id=', host_identifier, '&tab=policies)') AS "Issues",
    available_space AS "Disk space available",
    operating_system AS "Operating System",
    osquery_version AS "osQuery Version",
    ip_address AS "IP Address",
    boundary AS "Boundary",
    '-' AS "Team",
    last_fetched AS "Last Fetched",
    last_restarted AS "Last Restarted"
FROM surveilr_osquery_ms_node_detail;
  
 WITH navigation_cte AS (
          SELECT COALESCE(title, caption) as title, description
              FROM sqlpage_aide_navigation
          WHERE namespace = 'prime' AND path = 'ms'||'/index.sql'
          )
          SELECT 'list' AS component, title, description
              FROM navigation_cte;
          SELECT caption as title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' || COALESCE(url, path) as link, description
              FROM sqlpage_aide_navigation
          WHERE namespace = 'prime' AND parent_path =  'ms'||'/index.sql'
          ORDER BY sibling_order;