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 a...
- 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-link
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-link
Hi 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/- Hi Moe, I followed the steps outlined in the link you provided. However, when I get to the step of running the script. I get an error at line 1
“The name ‘$customerid’ does not refer to any known column, table, variable or function”
I am running it in the “Logs” section of the Log Analytics Workspace I created in the instructions. Any idea why I am getting this error?
FYI, I also posted this question on the blog, but I have not heard back as yet.
