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/
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

      • Jannik_Reinhard's avatar
        Jannik_Reinhard
        Iron Contributor
        Nov 01, 2022
        Hey Daniel_Lonergan, sorry for the late response and for missing the comment under my blog post. How did you execute the script, can you send an screenshot from the execution? Did you run this an an powershell shell because this error message is an sql error and not an powershell error.
        The strange thing is that in the the message the ‘$customerid’ is lowercase but in my script it is always written as camel case.

Resources