.show operations command
Applies to: ✅ Azure Data Explorer
Kusto maintains an internal log of running and historic operations that it processes, such as ingestion operations and data management operations.
Entries are appended to the log when operations start and change their state, including when operations reach their terminal state.
Users can view the ongoing and past operations they started by using the .show operations command.
Database administrators can view all operations that apply to the databases they administer.
Users can also view the results of an operation by using the .show operation details
command. Normally, the results are returned as part of .show operations command itself. For asynchronous
management commands, the .show operation details command is the only way to view the command's results.
Syntax
.show operations [ OperationId ]
.show operations ( OperationId [, ... ] )
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| OperationId | guid |
The operation ID for which to show details. |
Returns
When an operation ID is omitted, the command returns a table displaying all administrative operations executed in the last two weeks, whether ongoing or completed. It includes entries accessible to the user, with multiple records possible for a single operation. Only one record indicates the terminal state of 'Completed' or 'Failed.' This mode is for checking the history of operations, but note that records may take time to appear in the historic log.
When one or more operation IDs are provided, the command returns the latest update for each ID, given the user's access and the record being less than 6 hours old. This mode helps quickly check the latest status of recently executed operations.
The output table contains the following information:
| Output parameter | Type | Description |
|---|---|---|
| OperationId | string |
Operation Identifier |
| Operation | string |
Admin command alias |
| NodeId | string |
If the command has a remote execution (for example, DataIngestPull) - NodeId will contain the ID of the executing remote node |
| StartedOn | datetime |
Date/time (in UTC) when the operation started |
| LastUpdatedOn | datetime |
Date/time (in UTC) when the operation last updated (can be either a step inside the operation, or a completion step) |
| Duration | datetime |
TimeSpan between LastUpdateOn and StartedOn |
| State | string |
Command state, as listed in the State table |
| Status | string |
Additional help string that contains errors of failed operations |
State table
The following table describes the possible values for the result table's State column:
| Value | Description |
|---|---|
| InProgress | The operation is still running |
| Completed | The operation completed (successfully) |
| Failed | The operation completed (unsuccessfully) |
| PartiallySucceeded | The operation completed (parts of it successfully and part of it not) |
| Abandoned | The operation was abandoned before completion |
| BadInput | The operation didn't start executing as there was bad input |
| Scheduled | The operation is scheduled for execution |
| Throttled | The operation has been aborted due to throttling |
| Canceled | The operation has been canceled by the user |
| Skipped | The operation was skipped (due to some logical condition provided as the operation input) |
Example
.show operations
| ID | Operation | Node ID | Started On | Last Updated On | Duration | State | Status |
|---|---|---|---|---|---|---|---|
| 3827def6-0773-4f2a-859e-c02cf395deaf | SchemaShow | 2015-01-06 08:47:01.0000000 | 2015-01-06 08:47:01.0000000 | 0001-01-01 00:00:00.0000000 | Completed | ||
| 841fafa4-076a-4cba-9300-4836da0d9c75 | DataIngestPull | Kusto.Azure.Svc_IN_1 | 2015-01-06 08:47:02.0000000 | 2015-01-06 08:48:19.0000000 | 0001-01-01 00:01:17.0000000 | Completed | |
| e198c519-5263-4629-a158-8d68f7a1022f | OperationsShow | 2015-01-06 08:47:18.0000000 | 2015-01-06 08:47:18.0000000 | 0001-01-01 00:00:00.0000000 | Completed | ||
| a9f287a1-f3e6-4154-ad18-b86438da0929 | ExtentsDrop | 2015-01-11 08:41:01.0000000 | 0001-01-01 00:00:00.0000000 | 0001-01-01 00:00:00.0000000 | InProgress | ||
| 9edb3ecc-f4b4-4738-87e1-648eed2bd998 | DataIngestPull | 2015-01-10 14:57:41.0000000 | 2015-01-10 14:57:41.0000000 | 0001-01-01 00:00:00.0000000 | Failed | Collection was modified. Enumeration operation may not execute. |