console_information_schema_view (view) Content
| rssd_statistics_overview | total_tables | /console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes | [Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | [rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | /console/content/view/rssd_statistics_overview.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) | [rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) | CREATE VIEW rssd_statistics_overview AS SELECT (SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb, (SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes, (SELECT SUM(tbl_rows) FROM ( SELECT name, (SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows FROM sqlite_master t WHERE type='table' )) AS total_rows, (SELECT page_size FROM pragma_page_size()) AS page_size, (SELECT page_count FROM pragma_page_count()) AS total_pages | |
| rssd_statistics_overview | total_indexes | /console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes | [Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | [rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | /console/content/view/rssd_statistics_overview.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) | [rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) | CREATE VIEW rssd_statistics_overview AS SELECT (SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb, (SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes, (SELECT SUM(tbl_rows) FROM ( SELECT name, (SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows FROM sqlite_master t WHERE type='table' )) AS total_rows, (SELECT page_size FROM pragma_page_size()) AS page_size, (SELECT page_count FROM pragma_page_count()) AS total_pages | |
| rssd_statistics_overview | total_rows | /console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes | [Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | [rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | /console/content/view/rssd_statistics_overview.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) | [rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) | CREATE VIEW rssd_statistics_overview AS SELECT (SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb, (SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes, (SELECT SUM(tbl_rows) FROM ( SELECT name, (SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows FROM sqlite_master t WHERE type='table' )) AS total_rows, (SELECT page_size FROM pragma_page_size()) AS page_size, (SELECT page_count FROM pragma_page_count()) AS total_pages | |
| rssd_statistics_overview | page_size | BLOB | /console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes | [Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | [rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | /console/content/view/rssd_statistics_overview.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) | [rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) | CREATE VIEW rssd_statistics_overview AS SELECT (SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb, (SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes, (SELECT SUM(tbl_rows) FROM ( SELECT name, (SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows FROM sqlite_master t WHERE type='table' )) AS total_rows, (SELECT page_size FROM pragma_page_size()) AS page_size, (SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview | total_pages | BLOB | /console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes | [Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | [rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) | /console/content/view/rssd_statistics_overview.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) | [rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) | CREATE VIEW rssd_statistics_overview AS SELECT (SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb, (SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables, (SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes, (SELECT SUM(tbl_rows) FROM ( SELECT name, (SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows FROM sqlite_master t WHERE type='table' )) AS total_rows, (SELECT page_size FROM pragma_page_size()) AS page_size, (SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_table_statistic | table_name | TEXT | /console/info-schema/view.sql?name=rssd_table_statistic&stats=yes | [Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | [rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | /console/content/view/rssd_table_statistic.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) | [rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) | CREATE VIEW rssd_table_statistic AS SELECT m.name AS table_name, (SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns, (SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes, (SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys, (SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys, (SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb FROM sqlite_master m WHERE m.type = 'table' |
| rssd_table_statistic | total_columns | /console/info-schema/view.sql?name=rssd_table_statistic&stats=yes | [Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | [rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | /console/content/view/rssd_table_statistic.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) | [rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) | CREATE VIEW rssd_table_statistic AS SELECT m.name AS table_name, (SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns, (SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes, (SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys, (SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys, (SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb FROM sqlite_master m WHERE m.type = 'table' | |
| rssd_table_statistic | total_indexes | /console/info-schema/view.sql?name=rssd_table_statistic&stats=yes | [Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | [rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | /console/content/view/rssd_table_statistic.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) | [rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) | CREATE VIEW rssd_table_statistic AS SELECT m.name AS table_name, (SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns, (SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes, (SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys, (SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys, (SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb FROM sqlite_master m WHERE m.type = 'table' | |
| rssd_table_statistic | foreign_keys | /console/info-schema/view.sql?name=rssd_table_statistic&stats=yes | [Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | [rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | /console/content/view/rssd_table_statistic.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) | [rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) | CREATE VIEW rssd_table_statistic AS SELECT m.name AS table_name, (SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns, (SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes, (SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys, (SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys, (SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb FROM sqlite_master m WHERE m.type = 'table' | |
| rssd_table_statistic | primary_keys | /console/info-schema/view.sql?name=rssd_table_statistic&stats=yes | [Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | [rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | /console/content/view/rssd_table_statistic.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) | [rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) | CREATE VIEW rssd_table_statistic AS SELECT m.name AS table_name, (SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns, (SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes, (SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys, (SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys, (SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb FROM sqlite_master m WHERE m.type = 'table' | |
| rssd_table_statistic | table_size_mb | REAL | /console/info-schema/view.sql?name=rssd_table_statistic&stats=yes | [Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | [rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) | /console/content/view/rssd_table_statistic.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) | [rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) | CREATE VIEW rssd_table_statistic AS SELECT m.name AS table_name, (SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns, (SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes, (SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys, (SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys, (SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb FROM sqlite_master m WHERE m.type = 'table' |
| orchestration_session_by_device | device_id | VARCHAR | /console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) | [orchestration_session_by_device (view) Schema](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) | /console/content/view/orchestration_session_by_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_by_device.sql?stats=yes) | [orchestration_session_by_device (view) Content](console/content/view/orchestration_session_by_device.sql?stats=yes) | CREATE VIEW orchestration_session_by_device AS SELECT d.device_id, d.name AS device_name, COUNT(*) AS session_count FROM orchestration_session os JOIN device d ON os.device_id = d.device_id GROUP BY d.device_id, d.name |
| orchestration_session_by_device | device_name | TEXT | /console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) | [orchestration_session_by_device (view) Schema](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) | /console/content/view/orchestration_session_by_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_by_device.sql?stats=yes) | [orchestration_session_by_device (view) Content](console/content/view/orchestration_session_by_device.sql?stats=yes) | CREATE VIEW orchestration_session_by_device AS SELECT d.device_id, d.name AS device_name, COUNT(*) AS session_count FROM orchestration_session os JOIN device d ON os.device_id = d.device_id GROUP BY d.device_id, d.name |
| orchestration_session_by_device | session_count | /console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) | [orchestration_session_by_device (view) Schema](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) | /console/content/view/orchestration_session_by_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_by_device.sql?stats=yes) | [orchestration_session_by_device (view) Content](console/content/view/orchestration_session_by_device.sql?stats=yes) | CREATE VIEW orchestration_session_by_device AS SELECT d.device_id, d.name AS device_name, COUNT(*) AS session_count FROM orchestration_session os JOIN device d ON os.device_id = d.device_id GROUP BY d.device_id, d.name | |
| orchestration_session_duration | orchestration_session_id | VARCHAR | /console/info-schema/view.sql?name=orchestration_session_duration&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | [orchestration_session_duration (view) Schema](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | /console/content/view/orchestration_session_duration.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_duration.sql?stats=yes) | [orchestration_session_duration (view) Content](console/content/view/orchestration_session_duration.sql?stats=yes) | CREATE VIEW orchestration_session_duration AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, os.orch_started_at, os.orch_finished_at, (JULIANDAY(os.orch_finished_at) - JULIANDAY(os.orch_started_at)) * 24 * 60 * 60 AS duration_seconds FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id WHERE os.orch_finished_at IS NOT NULL |
| orchestration_session_duration | orchestration_nature | TEXT | /console/info-schema/view.sql?name=orchestration_session_duration&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | [orchestration_session_duration (view) Schema](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | /console/content/view/orchestration_session_duration.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_duration.sql?stats=yes) | [orchestration_session_duration (view) Content](console/content/view/orchestration_session_duration.sql?stats=yes) | CREATE VIEW orchestration_session_duration AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, os.orch_started_at, os.orch_finished_at, (JULIANDAY(os.orch_finished_at) - JULIANDAY(os.orch_started_at)) * 24 * 60 * 60 AS duration_seconds FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id WHERE os.orch_finished_at IS NOT NULL |
| orchestration_session_duration | orch_started_at | TIMESTAMPTZ | /console/info-schema/view.sql?name=orchestration_session_duration&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | [orchestration_session_duration (view) Schema](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | /console/content/view/orchestration_session_duration.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_duration.sql?stats=yes) | [orchestration_session_duration (view) Content](console/content/view/orchestration_session_duration.sql?stats=yes) | CREATE VIEW orchestration_session_duration AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, os.orch_started_at, os.orch_finished_at, (JULIANDAY(os.orch_finished_at) - JULIANDAY(os.orch_started_at)) * 24 * 60 * 60 AS duration_seconds FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id WHERE os.orch_finished_at IS NOT NULL |
| orchestration_session_duration | orch_finished_at | TIMESTAMPTZ | /console/info-schema/view.sql?name=orchestration_session_duration&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | [orchestration_session_duration (view) Schema](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | /console/content/view/orchestration_session_duration.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_duration.sql?stats=yes) | [orchestration_session_duration (view) Content](console/content/view/orchestration_session_duration.sql?stats=yes) | CREATE VIEW orchestration_session_duration AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, os.orch_started_at, os.orch_finished_at, (JULIANDAY(os.orch_finished_at) - JULIANDAY(os.orch_started_at)) * 24 * 60 * 60 AS duration_seconds FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id WHERE os.orch_finished_at IS NOT NULL |
| orchestration_session_duration | duration_seconds | /console/info-schema/view.sql?name=orchestration_session_duration&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | [orchestration_session_duration (view) Schema](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes) | /console/content/view/orchestration_session_duration.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_duration.sql?stats=yes) | [orchestration_session_duration (view) Content](console/content/view/orchestration_session_duration.sql?stats=yes) | CREATE VIEW orchestration_session_duration AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, os.orch_started_at, os.orch_finished_at, (JULIANDAY(os.orch_finished_at) - JULIANDAY(os.orch_started_at)) * 24 * 60 * 60 AS duration_seconds FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id WHERE os.orch_finished_at IS NOT NULL | |
| orchestration_success_rate | orchestration_nature | TEXT | /console/info-schema/view.sql?name=orchestration_success_rate&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | [orchestration_success_rate (view) Schema](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | /console/content/view/orchestration_success_rate.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_success_rate.sql?stats=yes) | [orchestration_success_rate (view) Content](console/content/view/orchestration_success_rate.sql?stats=yes) | CREATE VIEW orchestration_success_rate AS SELECT onature.nature AS orchestration_nature, COUNT(*) AS total_sessions, SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS successful_sessions, (CAST(SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_state oss ON os.orchestration_session_id = oss.session_id WHERE oss.to_state IN ('surveilr_orch_completed', 'surveilr_orch_failed') -- Consider other terminal states if applicable GROUP BY onature.nature |
| orchestration_success_rate | total_sessions | /console/info-schema/view.sql?name=orchestration_success_rate&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | [orchestration_success_rate (view) Schema](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | /console/content/view/orchestration_success_rate.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_success_rate.sql?stats=yes) | [orchestration_success_rate (view) Content](console/content/view/orchestration_success_rate.sql?stats=yes) | CREATE VIEW orchestration_success_rate AS SELECT onature.nature AS orchestration_nature, COUNT(*) AS total_sessions, SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS successful_sessions, (CAST(SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_state oss ON os.orchestration_session_id = oss.session_id WHERE oss.to_state IN ('surveilr_orch_completed', 'surveilr_orch_failed') -- Consider other terminal states if applicable GROUP BY onature.nature | |
| orchestration_success_rate | successful_sessions | /console/info-schema/view.sql?name=orchestration_success_rate&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | [orchestration_success_rate (view) Schema](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | /console/content/view/orchestration_success_rate.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_success_rate.sql?stats=yes) | [orchestration_success_rate (view) Content](console/content/view/orchestration_success_rate.sql?stats=yes) | CREATE VIEW orchestration_success_rate AS SELECT onature.nature AS orchestration_nature, COUNT(*) AS total_sessions, SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS successful_sessions, (CAST(SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_state oss ON os.orchestration_session_id = oss.session_id WHERE oss.to_state IN ('surveilr_orch_completed', 'surveilr_orch_failed') -- Consider other terminal states if applicable GROUP BY onature.nature | |
| orchestration_success_rate | success_rate | /console/info-schema/view.sql?name=orchestration_success_rate&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | [orchestration_success_rate (view) Schema](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes) | /console/content/view/orchestration_success_rate.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_success_rate.sql?stats=yes) | [orchestration_success_rate (view) Content](console/content/view/orchestration_success_rate.sql?stats=yes) | CREATE VIEW orchestration_success_rate AS SELECT onature.nature AS orchestration_nature, COUNT(*) AS total_sessions, SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS successful_sessions, (CAST(SUM(CASE WHEN oss.to_state = 'surveilr_orch_completed' THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_state oss ON os.orchestration_session_id = oss.session_id WHERE oss.to_state IN ('surveilr_orch_completed', 'surveilr_orch_failed') -- Consider other terminal states if applicable GROUP BY onature.nature | |
| orchestration_session_script | orchestration_session_id | VARCHAR | /console/info-schema/view.sql?name=orchestration_session_script&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_script&stats=yes) | [orchestration_session_script (view) Schema](console/info-schema/view.sql?name=orchestration_session_script&stats=yes) | /console/content/view/orchestration_session_script.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_script.sql?stats=yes) | [orchestration_session_script (view) Content](console/content/view/orchestration_session_script.sql?stats=yes) | CREATE VIEW orchestration_session_script AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, COUNT(*) AS script_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_entry ose ON os.orchestration_session_id = ose.session_id GROUP BY os.orchestration_session_id, onature.nature |
| orchestration_session_script | orchestration_nature | TEXT | /console/info-schema/view.sql?name=orchestration_session_script&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_script&stats=yes) | [orchestration_session_script (view) Schema](console/info-schema/view.sql?name=orchestration_session_script&stats=yes) | /console/content/view/orchestration_session_script.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_script.sql?stats=yes) | [orchestration_session_script (view) Content](console/content/view/orchestration_session_script.sql?stats=yes) | CREATE VIEW orchestration_session_script AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, COUNT(*) AS script_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_entry ose ON os.orchestration_session_id = ose.session_id GROUP BY os.orchestration_session_id, onature.nature |
| orchestration_session_script | script_count | /console/info-schema/view.sql?name=orchestration_session_script&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_script&stats=yes) | [orchestration_session_script (view) Schema](console/info-schema/view.sql?name=orchestration_session_script&stats=yes) | /console/content/view/orchestration_session_script.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_script.sql?stats=yes) | [orchestration_session_script (view) Content](console/content/view/orchestration_session_script.sql?stats=yes) | CREATE VIEW orchestration_session_script AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, COUNT(*) AS script_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_entry ose ON os.orchestration_session_id = ose.session_id GROUP BY os.orchestration_session_id, onature.nature | |
| orchestration_executions_by_type | exec_nature | TEXT | /console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes) | [orchestration_executions_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes) | /console/content/view/orchestration_executions_by_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_executions_by_type.sql?stats=yes) | [orchestration_executions_by_type (view) Content](console/content/view/orchestration_executions_by_type.sql?stats=yes) | CREATE VIEW orchestration_executions_by_type AS SELECT exec_nature, COUNT(*) AS execution_count FROM orchestration_session_exec GROUP BY exec_nature |
| orchestration_executions_by_type | execution_count | /console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes) | [orchestration_executions_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes) | /console/content/view/orchestration_executions_by_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_executions_by_type.sql?stats=yes) | [orchestration_executions_by_type (view) Content](console/content/view/orchestration_executions_by_type.sql?stats=yes) | CREATE VIEW orchestration_executions_by_type AS SELECT exec_nature, COUNT(*) AS execution_count FROM orchestration_session_exec GROUP BY exec_nature | |
| orchestration_execution_success_rate_by_type | exec_nature | TEXT | /console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | [orchestration_execution_success_rate_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | /console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | [orchestration_execution_success_rate_by_type (view) Content](console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | CREATE VIEW orchestration_execution_success_rate_by_type AS SELECT exec_nature, COUNT(*) AS total_executions, SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS successful_executions, (CAST(SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session_exec GROUP BY exec_nature |
| orchestration_execution_success_rate_by_type | total_executions | /console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | [orchestration_execution_success_rate_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | /console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | [orchestration_execution_success_rate_by_type (view) Content](console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | CREATE VIEW orchestration_execution_success_rate_by_type AS SELECT exec_nature, COUNT(*) AS total_executions, SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS successful_executions, (CAST(SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session_exec GROUP BY exec_nature | |
| orchestration_execution_success_rate_by_type | successful_executions | /console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | [orchestration_execution_success_rate_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | /console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | [orchestration_execution_success_rate_by_type (view) Content](console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | CREATE VIEW orchestration_execution_success_rate_by_type AS SELECT exec_nature, COUNT(*) AS total_executions, SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS successful_executions, (CAST(SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session_exec GROUP BY exec_nature | |
| orchestration_execution_success_rate_by_type | success_rate | /console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | [orchestration_execution_success_rate_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes) | /console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | [orchestration_execution_success_rate_by_type (view) Content](console/content/view/orchestration_execution_success_rate_by_type.sql?stats=yes) | CREATE VIEW orchestration_execution_success_rate_by_type AS SELECT exec_nature, COUNT(*) AS total_executions, SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS successful_executions, (CAST(SUM(CASE WHEN exec_status = 0 THEN 1 ELSE 0 END) AS FLOAT) / COUNT(*)) * 100 AS success_rate FROM orchestration_session_exec GROUP BY exec_nature | |
| orchestration_session_summary | issue_type | TEXT | /console/info-schema/view.sql?name=orchestration_session_summary&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_summary&stats=yes) | [orchestration_session_summary (view) Schema](console/info-schema/view.sql?name=orchestration_session_summary&stats=yes) | /console/content/view/orchestration_session_summary.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_summary.sql?stats=yes) | [orchestration_session_summary (view) Content](console/content/view/orchestration_session_summary.sql?stats=yes) | CREATE VIEW orchestration_session_summary AS SELECT issue_type, COUNT(*) AS issue_count FROM orchestration_session_issue GROUP BY issue_type |
| orchestration_session_summary | issue_count | /console/info-schema/view.sql?name=orchestration_session_summary&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_session_summary&stats=yes) | [orchestration_session_summary (view) Schema](console/info-schema/view.sql?name=orchestration_session_summary&stats=yes) | /console/content/view/orchestration_session_summary.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_summary.sql?stats=yes) | [orchestration_session_summary (view) Content](console/content/view/orchestration_session_summary.sql?stats=yes) | CREATE VIEW orchestration_session_summary AS SELECT issue_type, COUNT(*) AS issue_count FROM orchestration_session_issue GROUP BY issue_type | |
| orchestration_issue_remediation | orchestration_session_issue_id | UUID | /console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | [orchestration_issue_remediation (view) Schema](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | /console/content/view/orchestration_issue_remediation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_issue_remediation.sql?stats=yes) | [orchestration_issue_remediation (view) Content](console/content/view/orchestration_issue_remediation.sql?stats=yes) | CREATE VIEW orchestration_issue_remediation AS SELECT orchestration_session_issue_id, issue_type, issue_message, remediation FROM orchestration_session_issue WHERE remediation IS NOT NULL |
| orchestration_issue_remediation | issue_type | TEXT | /console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | [orchestration_issue_remediation (view) Schema](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | /console/content/view/orchestration_issue_remediation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_issue_remediation.sql?stats=yes) | [orchestration_issue_remediation (view) Content](console/content/view/orchestration_issue_remediation.sql?stats=yes) | CREATE VIEW orchestration_issue_remediation AS SELECT orchestration_session_issue_id, issue_type, issue_message, remediation FROM orchestration_session_issue WHERE remediation IS NOT NULL |
| orchestration_issue_remediation | issue_message | TEXT | /console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | [orchestration_issue_remediation (view) Schema](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | /console/content/view/orchestration_issue_remediation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_issue_remediation.sql?stats=yes) | [orchestration_issue_remediation (view) Content](console/content/view/orchestration_issue_remediation.sql?stats=yes) | CREATE VIEW orchestration_issue_remediation AS SELECT orchestration_session_issue_id, issue_type, issue_message, remediation FROM orchestration_session_issue WHERE remediation IS NOT NULL |
| orchestration_issue_remediation | remediation | TEXT | /console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | [orchestration_issue_remediation (view) Schema](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes) | /console/content/view/orchestration_issue_remediation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_issue_remediation.sql?stats=yes) | [orchestration_issue_remediation (view) Content](console/content/view/orchestration_issue_remediation.sql?stats=yes) | CREATE VIEW orchestration_issue_remediation AS SELECT orchestration_session_issue_id, issue_type, issue_message, remediation FROM orchestration_session_issue WHERE remediation IS NOT NULL |
| orchestration_logs_by_session | orchestration_session_id | VARCHAR | /console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | [orchestration_logs_by_session (view) Schema](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | /console/content/view/orchestration_logs_by_session.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_logs_by_session.sql?stats=yes) | [orchestration_logs_by_session (view) Content](console/content/view/orchestration_logs_by_session.sql?stats=yes) | CREATE VIEW orchestration_logs_by_session AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, osl.category, COUNT(*) AS log_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_exec ose ON os.orchestration_session_id = ose.session_id JOIN orchestration_session_log osl ON ose.orchestration_session_exec_id = osl.parent_exec_id GROUP BY os.orchestration_session_id, onature.nature, osl.category |
| orchestration_logs_by_session | orchestration_nature | TEXT | /console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | [orchestration_logs_by_session (view) Schema](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | /console/content/view/orchestration_logs_by_session.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_logs_by_session.sql?stats=yes) | [orchestration_logs_by_session (view) Content](console/content/view/orchestration_logs_by_session.sql?stats=yes) | CREATE VIEW orchestration_logs_by_session AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, osl.category, COUNT(*) AS log_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_exec ose ON os.orchestration_session_id = ose.session_id JOIN orchestration_session_log osl ON ose.orchestration_session_exec_id = osl.parent_exec_id GROUP BY os.orchestration_session_id, onature.nature, osl.category |
| orchestration_logs_by_session | category | TEXT | /console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | [orchestration_logs_by_session (view) Schema](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | /console/content/view/orchestration_logs_by_session.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_logs_by_session.sql?stats=yes) | [orchestration_logs_by_session (view) Content](console/content/view/orchestration_logs_by_session.sql?stats=yes) | CREATE VIEW orchestration_logs_by_session AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, osl.category, COUNT(*) AS log_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_exec ose ON os.orchestration_session_id = ose.session_id JOIN orchestration_session_log osl ON ose.orchestration_session_exec_id = osl.parent_exec_id GROUP BY os.orchestration_session_id, onature.nature, osl.category |
| orchestration_logs_by_session | log_count | /console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes | [Content](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | [orchestration_logs_by_session (view) Schema](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes) | /console/content/view/orchestration_logs_by_session.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/orchestration_logs_by_session.sql?stats=yes) | [orchestration_logs_by_session (view) Content](console/content/view/orchestration_logs_by_session.sql?stats=yes) | CREATE VIEW orchestration_logs_by_session AS SELECT os.orchestration_session_id, onature.nature AS orchestration_nature, osl.category, COUNT(*) AS log_count FROM orchestration_session os JOIN orchestration_nature onature ON os.orchestration_nature_id = onature.orchestration_nature_id JOIN orchestration_session_exec ose ON os.orchestration_session_id = ose.session_id JOIN orchestration_session_log osl ON ose.orchestration_session_exec_id = osl.parent_exec_id GROUP BY os.orchestration_session_id, onature.nature, osl.category |
Previous (Page 6 of 6)