appInsights inner join with request and any other table like pageViews

Open
#102 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
30/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
azure
Domain
observability-sre

Research direction

Start with the provided Azure Monitor query and review how operation_Id is represented across requests and pageViews in the referenced time window. Determine whether the empty inner join reflects expected Application Insights behavior or a recent change, and document the confirmed behavior and guidance for this query.

Written by the indexing model from the issue text.

Description

I am flummoxed by the results of this query always being empty

let requestList = requests | where timestamp >= ago(30m)
| distinct operation_Id;
pageViews  | where timestamp >= ago(30m)
| join kind=inner requestList on operation_Id;

Has there been a change recently in the use of operation_Id ?

Dominant language
PowerShell
Stars
1.2k
Forks
493
No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from microsoft/AzureMonitorCommunity

All issues in microsoft/AzureMonitorCommunity

Similar issues

More Observability & SRE issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.