| rssd-init |
Bootstrap SQL |
Bootstrap SQL for history/documentation purposes |
Documentation |
| ConstructionSqlNotebook |
v001_once_initialDDL |
Creates all service tables to initialize an RSSD (once_ pragma means it will only be run once in the database by surveilr) |
SQLite SQL Statements |
| ConstructionSqlNotebook |
session_ephemeral_table |
Creates a session_state_ephemeral table for session arguments |
SQLite SQL Statements |
| ConstructionSqlNotebook |
surveilr_table_size |
Creates a surveilr_table_size to compute the sizes for individual tables for statistical purposes. |
SQLite SQL Statements |
| ConstructionSqlNotebook |
v001_seedDML |
Seed data which provides default configuration for surveilr app |
SQLite SQL Statements |
| rssd-init |
understand notebooks schema |
Prepares a prompt that will allow the user to teach an LLM about this project's code notebooks schema |
Generative AI Large Language Model Prompt |
| rssd-init |
understand service schema |
Prepares a prompt that will allow the user to teach an LLM about this project's service schema |
Generative AI Large Language Model Prompt |
| osQuery Management Server (Prime) |
System Information |
System information for identification. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
osquery-ms Boundary (Linux and Macos) |
Get the boundary for a node. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
osquery-ms Boundary (Windows) |
Get the boundary for a node. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Installed Macos software |
Get all software installed on a Macos computer, including browser plugins and installed packages. Note that this does not include other running processes in the processes table. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Installed Windows software |
Get all software installed on a Windows computer, including browser plugins and installed packages. Note that this does not include other running processes in the processes table. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Installed Linux software |
Get all software installed on a Linux computer, including browser plugins and installed packages. Note that this does not include other running processes in the processes table. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Network Interfaces (Linux and Macos) |
Get network interfaces for identification. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Network Interfaces (Windows) |
Get network interfaces for identification. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
OS Version (Linux and Macos) |
Get OS version for identification. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
OS Version (Windows) |
Get OS version for identification. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Available Disk Space (Linux and Macos) |
Get available disk space for monitoring. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Available Disk Space (Windows) |
Get available disk space for monitoring. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Users |
Get users for security monitoring. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Listening Ports |
Get listening ports for security monitoring. |
SQLite SQL Statements |
| osQuery Management Server (Prime) |
Server Uptime |
Get server uptime for monitoring. |
SQLite SQL Statements |
| osQuery Management Server (Policy) |
Full disk encryption enabled (Linux) |
Check if full disk encryption is enabled on Linux systems. |
SQLite SQL Statements |
| osQuery Management Server (Policy) |
Full disk encryption enabled (Macos) |
Check if full disk encryption is enabled on Macos systems. |
SQLite SQL Statements |
| osQuery Management Server (Policy) |
Full disk encryption enabled (Windows) |
Check if full disk encryption is enabled on Windows systems. |
SQLite SQL Statements |
| osQuery Management Server (Policy) |
SSH keys encrypted |
Check if SSH keys are properly encrypted. |
SQLite SQL Statements |
| rssd-init |
surveilr-code-notebooks-erd.auto.puml |
ERD diagram for surveilr code notebooks |
Text Asset (.puml) |
| rssd-init |
surveilr-service-erd.auto.puml |
ERD diagram for surveilr service schema |
Text Asset (.puml) |
| rssd-init |
models_polygenix.rs |
Rust models for polygenix integration |
Text Asset (.rs) |
| ConstructionSqlNotebook |
auto_generate_console_content_tabular_sqlpage_files |
A series of idempotent INSERT statements which will auto-generate "default" content for all tables and views |
SQLite SQL Statements |
| Web UI |
auto_generate_console_content_tabular_sqlpage_files |
A series of idempotent INSERT statements which will auto-generate "default" content for all tables and views |
SQLite SQL Statements |