Troubleshooting Instances
Provides a detailed view of command and execution errors at the instance level
Common Dashboards ENABLED
Details
| ID | 0523406bbbae4d0d840a5057e0336880 |
|---|---|
| From Version | 6.10.0 |
Widgets (10)
Command execution errors per integration category
Custom XQL pie
dataset = scripts_and_commands_metrics | filter is_error = true | filter type = "integration" | filter category != null and category != "" | comp count() as error_count by category | sort desc error_count | view graph type = pie xaxis = category yaxis = error_count
Command execution errors per instance
Custom XQL pie
dataset = scripts_and_commands_metrics | filter is_error = true | filter type = "integration" | filter instance != null and instance != "" | comp count() as error_count by instance | sort desc error_count | view graph type = pie xaxis = instance yaxis = error_count
Command execution errors breakdown
Custom XQL pie
dataset = scripts_and_commands_metrics | filter is_error = true | filter name != null and name != "" | comp count() as error_count by name | sort desc error_count | view graph type = pie xaxis = name yaxis = error_count
Command execution errors
Custom XQL single
dataset = scripts_and_commands_metrics | filter is_error = true | bin _time span = 1d | comp count() as error_count by _time | view graph type = single subtype = trend xaxis = _time yaxis = error_count
Manual command execution errors
Custom XQL line
dataset = scripts_and_commands_metrics | filter is_error = true | filter is_manual = true | filter name != null and name != "" | comp count() as error_count by name | sort desc error_count | limit 5 | view graph type = column xaxis = name yaxis = error_count
Errors by issue type per command (Top 5)
Custom XQL column
dataset = scripts_and_commands_metrics | filter is_error = true | filter type = "integration" | filter api_response_type != null | alter command = name | comp count() as total_errors by command, category | sort desc total_errors | limit 5 | view graph type = column subtype = grouped xaxis = category yaxis = total_errors series = command
Failed automation executions (Top 5)
Custom XQL column
dataset = scripts_and_commands_metrics | filter type = "automation" | filter is_error = true | filter name != null and name != "" | comp count() as error_count by name | sort desc error_count | limit 5 | view graph type = column subtype = grouped xaxis = name yaxis = error_count
Average runtime per command by instance (Top 5)
Custom XQL column
dataset = scripts_and_commands_metrics | filter type = "integration" | filter duration != null | filter name != null and instance != null | comp avg(duration) as avg_runtime_secs by name, instance | sort desc avg_runtime_secs | limit 5 | view graph type = column subtype = grouped xaxis = name yaxis = avg_runtime_secs series = instance
Command average runtime per instance (Top 5)
Custom XQL column
dataset = scripts_and_commands_metrics | filter type = "integration" | filter duration != null | filter instance != null and instance != "" | comp avg(duration) as avg_runtime_secs by instance | sort desc avg_runtime_secs | limit 5 | view graph type = column subtype = grouped xaxis = instance yaxis = avg_runtime_secs
Command average runtime per automation (Top 5)
Custom XQL column
dataset = scripts_and_commands_metrics | filter type = "automation" | filter duration != null | filter name != null and name != "" | comp avg(duration) as avg_runtime_secs by name | sort desc avg_runtime_secs | limit 5 | view graph type = column subtype = grouped xaxis = name yaxis = avg_runtime_secs
{ "dashboards_data": [ { "id": "0523406bbbae4d0d840a5057e0336880", "name": "Troubleshooting Instances", "description": "Provides a detailed view of command and execution errors at the instance level", "status": "ENABLED", "layout": [ { "id": "row-7110", "data": [ { "key": "xql", "data": { "type": "Custom XQL", "title": "Command execution errors per integration category", "width": 33.333333333333336, "height": 511, "phrase": "dataset = scripts_and_commands_metrics\n| filter is_error = true\n| filter type = \"integration\"\n| filter category != null and category != \"\"\n| comp count() as error_count by category\n| sort desc error_count\n| view graph type = pie xaxis = category yaxis = error_count ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "pie", "commands": [ { "command": { "op": "=", "name": "xaxis", "value": "category" } }, { "command": { "op": "=", "name": "yaxis", "value": "error_count" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Command execution errors per instance", "width": 33.29688354291963, "height": 511, "phrase": "dataset = scripts_and_commands_metrics \n| filter is_error = true\n| filter type = \"integration\"\n| filter instance != null and instance != \"\"\n| comp count() as error_count by instance\n| sort desc error_count\n| view graph type = pie xaxis = instance yaxis = error_count ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "pie", "commands": [ { "command": { "op": "=", "name": "xaxis", "value": "instance" } }, { "command": { "op": "=", "name": "yaxis", "value": "error_count" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Command execution errors breakdown", "width": 33.406232914160746, "height": 511, "phrase": "dataset = scripts_and_commands_metrics \n| filter is_error = true\n| filter name != null and name != \"\"\n| comp count() as error_count by name\n| sort desc error_count\n| view graph type = pie xaxis = name yaxis = error_count ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "pie", "commands": [ { "command": { "op": "=", "name": "xaxis", "value": "name" } }, { "command": { "op": "=", "name": "yaxis", "value": "error_count" } } ] } } } ] }, { "id": "row-5364", "data": [ { "key": "xql", "data": { "type": "Custom XQL", "title": "Command execution errors", "width": 25, "height": 511, "phrase": "dataset = scripts_and_commands_metrics \n| filter is_error = true\n| bin _time span = 1d\n| comp count() as error_count by _time\n| view graph type = single subtype = trend xaxis = _time yaxis = error_count ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "single", "commands": [ { "command": { "op": "=", "name": "subtype", "value": "trend" } }, { "command": { "op": "=", "name": "xaxis", "value": "_time" } }, { "command": { "op": "=", "name": "yaxis", "value": "error_count" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Manual command execution errors", "width": 25, "height": 511, "phrase": "dataset = scripts_and_commands_metrics \n| filter is_error = true\n| filter is_manual = true\n| filter name != null and name != \"\"\n| comp count() as error_count by name\n| sort desc error_count\n| limit 5\n| view graph type = column xaxis = name yaxis = error_count ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "line", "commands": [ { "command": { "op": "=", "name": "xaxis", "value": "name" } }, { "command": { "op": "=", "name": "yaxis", "value": "error_count" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Errors by issue type per command (Top 5)", "height": 511, "phrase": "dataset = scripts_and_commands_metrics \n| filter is_error = true\n| filter type = \"integration\"\n| filter api_response_type != null\n| alter command = name\n| comp count() as total_errors by command, category \n| sort desc total_errors \n| limit 5\n| view graph type = column subtype = grouped xaxis = category yaxis = total_errors series = command ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "column", "commands": [ { "command": { "op": "=", "name": "subtype", "value": "grouped" } }, { "command": { "op": "=", "name": "xaxis", "value": "category" } }, { "command": { "op": "=", "name": "yaxis", "value": "total_errors" } }, { "command": { "op": "=", "name": "series", "value": "command" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Failed automation executions (Top 5)", "width": 25, "height": 511, "phrase": "dataset = scripts_and_commands_metrics\n| filter type = \"automation\"\n| filter is_error = true\n| filter name != null and name != \"\"\n| comp count() as error_count by name\n| sort desc error_count \n| limit 5\n| view graph type = column subtype = grouped xaxis = name yaxis = error_count ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "column", "commands": [ { "command": { "op": "=", "name": "subtype", "value": "grouped" } }, { "command": { "op": "=", "name": "xaxis", "value": "name" } }, { "command": { "op": "=", "name": "yaxis", "value": "error_count" } } ] } } } ] }, { "id": "row-5656", "data": [ { "key": "xql", "data": { "type": "Custom XQL", "title": "Average runtime per command by instance (Top 5)", "width": 33.333333333333336, "height": 435, "phrase": "dataset = scripts_and_commands_metrics\n| filter type = \"integration\"\n| filter duration != null\n| filter name != null and instance != null\n| comp avg(duration) as avg_runtime_secs by name, instance\n| sort desc avg_runtime_secs\n| limit 5\n| view graph type = column subtype = grouped xaxis = name yaxis = avg_runtime_secs series = instance ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "column", "commands": [ { "command": { "op": "=", "name": "subtype", "value": "grouped" } }, { "command": { "op": "=", "name": "xaxis", "value": "name" } }, { "command": { "op": "=", "name": "yaxis", "value": "avg_runtime_secs" } }, { "command": { "op": "=", "name": "series", "value": "instance" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Command average runtime per instance (Top 5)", "width": 33.333333333333336, "height": 435, "phrase": "dataset = scripts_and_commands_metrics\n| filter type = \"integration\"\n| filter duration != null\n| filter instance != null and instance != \"\"\n| comp avg(duration) as avg_runtime_secs by instance\n| sort desc avg_runtime_secs \n| limit 5\n| view graph type = column subtype = grouped xaxis = instance yaxis = avg_runtime_secs ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "column", "commands": [ { "command": { "op": "=", "name": "subtype", "value": "grouped" } }, { "command": { "op": "=", "name": "xaxis", "value": "instance" } }, { "command": { "op": "=", "name": "yaxis", "value": "avg_runtime_secs" } } ] } } }, { "key": "xql", "data": { "type": "Custom XQL", "title": "Command average runtime per automation (Top 5)", "width": 33.333333333333336, "height": 435, "phrase": "dataset = scripts_and_commands_metrics\n| filter type = \"automation\"\n| filter duration != null\n| filter name != null and name != \"\"\n| comp avg(duration) as avg_runtime_secs by name\n| sort desc avg_runtime_secs \n| limit 5\n| view graph type = column subtype = grouped xaxis = name yaxis = avg_runtime_secs ", "time_frame": { "relativeTime": 604800000 }, "viewOptions": { "type": "column", "commands": [ { "command": { "op": "=", "name": "subtype", "value": "grouped" } }, { "command": { "op": "=", "name": "xaxis", "value": "name" } }, { "command": { "op": "=", "name": "yaxis", "value": "avg_runtime_secs" } } ] } } } ] } ], "default_dashboard_id": 1, "global_id": "0523406bbbae4d0d840a5057e0336880", "metadata": { "params": [] } } ], "widgets_data": [], "fromVersion": "6.10.0" }