Question

Your team runs an ASP.NET Core API instrumented with Application Insights. Support reports that certain checkout requests fail intermittently, but the front-end only logs a generic 500 error. You need a KQL query in Log Analytics that returns each failed checkout request together with the specific exception thrown during that same request execution, so you can identify the root-cause exception type per failing operation. Which query correctly correlates the two telemetry types?

Accepted Answer

requests | where success == false and name contains "checkout" | join kind=inner (exceptions) on operation_Id | project timestamp, name, resultCode, type, outerMessage

Answer

requests | where success == false and name contains "checkout" | union exceptions | project timestamp, name, resultCode, type

Answer

exceptions | where type contains "checkout" | join kind=leftouter (requests) on session_Id | project timestamp, type, resultCode

Answer

requests | where success == false and name contains "checkout" | lookup exceptions on itemId | project timestamp, name, type