Powershell. count the number of duplicate entries in a file

Question

I have a text file with a list of IP addresses, and i need to count the number of times the same IP appears in the file.

I've found lots of ways of removing duplicate entries, and how to count the number of lines, but nothing on how to counting duplicate entries.

I haven't got much of a script yet, not anything worth posting, but if someone can point me in the right direction, that will be a start.

You really haven't given us much info. What does the file look like, just a list of IP's, one per line? If so you want Group-Object. Run with that, and come back when you have a script that we can see and help with if you have issues. — TheMadTechnician
– TheMadTechnician, Commented Apr 7, 2015 at 5:07

Mark Henderson · Accepted Answer · 2018-03-02 20:12:44Z

11

If $file contains

10.1.1.2  
10.1.1.2  
10.1.1.2  
10.1.1.10  
10.1.1.10  
10.1.1.20

then

Get-Content $file | Group-Object -noelement

Count Name                     
----- ----                     
3     10.1.1.2                 
2     10.1.1.10                
1     10.1.1.20

edited Mar 2, 2018 at 20:12

Mark Henderson

2,7162 gold badges36 silver badges44 bronze badges

answered Apr 7, 2015 at 5:25

mattnicola

4031 gold badge5 silver badges19 bronze badges

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

1 Comment

Brunis Over a year ago

Most of my logs have timestamps, is there a way i can ignore the first part (timestamp) of each line?

Collectives™ on Stack Overflow

Powershell. count the number of duplicate entries in a file

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related