Query for Average response time based on a sub set of the Azure Subscription

Stephen Davidson
Occasional Visitor

First time poster and very new to ALA...


I have multiple sites within my Application insights resource and I want to get the Average Response time for each of the app/api's and then use them to create alerts if they go over our target SLA.  


Should I be using 

requests | search "https://nameofsite" to help seperate these and what query do I used to get this data?
Many thanks,
1 Reply

Hi Stephen, welcome aboard :)

First I'd just note it might be easier to manage separate sites over separate Application Insights resources, that would help you monitor each site separately.

To your question, I would suggest to create a runtime field (let's call it "domain" in this example) and then calculate the average duration for each domain. `parse` is a cool command that's meant for this kind of string parsing:

| parse url with "https://" domain "/" *
| summarize avg(duration) by domain

if some of your sites start with "http" and some with "https", the parse pattern should be a bit different:

| parse url with * "://" domain "/" *
| summarize avg(duration) by domain



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies