Powershell find common string in log file

Question

I have a log file with a number of machine names, I'm looking to find the machine name that is listed most. Does anyone have any suggestions where I can get started with this?

Yep, thats what I intend on doing looking for any suggestions. Maybe there is a cmdlet that is good for this task. — JoeRod
– JoeRod, Commented Mar 18, 2014 at 20:43
Without knowing what your log looks like it is really impossible to say. Are the computer names the only thing on the line? Are they at the beginning of the line with other text after it? Is it in the middle of a line? — TheMadTechnician
– TheMadTechnician, Commented Mar 18, 2014 at 20:46

Duncan · Accepted Answer · 2014-03-18 20:43:57Z

3

Get-Content machinesnames.txt | sort | group | sort Count | select Name -last 1

answered Mar 18, 2014 at 20:43

Duncan

96.4k15 gold badges129 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jamey · Accepted Answer · 2014-03-18 20:45:06Z

0

Consider a file named my.log with the following:

a
b
b
c
c
c

You could run something like:

gc my.log | group-object | sort-object -Property "Count" -Descending | ft -Property ("Name", "Count");

The output is:

Name     Count
----     -----
c        3
b        2
a        1

gc reads each line of your file.

group-object counts each distinct group.

sort-object puts the most common at the top.

ft formats the output into a table. In this case you're interested in machine name and frequency.

answered Mar 18, 2014 at 20:45

Jamey

1,63310 silver badges24 bronze badges

Collectives™ on Stack Overflow

Powershell find common string in log file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related