你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
.show commands-and-queries command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
.show commands-and-queries returns a table with admin commands and queries on the cluster that have reached a final state. These commands and queries are available for 30 days.
.show commands-and-queries returns a table with admin commands and queries on the eventhouse that have reached a final state. These commands and queries are available for 30 days.
The information presented in the output of the command is similar to .show commands
and .show queries, however it essentially lets you join both result sets in a simple manner.
Syntax
.show commands-and-queries
Returns
Returns a table containing previously run admin commands and queries across all databases in the cluster and their completion statistics. You can use KQL queries to explore the results.
Returns a table containing previously run admin commands and queries across all databases in the eventhouse and their completion statistics. You can use KQL queries to explore the results.
The output schema is as follows:
| ColumnName | ColumnType |
|---|---|
| ClientActivityId | string |
| CommandType | string |
| Text | string |
| Database | string |
| StartedOn | datetime |
| LastUpdatedOn | datetime |
| Duration | timespan |
| State | string |
| FailureReason | string |
| RootActivityId | guid |
| User | string |
| Application | string |
| Principal | string |
| ClientRequestProperties | dynamic |
| TotalCpu | timespan |
| MemoryPeak | long |
| CacheStatistics | dynamic |
| ScannedExtentsStatistics | dynamic |
| ResultSetStatistics | dynamic |
| WorkloadGroup | string |
Note
For queries, the value of CommandType is Query.