User Profile
JulianGonzalez
Microsoft
Joined 6 years ago
User Widgets
Recent Discussions
Re: Failed Sign-in queries not working
Hi mvanhorenbeeck, I couldn't find which query in which dashboard this query was associated with. I clicked through all of the queries on the AD dashboard and didn't see this query in any of them. Do you mind giving me more information so I can find it? Also, the query you showed is looking for error codes that do not appear in the list. (!in) I couldn't find any problems with the query but let me know if I am missing something. In the query you showed, the "ErrorCode" column is an extended column displaying a dynamic data type derived from an integer data type ("errorCode"). Both columns are referring to the same data, just displayed differently. I put a query below to demonstrate the difference. I am not sure if this sheds light on this situation, so let me know if this doesn't address your concern. SigninLogs | where TimeGenerated >= ago(365d) | extend ErrorCode = Status.errorCode | extend FailureReason = Status.failureReason | evaluate bag_unpack(Status) | project ErrorCode, errorCode, errorString = tostring(errorCode), errorInt = toint(errorCode) | summarize by tostring(ErrorCode), errorCode, errorString, errorInt7.5KViews0likes11Comments