uniq/sort question

[Robert-Jan Goossens_1]

Below is a list of multipath devices (luns), is possible to sort the list based on the serial?

# egrep -e "Serial|Unformatted" /tmp/rj-lun
Serial Num: 10328022C008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022C008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022D008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022D008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022E008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022E008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022F008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022F008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280230008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280230008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280231008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280231008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280232008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280232008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280233008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280233008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280234008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280234008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280235008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280235008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280236008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280236008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280237008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280237008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280238008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280238008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280F3C000
Unformatted capacity: 51937.500 MBytes
Serial Num: 103280F3C000
Unformatted capacity: 51937.500 MBytes
Serial Num: 103280F3E000
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280F3E000
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022C008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022C008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022D008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022D008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022E008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022E008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022F008
Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022F008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280230008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280230008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280231008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280231008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280232008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280232008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280233008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280233008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280234008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280234008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280235008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280235008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280236008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280236008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280237008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280237008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280238008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280238008
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280F3C000
Unformatted capacity: 51937.500 MBytes
Serial Num: 103280F3C000
Unformatted capacity: 51937.500 MBytes
Serial Num: 103280F3E000
Unformatted capacity: 25968.750 MBytes
Serial Num: 103280F3E000
Unformatted capacity: 25968.750 MBytes

Regards,
Robert-Jan

[James R. Ferguson]

Hi Robert-Jan:

If the issue is that each line shown is a separate line, then join the lines and pipe them to a sort:

# paste -s -d"\t\n" | sort -k3,3

Regards!

...JRF...

[James R. Ferguson]

Hi (again):

# paste -s -d"\t\n" | sort -u -k3,3

...since your subject line suggested unique values, too.

Regards!

...JRF...

[Robert-Jan Goossens_1]

Thanks for your time James!

This is the information I need but I will loose the combined serial size info about the lun.

# paste -s -d"\t\n" | sort -u -k3,3 /tmp/rj-lun2
Serial Num: 10328022C008
Serial Num: 10328022D008
Serial Num: 10328022E008
Serial Num: 10328022F008
Serial Num: 103280230008
Serial Num: 103280231008
Serial Num: 103280232008
Serial Num: 103280233008
Serial Num: 103280234008
Serial Num: 103280235008
Serial Num: 103280236008
Serial Num: 103280237008
Serial Num: 103280238008
Serial Num: 103280F3C000
Serial Num: 103280F3E000
Unformatted capacity: 25968.750 MBytes
Unformatted capacity: 51937.500 MBytes

Regards,
Robert-Jan

[James R. Ferguson · Accepted solution]

Hi (again) Robert-Jan:

I meant to write thusly:

# paste -s -d"\t\n" file | sort -k3,3

or:

# paste -s -d"\t\n" file | sort -u -k3,3

Regards!

...JRF...

[Robert-Jan Goossens_1]

Thanks a lot James!

# paste -s -d"\t\n" /tmp/rj-lun2 | sort -u -k3,3
Serial Num: 10328022C008 Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022D008 Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022E008 Unformatted capacity: 25968.750 MBytes
Serial Num: 10328022F008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280230008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280231008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280232008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280233008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280234008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280235008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280236008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280237008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280238008 Unformatted capacity: 25968.750 MBytes
Serial Num: 103280F3C000 Unformatted capacity: 51937.500 MBytes
Serial Num: 103280F3E000 Unformatted capacity: 25968.750 MBytes

[Viktor Balogh]

Another solution with awk:

awk '/Serial/ {getline line;print $0,line}' FILENAME | sort -n -k 3

[Robert-Jan Goossens_1]

Thread closed!