Add Operation Text, Database to .show operations
It would be useful to be able to see all currently running commands similarly to how we can see .show running queries. I have this query which shows me the currently running operations, but it does not have the level of detail that the .show commands query returns:
| where StartedOn > ago(1h)
| sort by LastUpdatedOn desc
| summarize max(LastUpdatedOn), makelist(State) by RootActivityId, Operation
| where listState !contains "Completed" and list_State !contains "Failed"
Specifically, it would be useful to see the database context in which the operation was running as well as the command text associated. The main use case this supports is tracking async commands like .ingest or .set-or-append.