Query Details
MC847884 Check I OS 16 Mobile Outlook Users Due To Out Of Support In Sep 2024
Query
// MC847884 - Check iOS 16 mobile outlook users due to out of support in Sep 2024 // With iOS 18 releasing in mid September, the minimum supported iOS version would be iOS 17 as over time, Outlook for iOS on iOS 16 devices will eventually stop synchronizing email and calendar data. Do you know how many of your organization users are impacted by this new iOS released ? Use the below KQL to determine the list of impacted users. SigninLogs | where TimeGenerated > ago(90d) | where ResultType == "0" | extend OS = tostring(DeviceDetail.operatingSystem) | where OS contains "Ios 16." | where AppDisplayName == "Outlook Mobile" | distinct UserPrincipalName, OS
Explanation
This KQL (Kusto Query Language) query is designed to identify users in your organization who are using the Outlook Mobile app on iOS 16 devices. These users will be impacted by the upcoming release of iOS 18, as support for iOS 16 will end in September 2024. Here's a simple breakdown of what the query does:
- Data Source: The query pulls data from the
SigninLogstable. - Time Frame: It filters the logs to include only those generated in the last 90 days.
- Successful Logins: It further filters the logs to include only successful sign-ins (
ResultType == "0"). - Operating System: It extracts the operating system information and filters to include only those logs where the OS is iOS 16. 5. Application: It ensures that the application used is "Outlook Mobile".
- Unique Users: Finally, it selects distinct users (identified by
UserPrincipalName) and their operating systems.
The result is a list of users who have successfully signed into Outlook Mobile on iOS 16 devices in the past 90 days. These users will need to upgrade their iOS to continue using Outlook Mobile without issues.
Details
Steven Lim
Released: August 6, 2024
Tables
SigninLogs
Keywords
DevicesUsers
Operators
ago==extendtostringcontainsdistinct