Endpoint Manager (Intune), comparing devices

[bunchofkeys]

Is there a way that i can compare devices that have an app installed, compared to the devices that do not?

Although i have a list of all the Windows Devices that has Microsoft Teams installed, i would like to locate the Windows devices that do not.
The list was produced by searching Apps - Monitor - Discovered Apps - Searching for "Microsoft Teams".
I was then able to export the raw data to Excel.

[HappyMidget]

Export all devices, then vlookup between the two

[bunchofkeys]

When you put it like that, it's so obvious

Thank you, I was making it far to complicated.

[HappyMidget]

bunchofkeys said:

When you put it like that, it's so obvious

Thank you, I was making it far to complicated.

This is what I do for a living, consulting on data analysis tasks. They give me the title of Data Engineer and charge me out at a fantastic markup. It helps that I can take the 3rd party view of most problems, and I haven't generally come across a problem that I haven't seen before. You could also possibly automate this using power query/Power Bi. Haven't checked the docs yet if there is an InTune connector for them or whether you can use a REST API to query InTune.