console_information_schema_view (view) Content
| 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)