Finding a specific application name in Azure with Kusto

[therealkristaps]

Hello, World!

I am trying to find any related information on how to perform search in Monitor logs in Azure. I need to find a specific application and, also, a specific transaction using Kusto QL. I have tried to Google all over the place, but only stuff I find is related to virtual machines etc.

Anyone has any kind of information that I could use specifically for querying applications etc.

Would really appreciate any provided information.

Thanks.

[#2 · Accepted solution]

@therealkristaps 

I'm not sure if you have setup App Insights - look here: https://docs.microsoft.com/en-us/azure/azure-monitor/app/app-insights-overview

Using the Demo data, you can see many Examples in the Queries blade https://ms.portal.azure.com/#blade/Microsoft_Azure_Monitoring_Logs/DemoLogsBlade

also see: AzureMonitorCommunity/Azure Services/Application Insights at master · microsoft/AzureMonitorCommunit...

If you know the app name, you could search all the Tables for it.   This is a poor query, but will list any tables we find the app called "Home Page" in.  

search "Home Page"
| summarize count() by Type

You can then swap to that Table, and improve the query i.e, assuming the app was found in the above query in the AppPageView table, use:

AppPageViews
| where Name == "Home Page"

[#3]

Thanks Clive. This is enough. :) Thanks a lot for helping out.