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