View/query custom event in Azure application insights

Question

I am using hockey application to distribute mobile application.

I need to see their additional properties and it say I need to link with azure application insights. I have already done that. Inside there, I also saw my custom event with properties. Problem is that I don't know how to query all my custom event with their payload. How can I write script? One of my event name is called "VIEW_MEDIA".

I have used this query command to get report for VIEW_MEDIA but it doesn't give me their properties.

customEvents | where name startswith "VIEW_MEDIA" | summarize count() by name | render piechart 

Answer 1

When you run the summarize count() by name part, you're basically removing all data from the result except for the event names and their respective count.

If you want the query to summarize by some property, you can run a query similar to this:

customEvents 
| where name starswith "VIEW_MEDIA" 
| extend myProperty = tostring(customDimensions.MyProperty) 
| summarize count() by name, myProperty 
| render ...