Forum Discussion

DGMalcolm's avatar
DGMalcolm
Iron Contributor
Dec 01, 2022

Report On Combined Data from Intune & Azure AD

Hey there,   Is there a way to generate a combined report on data from Intune & Azure AD? For instance, I'd like to get a list of all devices along with Join Type, Owner, MDM, and Activity from AAD...
Intune
Moe_Kinani's avatar
Moe_Kinani
Bronze Contributor
Dec 02, 2022
There is no out of box report that combines the two, best to use PowerBI, you may use upn or device name as the relationship.

Moe
  • DGMalcolm's avatar
    DGMalcolm
    Iron Contributor
    Dec 02, 2022

    @Moe_Kinani - That's sort of where I landed but I have little experience with PowerBI. Any references for this approach?

    • Moe_Kinani's avatar
      Moe_Kinani
      Bronze Contributor
      Dec 03, 2022

      Hi DGMalcolm,

       

      Many ways you can do it, the easier is to export the data from Azure AD and Intune, then import to PowerBI as CSV files. After importing - Navigate to Model Tab - Manage Relationship - Select Device name from Azure AD and Device Name from Intune - Many to Many relationships. After that done, navigate Report Tab - Select Table on Visualization - Select Columns from both tables. 

       

      Sorry about the delay in response and hope this helps!

      Moe

      • DGMalcolm's avatar
        DGMalcolm
        Iron Contributor
        Dec 08, 2022

        Moe_KinaniPushing me toward PowerBI was helpful. I got the Intune part quickly, it was the AAD that was harder. Then I found this article:

         

        https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

         

        Using that I was able to get a connection to AAD then, using your recommendations of the relationships, I was able to get some level of integration. It's still a work in progress but thank you!

Resources