KQL query for Data Connectors

Copper Contributor

Hi Folks,

Can someone help me with the kql query to find out how many data connectors are connected along with the data connector name.

 

 

 
 
1 Reply
Not sure what you mean by "data connector"....if you want to find out who is connecting to your database by which tool it would be something like:

.show queries
| where StartedOn > ago(3d)
| where User has "@my-company.com"
| extend appname = ClientRequestProperties["Options"]["request_app_name"]
| extend appname = iif(appname=="","some external application - Python Api etc",appname)
| summarize count() by appname

this would return a list:
appname count
Kusto.Explorer 5
some external appliction 16
KusWeb 33
....