none
Query behind availability graph in Azure portal RRS feed

  • Question

  • Most of the App Insights graphs in the Azure portal have a "View in Logs (Analytics)" button, however the the availability graph has not.

    What is the query for this graph?

    


    Hallis

    Tuesday, November 19, 2019 3:56 PM

Answers

  • Hi Hallis,

    There is a table available in Log Analytics called `availabilityResults`. You can use this table to explore the data that underlies this graph.

    So something like this will give you the average availability over each hour:

    availabilityResults
    | summarize Availability=(todouble(count(success==1) * 100)/(todouble(count()))), Duration=avg(duration) by bin(timestamp, 1h)
    

    Friday, November 22, 2019 6:34 PM
    Moderator