Search code examples
databaseazure-devopscluster-analysisazure-data-explorer

how to identify the users using the specific cluster in Kusto explorer

I was trying to take a list on users using the specific cluster in the kusto explorer. I dont know how to do this task. Please help me on this.

Thank you

Solution

  • If you have monitoring permission on the cluster you can use the ".show queries" command to see the activity on the cluster, see more in the docs

    Here is an example:

    .show queries 
| where StartedOn > ago(1d)
| summarize count() by Database, User