The Login Was Successful But The Risk Was High
The sign-in succeeded. The password was correct. MFA was satisfied. The user reached Microsoft 365.
On the surface, everything looked normal.
But Entra ID had already marked the sign-in as high risk. Successful did not mean safe.
Briefing summary
A Microsoft 365 login appeared legitimate because it succeeded, but Entra ID risk signals showed the session was not as safe as it looked.
What happened
The KQL that changed everything
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
SigninLogs | where TimeGenerated > ago(30d) | where ResultType == 0 | where RiskLevelDuringSignIn in~ ("medium", "high") | extend User = tostring(UserPrincipalName), App = tostring(AppDisplayName), City = tostring(LocationDetails.city), Country = tostring(LocationDetails.countryOrRegion) | project TimeGenerated, User, App, IPAddress, City, Country, ConditionalAccessStatus, RiskLevelDuringSignIn, RiskState, RiskDetail | order by TimeGenerated desc
Agent Foskett moment
This is where strong identity and access governance matters.
What most environments miss
Related investigations
Final thought
Identity risk is one of the clearest places where Microsoft telemetry can tell the story before the incident becomes obvious. Start with Identity and Access, strengthen Endpoint Security visibility, and build the investigation skill with the KQL Threat Hunting Guide.
Develop IT. Protect IT. GEMXIT PTY LTD | GEMXIT UK LTD