Correlating device last sign-in activity with compliance status involves comparing the most recent access to Microsoft 365 services with the device’s current compliance state (e.g., compliant, noncompliant, or unknown).
This helps admins identify users accessing Microsoft 365 from non-compliant devices and access device activity and security posture. They can take action to reduce risk, clean up inactive licenses, and enforce Zero Trust policies.
- Log in to the Microsoft Entra admin center.
- Navigate to Entra ID»Devices»All devices.
- Now, you can check the compliance status & last sign-in activity of every user's device along with the details like join type, owner, MDM, security settings management and more.
Connect to the Microsoft Graph PowerShell module with required permissions and run the script below.
$devices = Get-MgDeviceManagementManagedDevice -All
$signIns = Get-MgAuditLogSignIn -All | Where-Object { $_.DeviceDetail.DeviceId }
$latest = $signIns | Sort-Object CreatedDateTime -Descending | Group-Object { $_.DeviceDetail.DeviceId } | ForEach-Object { $_.Group[0] }
$report = foreach ($s in $latest) { $d = $devices | Where-Object { $_.AzureADDeviceId -eq $s.DeviceDetail.DeviceId }
[PSCustomObject]@{ DeviceName = $s.DeviceDetail.DisplayName
LastSignIn = $s.CreatedDateTime
User = $s.UserPrincipalName
Compliance = if ($d) { $d.ComplianceState } else { "Unknown" } }}
$report | Format-Table -AutoSize
This script obtains device name, user name and device’s last sign-in activity with compliance details. It helps you spot risky devices, compliant devices, etc. Also identify who used which device, when, and whether it met your organization’s security standards.
Associate user sign-ins with compliance status using AdminDroid to avoid security risks!
AdminDroid reports unify device compliance, user details, and sign-in activities into a single view that eliminates the need to manually correlate data from multiple sources. This saves time, reduces errors, and provides actionable insights without complex scripting.
- AdminDroid’s compliant devices report allows you to easily map user login activity with the compliance status of their devices.
- With advanced filters, you can quickly spot high-risk scenarios like users signing in from non-compliant or personal devices.
- You can also use advanced customization to group compliant devices by last sign-in date and spot recent activity easily.