Forum Discussion

Daniel_Lonergan's avatar
Daniel_Lonergan
MCT
Oct 24, 2022
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...
discovered apps
graph
Intune
powershell
Report
  • Jannik_Reinhard's avatar
    Jannik_Reinhard
    Nov 27, 2022
    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/
Moe_Kinani's avatar
Moe_Kinani
Bronze Contributor
Oct 25, 2022
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
Daniel_Lonergan's avatar
Daniel_Lonergan
MCT
Oct 25, 2022

Moe_Kinani 

 

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?

  • Moe_Kinani's avatar
    Moe_Kinani
    Bronze Contributor
    Oct 26, 2022
    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/
    • Daniel_Lonergan's avatar
      Daniel_Lonergan
      MCT
      Oct 31, 2022
      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.
      • Moe_Kinani's avatar
        Moe_Kinani
        Bronze Contributor
        Nov 01, 2022

        Hi Daniel_Lonergan,

         

        Have entered the Workplace id for $customerid variable? Going to loop @Jannik Reinhard to this conversation, hope he can clarify the glitch.

         

        Moe

Resources