0

I am using hockey application to distribute mobile application.

enter image description here

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
Khant Thu Linn
  • 5,905
  • 7
  • 52
  • 120
  • 1
    Are custom properties not stored in the customDimension property of a customEvent? What does `customEvents | project customDimension` tell? – Peter Bons Oct 30 '17 at 08:00
  • 1
    (or more specficially `customEvents | where name starswith "VIEW_MEDIA" | project customDimensions, customMeasurements | limit 10`, which will filter your data down, get *only* custom properties and metrics, and limit to just 10 rows. then you can expand those fields (json) and figure out what else you might need from inside those fields. – John Gardner Oct 30 '17 at 17:54
  • Thanks guys. It is working. – Khant Thu Linn Oct 31 '17 at 01:32

1 Answers1

2

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 ...
EranG
  • 822
  • 4
  • 10