How to query my Application Insights Logs (Analytics) from Kusto.Explorer? How to query my Application Insights Logs (Analytics) from Kusto.Explorer? azure azure

How to query my Application Insights Logs (Analytics) from Kusto.Explorer?


We have a private preview for Azure Data Explorer (ADX) Proxy that enables you to treat Log Analytics / Application Insights as a virtual cluster, query it using ADX tools and connecting to it as a second cluster in cross cluster query. Since its a private preview you need to contact adxproxy@microsoft.com in order to get enrolled. The proxy is documented at https://docs.microsoft.com/en-us/azure/data-explorer/query-monitor-data.

(disclaimer - I'm the PM driving this project).


Step 1 Connection String

Build your connection string from this template:

https://ade.applicationinsights.io/subscriptions/<subscription-id>/resourcegroups/<resource-group-name>/providers/microsoft.insights/components/<ai-app-name>

Fill in the subscription-id, resource-group-name, and ai-app-name from the portal. Here is an example image

enter image description here

Step 2 Add the connection to Kusto.Explorer

Open Kusto.Explorer, choose Add Connection, and paste your connection string into the Cluster connection field.

enter image description here

After you kit OK, Windows will prompt you to log in with your Azure Active Directory account. Once you have authenticated, Kusto.Explorer will display the Application Insights tables in the Connections panel.