fleetfolio/host_list.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 = 'fleetfolio/host_list.sql/index.sql') as contents;
    ;
  --- Display breadcrumb
  SELECT
      'breadcrumb' AS component;
  SELECT
      'Home' AS title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'    AS link;
  SELECT
      'FleetFolio' AS title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/index.sql' AS link;  
  SELECT 'Boundary' AS title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/boundary.sql' AS link;
  SELECT boundary AS title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/host_list.sql?boundary_key=' || boundary_key  AS link
    FROM host_list WHERE boundary_key=$boundary_key LIMIT 1;


--- Dsply Page Title
SELECT
    'title'   as component,
    boundary as contents FROM host_list WHERE boundary_key=$boundary_key LIMIT 1;

   select
    'text'              as component,
    'A boundary refers to a defined collection of servers and assets that work together to provide a specific function or service. It typically represents a perimeter or a framework within which resources are organized, managed, and controlled. Within this boundary, servers and assets are interconnected, often with defined roles and responsibilities, ensuring that operations are executed smoothly and securely. This concept is widely used in IT infrastructure and network management to segment and protect different environments or resources.' as contents;

 -- asset list
  SELECT 'table' AS component,
      'host' as markdown,
      TRUE as sort,
      TRUE as search;
  SELECT 
  '[' || host || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/host_detail.sql?host_identifier=' || host_identifier || ')' as host,
  boundary,
  CASE 
      WHEN status = 'Online' THEN '🟢 Online'
      WHEN status = 'Offline' THEN '🔴 Offline'
      ELSE '⚠️ Unknown'
  END AS "Status",
  osquery_version as "Os query version",
  available_space AS "Disk space available",
  operating_system AS "Operating System",
  osquery_version AS "osQuery Version",
  ip_address AS "IP Address",
  last_fetched AS "Last Fetched",
  last_restarted AS "Last Restarted"
  FROM host_list WHERE boundary_key=$boundary_key;