Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,645 questions
get count of resultCode by each resultcode in application insight
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 71%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Raymon van Tunen
6
Reputation points
I am playing with application insights to get a usable report. I have come pretty far but one thing that I can’t get to work is a column for each result code that shows a count of said resultcode.
For instance:
url resultcode 200 resultcode 404
http:request 30 1
can someone help me with this?
Azure Monitor
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT 18,996 Reputation points Moderator2021-05-12T10:50:26.757+00:00 @Raymon van Tunen Welcome to Microsoft Q & A Community Forum. Based on the information, I could infer that you were trying to collate all the url based on result code. Kindly try below kusto query and see if it fits your requirement.
requests | where timestamp > ago(7d) | summarize count() by url , resultCode
If I misunderstood your requirement, kindly elaborate it so that I can advise accordingly.
-
SwathiDhanwada-MSFT 18,996 Reputation points Moderator
2021-05-17T09:25:25.21+00:00 @Raymon van Tunen Did you get chance to check my previous comment? Kindly revert if you have any questions.
-
Raymon van Tunen 6 Reputation points
2021-05-17T11:22:26.537+00:00 hello, you misunderstood but i made a work around be creating a second querry. I dont want to summaries by result code but i want to see how manny requests there are with x resultcoce.
for example:
url resultCode 200 result code 401 result code 402
www.test1.nl 3 1 12
www.test2.nl 20 3 1 -
SwathiDhanwada-MSFT 18,996 Reputation points Moderator
2021-05-18T06:30:43.937+00:00 @Raymon van Tunen Glad to know the issue is resolved. If possible, can you please share your kusto query here so that it would be beneficial for the community?
Sign in to comment
Sign in to answer