sqlpage_files (table) Content

sqlpage_files (table) Schema
console/content/table/orchestration_session_entry.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_entry.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_entry.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/orchestration_session_state.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_state.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_state.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/orchestration_session_exec.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_exec.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_exec.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/orchestration_session_issue.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_issue.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_issue.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/orchestration_session_issue_relation.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_issue_relation.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_issue_relation.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/orchestration_session_log.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_log.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_log.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/uniform_resource_graph.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/uniform_resource_edge.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_edge.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_edge.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/ur_ingest_session_osquery_ms_log.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/ur_ingest_session_osquery_ms_log.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/ur_ingest_session_osquery_ms_log.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/osquery_policy.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/osquery_policy.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/osquery_policy.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_distributed_query.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_query.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_query.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_distributed_result.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_result.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_result.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_carve.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_carve.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_carve.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_system_info.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_system_info.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_system_info.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_os_version.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_os_version.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_os_version.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_interface_address.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_interface_address.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_interface_address.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_uptime.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_uptime.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_uptime.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_available_space.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_available_space.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_available_space.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_boundary.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_boundary.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_boundary.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_installed_software.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_installed_software.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_installed_software.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/table/surveilr_osquery_ms_node_executed_policy.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_executed_policy.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node_executed_policy.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_session_by_device.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_by_device.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_by_device.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_session_duration.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_duration.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_duration.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_success_rate.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_success_rate.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_success_rate.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_session_script.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_script.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_script.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_executions_by_type.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_executions_by_type.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_executions_by_type.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_execution_success_rate_by_type.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_execution_success_rate_by_type.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_execution_success_rate_by_type.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_session_summary.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_summary.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_summary.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_issue_remediation.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_issue_remediation.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_issue_remediation.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/orchestration_logs_by_session.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_logs_by_session.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_logs_by_session.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/plm_graph.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/plm_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/plm_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/imap_graph.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/imap_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/imap_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/filesystem_graph.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/filesystem_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/filesystem_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/surveilr_osquery_ms_node_detail.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/surveilr_osquery_ms_node_detail.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/surveilr_osquery_ms_node_detail.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/uniform_resource_file.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_file.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_file.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/uniform_resource_imap.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/uniform_resource_imap_content.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap_content.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap_content.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/ur_ingest_session_files_stats.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/ur_ingest_session_files_stats_latest.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats_latest.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats_latest.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/ur_ingest_session_tasks_stats.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/ur_ingest_session_tasks_stats_latest.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
console/content/view/ur_ingest_session_file_issue.sql SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_file_issue.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_file_issue.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; 2025-04-17 22:11:10
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; 2025-04-17 22:11:10
ms/node.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 '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; SELECT $host_id || ' Node' AS title, '#' AS link; -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui) SET total_rows = (SELECT COUNT(*) FROM surveilr_osquery_ms_node_installed_software WHERE node_key = $key AND $tab = 'software'); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'title' as component, $host_id as contents, 2 as level; SELECT 'text' as component, 'Last fetched ' || "last_fetched" as contents, 1 as size FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'datagrid' as component; SELECT 'Status' as title, "node_status" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Issues' as title, "issues" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Disk space' as title, "available_space" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Memory' as title, ROUND("physical_memory" / (1024 * 1024 * 1024), 2) || ' GB' AS description FROM surveilr_osquery_ms_node_system_info WHERE node_key = $key; SELECT 'Processor Type' as title, "cpu_type" as description FROM surveilr_osquery_ms_node_system_info WHERE node_key = $key; SELECT 'Operating system' as title, "operating_system" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'osQuery' as title, "osquery_version" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Boundary' as title, "boundary" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'datagrid' as component; SELECT 'Added to surveilr' as title, "added_to_surveilr_osquery_ms" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Last Restarted' as title, "last_restarted" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Hardware Model' as title, "hardware_model" as description FROM surveilr_osquery_ms_node_system_info WHERE node_key = $key; SELECT 'Serial Number' as title, "hardware_serial" as description FROM surveilr_osquery_ms_node_system_info WHERE node_key = $key; SELECT 'IP Address' as title, "ip_address" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; SELECT 'Team' as title, "-" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key; -- Define tabs SELECT 'tab' AS component, TRUE AS center; -- Tab 1: Software SELECT 'Software' AS title, '?tab=software&key=' || $key || '&host_id=' || $host_id AS link, $tab = 'software' AS active; -- Tab 2: Software SELECT 'Policies' AS title, '?tab=policies&key=' || $key || '&host_id=' || $host_id AS link, $tab = 'policies' AS active; -- SELECT 'IP Address' as title, "ip_address" as description FROM surveilr_osquery_ms_node_detail WHERE node_key = $key AND ($tab = 'details' OR $tab IS NULL); -- Tab specific content for Software select 'text' as component, 'Software' as title WHERE $tab = 'software'; SELECT 'table' AS component, TRUE as sort, TRUE as search WHERE $tab = 'software'; SELECT name, version, type, platform, '-' AS "Vulnerabilities" FROM surveilr_osquery_ms_node_installed_software WHERE node_key = $key AND $tab = 'software' LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || '&key=' || $key || '&host_id=' || $host_id || '&tab=' || $tab || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ") " || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || '&key=' || $key || '&host_id=' || $host_id || '&tab=' || $tab || ')' ELSE '' END) AS contents_md ;; -- Tab specific content for Policies select 'text' as component, 'Policies' as title WHERE $tab = 'software'; SELECT 'table' AS component, TRUE as sort, TRUE as search WHERE $tab = 'policies'; SELECT policy_name AS "Policy", policy_result as "Status", resolution FROM surveilr_osquery_ms_node_executed_policy WHERE node_key = $key AND $tab = 'policies'; 2025-04-17 22:11:10
ms/policies.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/policies.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, 'Policies' as contents; SELECT 'table' AS component, 'Policy Name' as markdown, TRUE as sort, TRUE as search; SELECT '[' || policy_name || '](policy.sql?policy_id=' || osquery_policy_id || ')' AS "Policy Name" FROM osquery_policy; 2025-04-17 22:11:10
ms/policy.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 '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; SELECT 'title' as component, "policy_name" as contents, 1 as level FROM osquery_policy where osquery_policy_id = $policy_id; SELECT 'text' as component, "policy_description" as contents FROM osquery_policy where osquery_policy_id = $policy_id; SELECT 'title' as component, 'Resolution:' as contents, 4 as level; SELECT 'text' as component, "policy_fail_remarks" as contents FROM osquery_policy where osquery_policy_id = $policy_id; SELECT 'code' as component; SELECT 'Query:' as title, 'sql' as language, "osquery_code" as contents FROM osquery_policy where osquery_policy_id = $policy_id; SELECT 'title' as component, 'Compatible with:' as contents, 4 as level; SELECT 'text' AS component, value AS contents FROM osquery_policy, json_each(osquery_policy.osquery_platforms) WHERE osquery_policy_id = $policy_id; 2025-04-17 22:11:10
add_policy_to_code_notebook.sql DELETE FROM code_notebook_cell WHERE cell_name = '' AND notebook_name 'osQuery Management Server (Policy)'; 2025-04-17 22:11:10

Previous (Page 5 of 5)