'Is it possible to group records by key in Azure Log Query

I am trying to perform a simple query in Azure App Insights which will group a set of results by key. (One to Many)

Example Structure:

-- request

--- request with same InvocationId

--- request with same InvocationId


-- request

--- request with same InvocationId

-- request with same InvocationId

I'm sure this isn't correct, but, I am looking for something like the following

union * |
extend InvocationId=tostring(parse_json(customDimensions).InvocationId)
|
join kind=inner (     
    union * |
    extend InvocationId=tostring(parse_json(customDimensions).InvocationId)) on $left.InvocationId == $right.InvocationId

Thank you!

azureazure-log-analytics


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions