Dec 01 2022 02:24 PM
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 and then get Ownership, Last Check-in, and Primary User UPN from Intune. I've pulled the data from each into Excel but I don't see a common field I can reference. Started to think about PowerShell or PowerBI but a bit lost about those possibilities.
TIA
~DGM~
Dec 01 2022 07:01 PM
Dec 02 2022 06:12 AM
@@Moe_Kinani - That's sort of where I landed but I have little experience with PowerBI. Any references for this approach?
Dec 03 2022 11:00 AM
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
Dec 08 2022 08:45 AM
@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:
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!
Dec 08 2022 10:14 AM