Hoping someone can help - been pulling my hair out on this for the last few weeks. Would anyone have a handy PS script which would identify which users are using the iOS / Android Outlook App.
We have a tenant with approx. 40,000 users in, some F1, E1 and E3 - As we're a enterprise I need a way of identifying users who are on a F1 or E1 licence and ask them to remove as F1 / E1 licence doesn't cover the iOS / Android Outlook app.
I've tried running the Mailbox App report in the portal but it doesn't tell me which licence the user is on or really identify if their using the iOS / Android Outlook app.
The Email app usage report in the portal is a good starting point. If you want the exact device details, you will have to use the PowerShell cmdlets (Get-MobileDevice, Get-MobileDeviceStatistics). As both the iOS/Android Outlook apps use the same method to connect, you should be able to easily filter just those users/devices via:
Get-MobileDevice -RestApi -ResultSize unlimited
Adding the exact license information will require additional runs of the Get-MsolUser/Get-AzureADUser cmdlet or correlating via the report available in the portal.