Intune - Get Users/Devices that have specific software

%3CLINGO-SUB%20id%3D%22lingo-sub-1513842%22%20slang%3D%22en-US%22%3EIntune%20-%20Get%20Users%2FDevices%20that%20have%20specific%20software%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513842%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20all%2C%3C%2FP%3E%3CP%3Elooking%20to%20get%20a%20list%20or%20users%20OR%20devices%20that%20have%20a%20specific%20software.%20i%20see%20that%20there%20is%20a%20discovered%20apps%20section%20in%20Intune%2C%20but%20that%20can%20only%20be%20viewed%20once%20you%20have%20selected%20the%20device.%20was%20looking%20at%20different%20methods%20(even%20graph%20API)%2C%20and%20no%20luck.%3C%2FP%3E%3CP%3EHas%20anyone%20have%20any%20suggestions%20or%20was%20able%20to%20achieve%20this%20(whether%20its%20a%20direct%20method%20or%20having%20to%20manipulate%20outputted%20csvs%2C%20etc.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eat%20a%20loss%20here%2C%20but%20need%20this%20asap..been%20trying%20all%20day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20all%20devices%20are%20AAD%20enrolled%2C%20(not%20joined%20to%20a%20domain)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1513842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntune%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESoftware%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515948%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20-%20Get%20Users%2FDevices%20that%20have%20specific%20software%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515948%22%20slang%3D%22en-US%22%3EHi%20Adrian%2C%3CBR%20%2F%3E%3CBR%20%2F%3EUse%20PowerBI%20OData%20Feed%20to%20Intune%20in%20order%20to%20pull%20and%20customize%20reports%20you%20want.%3CBR%20%2F%3E%3CBR%20%2F%3ECheck%20it%20out%2C%20you%20should%20be%20able%20to%20pull%20all%20discovered%20apps%20with%20nice%20looking%20report!%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps!%3CBR%20%2F%3EMoe%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmem%2Fintune%2Fdeveloper%2Freports-proc-create-with-odata%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmem%2Fintune%2Fdeveloper%2Freports-proc-create-with-odata%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564090%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20-%20Get%20Users%2FDevices%20that%20have%20specific%20software%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F503735%22%20target%3D%22_blank%22%3E%40Moe_Kinani%3C%2FA%3E%26nbsp%3BCouldn't%20see%20anything%20for%20DiscoveredApps.%20the%20options%20available%20looks%20like%20the%20same%20data%20you%20can%20pull%20from%20Intune%20reporting%20in%20the%20admin%20center.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564224%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20-%20Get%20Users%2FDevices%20that%20have%20specific%20software%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564224%22%20slang%3D%22en-US%22%3EDo%20you%20PowerBI%20Desktop%20to%20pull%20the%20tables%3F%20Or%20just%20out%20of%20box%20reports%20template.%3CBR%20%2F%3EI%20recommend%20using%20PowerBI%20Desktop%20to%20customize%20your%20own%20reports%2C%20for%20example%2C%20who%20has%20App%20X%20installed%20in%20their%20PC.%20Many%20other%20reports%20that%20can%20help%20you%20read%20the%20data%20easier%20than%20looking%20at%20Admin%20Center.%3CBR%20%2F%3E%3CBR%20%2F%3EMoe%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564527%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20-%20Get%20Users%2FDevices%20that%20have%20specific%20software%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F503735%22%20target%3D%22_blank%22%3E%40Moe_Kinani%3C%2FA%3E%26nbsp%3BHi%2C%20I'm%20using%20PowerBI%20Desktop.%20From%20the%20link%20above%20I%20entered%20the%20data%20source%20from%20my%20tenancy%20and%20selected%20several%20options%20(queries)%20from%20the%20list.%20a%20bit%20of%20a%20noob%20so%20couldn't%20find%20a%20'custom'%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1608879%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20-%20Get%20Users%2FDevices%20that%20have%20specific%20software%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608879%22%20slang%3D%22en-US%22%3E%3CP%3E%40ny%20further%20info%20on%20this%3F%20i%20am%20using%20the%20link%20as%20a%20guide...but%20no%20'DiscoveredApps'%20table%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

hi all,

looking to get a list or users OR devices that have a specific software. i see that there is a discovered apps section in Intune, but that can only be viewed once you have selected the device. was looking at different methods (even graph API), and no luck.

Has anyone have any suggestions or was able to achieve this (whether its a direct method or having to manipulate outputted csvs, etc.)

 

at a loss here, but need this asap..been trying all day

 

also looked at running Get-Package or Get-CimInstance  to get the info but was unsure on how to return a value/code to intune to determine a success/failure

 

Note: all devices are AAD enrolled, (not joined to a domain)

5 Replies
Highlighted
Hi Adrian,

Use PowerBI OData Feed to Intune in order to pull and customize reports you want.

Check it out, you should be able to pull all discovered apps with nice looking report!

Hope this helps!
Moe

https://docs.microsoft.com/en-us/mem/intune/developer/reports-proc-create-with-odata
Highlighted

@Moe_Kinani Couldn't see anything for DiscoveredApps. the options available looks like the same data you can pull from Intune reporting in the admin center.

Highlighted
Do you PowerBI Desktop to pull the tables? Or just out of box reports template.
I recommend using PowerBI Desktop to customize your own reports, for example, who has App X installed in their PC. Many other reports that can help you read the data easier than looking at Admin Center.

Moe
Highlighted

@Moe_Kinani Hi, I'm using PowerBI Desktop. From the link above I entered the data source from my tenancy and selected several options (queries) from the list. a bit of a noob so couldn't find a 'custom' section.

 

Highlighted

@ny further info on this? i am using the link as a guide...but no 'DiscoveredApps' table?