Forum Discussion

yesoreyeram's avatar
yesoreyeram
Brass Contributor
Jun 30, 2020
Solved

Azure resource Graph integration

Are there any plans to integrate Azure Resource Graph with Log Analytics? Once the integration is available it will be super easy to setup alerts based on resource meta data and monitor data. Since b...
azure monitor
Log Analytics
  • yesoreyeram's avatar
    yesoreyeram
    Jun 30, 2020

    shijain13 yea. It is possible. But how do you combine results from both the queries. ( join kusto queries / cross workspace queries / etc ). Currently only we can query Log analytics / application insights.

OlegAnaniev's avatar
OlegAnaniev
Icon for Microsoft rankMicrosoft
Jul 09, 2020

yesoreyeram - this is high on our list, but unfortunately, gets pushed away, as more urgent stuff comes in. But we will get there, we understand the need and will address it.

  • AlanH100's avatar
    AlanH100
    Copper Contributor
    Dec 29, 2020

    OlegAnaniev- I would like to join in a Sentinel workbook an ARG 'resources' query with a Log Analytics 'SecurityAlert' query to produce aggregated output like this:

     

    Resource Group          No. of Resources          No. of Alerts

    ------------------         -------------------         --------------

     

    rg_A                                                   50                      1,295

    rg_B                                                  125                          96

     

    Is that possible?  I have tried the Merge query, however have not found a way to imclude aggregate columns.

Resources