Use Case for warning analyzing

[Marusyk]

My use case is to analyze build logs of dotnet application and prepare a registry with warnings and their count. Example of expected result:

Warn: CA1062: 870
Warn: CA1002: 412
Warn: CA2227: 302
Warn: CA1305: 257
Warn: CA1707: 216
Warn: CA5394: 171
Warn: CA1307: 115
Warn: CA1860: 113
Warn: CA1725: 88
Warn: CA1851: 83
Warn: IDE1006: 81

Example of the log file:

2024-06-27T10:58:32.4399150Z ##[warning]/src/DatabaseSeeding/DatabaseSeeding/Data/Seeding/SeedTestData.cs(431,22): warning CA1310: The behavior of 'string.StartsWith(string)' could vary based on the current user's locale settings. Replace this call in 'DatabaseSeeding.Data.Seeding.SeedTestData.BuildSequences()' with a call to 'string.StartsWith(string, System.StringComparison)'. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1310)
2024-06-27T10:58:32.4401416Z ##[warning]/src/DatabaseSeeding/DatabaseSeeding/Data/Seeding/SeedTestData.cs(454,37): warning CA5394: Random is an insecure random number generator. Use cryptographically secure random number generators when randomness is required for security. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca5394)

The following code helped me solve the task

Grok grok = new Grok(": warning %{WORD:code}: ");

string logs = await File.ReadAllTextAsync("C:\\Users\\RomanMarusyk\\Desktop\\warn.txt");
var grokResult = grok.Parse(logs)
    .GroupBy(x => x.Value)
    .ToDictionary(x => x.Key, y => y.Count())
    .OrderByDescending(x => x.Value);

foreach (var warrning in grokResult)
{
    Console.WriteLine($"Warn: {warrning.Key}: {warrning.Value}");
}

I've tried PowerShell but it doesn't have grouping grok -p "C:\Users\RomanMarusyk\Desktop\warn.txt" -g ": warning %{WORD:code}" -o csv