cluster('engsrvprod.kusto.windows.net').database('engineeringdata').AzureDevOpsTests
//| where TestName has 'ConnectWithRevocation_WithCallback'
| where TestName startswith "System.Net"
and Outcome == 'Failed' or Outcome == 'PassedOnRerun'
| extend i = indexof_regex(TestName, @"[^.]+$")
| extend Method = substring(TestName, i)
| extend Type = substring(TestName, 0, i - 1)
| project-away i, TestName
| where Method has 'Listener_BacklogLimitRefusesConnection_ParallelClients_ClientThrows_Slow'
//| where Arguments == 'protocol: Ssl3'
| distinct JobId, WorkItemId, Message, StackTrace, Method, Type, Arguments, Outcome
| join kind=inner (cluster('engsrvprod.kusto.windows.net').database('engineeringdata').Jobs
| where Finished > now(-14d)
| extend TargetBranch = extractjson("$.['System.PullRequest.TargetBranch']", Properties)
| where (Branch == 'refs/heads/main') //or (Source startswith "pr/" and TargetBranch == 'main')
| where Type startswith "test/functional/cli/" and not(Properties contains "runtime-staging")
| summarize arg_max(Finished, Properties, Type, Branch, Source, Started, QueueName, Attempt, Build, TargetBranch) by JobId
| project-rename JobType = Type) on JobId
| extend PropertiesJson = parse_json(Properties)
| extend OS = replace_regex(tostring(PropertiesJson.operatingSystem), @'\((.*)\).*|([^\(].*)', @'\1\2')
| extend Runtime = iif(PropertiesJson.runtimeFlavor == "mono", "Mono", iif(PropertiesJson.DefinitionName contains "coreclr", "CoreCLR", ""))
| extend Architecture = PropertiesJson.architecture
| extend DefinitionName = PropertiesJson.DefinitionName
| project-away JobId
| extend JobId = extractjson("$.['System.JobId']", Properties)
//| where JobId == '913fd104-6683-4129-8fd6-02f22466d821'
//| where Architecture == 'arm64'
//| where QueueName == 'windows.amd64.server2022.open.svc'
//| where TargetBranch == 'release/6.0'
| join kind=inner (cluster('engsrvprod.kusto.windows.net').database('engineeringdata').WorkItems
| project-keep ConsoleUri, WorkItemId) on WorkItemId
| project-away PropertiesJson
| project-reorder Started, Type, Method, Arguments, StackTrace, ConsoleUri, OS, Architecture, DefinitionName, Branch, TargetBranch, Attempt, Build, *
;
e.g. https://helixre8s23ayyeko0k025g8.blob.core.windows.net/dotnet-runtime-refs-heads-main-96bd05a3f91a4661b1/System.Net.Quic.Functional.Tests/3/console.60e17a73.log?helixlogtype=result
Outerloop test. There are about 180 failures in last 2 weeks (as of 28-02-2023)
Kusto query