How can we find the root request from LogAnalytics WorkSpace - AppRequests table?

Shekhar Nadide 186 Reputation points
2024-02-01T08:26:57.3066667+00:00

How can we find the root request from LogAnalytics WorkSpace - AppRequests table Sample Requests : User's image

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,688 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalla-MSFT 9,836 Reputation points
    2024-02-05T01:06:42.81+00:00

    @Shekhar Nadide - Welcome to Microsoft Q&A and thanks for reaching out to us. To find the root request from the Log Analytics Workspace - AppRequests table, you can use the operation_Id and ParentId fields. The operation_Id field is a unique identifier for the operation, and the ParentId field is the identifier of the parent operation. The root request is the request that has no parent operation. Here is an example query that you can use to find the root request:

    AppRequests
    | where ParentId == ""
    

    This query will return all the requests that have no parent operation, which are the root requests. Hope this helps. and please feel free to reach out if you have any further questions.


    If the above response was helpful, please feel free to "Accept as Answer" and click "Yes" so it can be beneficial to the community.


0 additional answers

Sort by: Most helpful