Forum Discussion
Solved
Creating report of Discovered Apps by Device
I need to create a report showing all discovered apps by device. I can get a list of discovered apps, and I can see what apps are installed on a device by going to the device profile. But I need an aggregated report combining discovered apps per device. I understand there may be a way to do this via the graph (I am not familiar with creating reports from the graph), or in PowerShell, but I can't find the syntax that would generate the report I am looking for. Any help would be appreciated.
- Thanks Daniel_Lonergan for the nice call. To share with the community what helped daniel I wrote a blog post about it:
https://jannikreinhard.com/2022/11/27/intune-mass-export-with-the-graph-report-api/
- You mentioned PS and Graph, you may need to use PowerBI or Log Analytics instead, you can use odata link intune connector and build your report using PowerBI.
You may need some DAX skills to connect the apps table to Devices table. Good luck with it.
Moe
https://learn.microsoft.com/en-us/mem/intune/developer/reports-proc-get-a-link-powerbi#load-the-data-in-power-bi-using-the-odata-linkHi Moe. Thanks for the tip on using PowerBI. I was able to access the Intune Tables, as you stated. And I was able to bring columns from selected tables into PowerBI.
However, I could not find a table that contains the "Discovered Apps". There were a few mamApplication tables. But these only display apps managed by Intune and not the "unauthorized" ones we are looking to identify. I checked all the tables in case there was a column that held this information. But I could not find it.
The "Discovered Apps" data must be somewhere, since I am able to see these apps when I select an individual device. Where could this data be located if in an Intune Table?
- I think you’re correct, only limited apps show with connector, you need to use Log Analytics to collect the apps and then build your PBI report. Here is great guide that can help you to do it:
Moe
https://jannikreinhard.com/2022/07/01/copy-intune-discovered-apps-in-log-analytics-workspace/
