orchestration_session_entry (table) Content

orchestration_session_entry (table) Schema


01JZ51DTQ5FXTFAQQFF648B814	01JZ51DTQ5HRA7A4YV9FX346Z1	https://surveilr.com/lib/pattern/osquery-ms/package.sql	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"https://surveilr.com/lib/pattern/osquery-ms/package.sql\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ51E037H8ZN329EKT3JHMZ1	01JZ51E037R1BDCJ56JF5FZWA7	https://surveilr.com/lib/pattern/osquery-ms/queries.sql	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"https://surveilr.com/lib/pattern/osquery-ms/queries.sql\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ51E595D99W4HB2E970NXJH	01JZ51E595YXT6YFDX72GF24W8	https://surveilr.com/lib/std/package.sql	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"https://surveilr.com/lib/std/package.sql\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ51EXDMJ65SFAM6Y5TAT097	01JZ51EXDMZE246BE6GPE01J93	https://surveilr.com/lib/pattern/osquery-ms/package.sql	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"https://surveilr.com/lib/pattern/osquery-ms/package.sql\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ51F1T1GG6RRS236ZE029HN	01JZ51F1T14AKET5JBFNEM670Z	https://surveilr.com/lib/pattern/osquery-ms/queries.sql	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"https://surveilr.com/lib/pattern/osquery-ms/queries.sql\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ51F5AW46MCK9GKHVGJH2JQ	01JZ51F5AW0CXJNHYVB9PA88F1	https://surveilr.com/lib/std/package.sql	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"https://surveilr.com/lib/std/package.sql\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ78E7HA4TH8M4GKDC4B2ZYN	01JZ78E7H9J75P9VF0QWP6GA55	/home/joby/workspaces/fork/www.surveilr.com/lib/service/fleetfolio/package.sql.ts	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"../package.sql.ts\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ7F73AKRR77FYCXJZW5274R	01JZ7F73AKP174V907WY3A99ET	/home/joby/workspaces/fork/www.surveilr.com/lib/service/fleetfolio/package.sql.ts	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"../package.sql.ts\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ851WWD4RW3D8TF05QKV88R	01JZ851WWD7B0D3E34D71YBECX	/home/joby/workspaces/fork/www.surveilr.com/lib/service/fleetfolio/package.sql.ts	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"../package.sql.ts\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ85P91KWJ4NMJJRXADPA5E3	01JZ85P91KV164QBF02E0XE0CZ	/home/joby/workspaces/fork/www.surveilr.com/lib/service/fleetfolio/package.sql.ts	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"../package.sql.ts\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}
01JZ9RE6EHE0PV4G46NR6FK7SB	01JZ9RE6EHS8D3X8CQJSZ565XS	/home/joby/workspaces/fork/www.surveilr.com/lib/service/fleetfolio/package.sql.ts	{"cmd":"shell","arguments":"{\"state_db_fs_path\":\"resource-surveillance.sqlite.db\",\"sqlite_dyn_extn\":[],\"sqlpkg\":null,\"engine\":\"Rusqlite\",\"scripts\":[\"../package.sql.ts\"],\"cmd\":null,\"no_observability\":false,\"output\":\"Json\",\"import_env\":null,\"session_state_table_name\":\"session_state_ephemeral\",\"silent\":false,\"emit_session_id\":false,\"command\":null}"}

Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

Error in query number 6:

Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:

            SELECT 'text' AS component,
                (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
                                 ⬆️
                '(Page ' || $current_page || ' of ' || $total_pages || ') ' ||

Backtrace

sql parser error: Expected: ), found: $current_page at Line: 42, Column: 35

"console/content/table/orchestration_session_entry.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.

You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.