question

RaymonvanTunen-0689 avatar image
0 Votes"
RaymonvanTunen-0689 asked SwathiDhanwada-MSFT commented

get count of resultCode by each resultcode in application insight

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
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@RaymonvanTunen-0689 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


95959-image.png


If I misunderstood your requirement, kindly elaborate it so that I can advise accordingly.


0 Votes 0 ·
image.png (24.8 KiB)

@RaymonvanTunen-0689 Did you get chance to check my previous comment? Kindly revert if you have any questions.

0 Votes 0 ·

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

1 Vote 1 ·

@RaymonvanTunen-0689 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?

0 Votes 0 ·

0 Answers