UNIX for Dummies Questions & Answers

Hi all,

I'm using Solaris 10, and need help in sorting the below output from the syslog file in descending rather than ascending order.
I would like both the hostname and message columns to be sorted, but right now only the message is sorted and the count column, whose order I would like reversed. I need the count column to be sorted listing the highest count at the top.

Command:

Code:

cat messages |awk '{print $4 " " " " $9}' | sort | uniq -c | sort -r|sort +2|more

Output:

Code:

   6 galsw102-b102a.nls.jlrint.com  %LINK-3-UPDOWN:
   6 whjsw213-0905.nls.jlrint.com  %LINK-3-UPDOWN:
   6 whjsw215-1001.nls.jlrint.com  %LINK-3-UPDOWN:
   7 solsw259-b71a.nls.jlrint.com  %LINK-3-UPDOWN:
   7 whjsw192-0901.nls.jlrint.com  %LINK-3-UPDOWN:
 158 solsw137-b02b.nls.jlrint.com  %LINK-3-UPDOWN:
   3 whjsw101-0102.nls.jlrint.com  %LINK-4-ERROR:
   1 cbjsw264-2004.nls.jlrint.com  %PLATFORM_ENV-1-PWR:
   1 whjsw169-0607.nls.jlrint.com  %RTD-1-ADDR_FLAP:
   2 cbjsw190-1101.nls.jlrint.com  %RTD-1-ADDR_FLAP:
   3 cbjsw198-1102.nls.jlrint.com  %RTD-1-ADDR_FLAP:
   3 cbjsw205-1103.nls.jlrint.com  %RTD-1-ADDR_FLAP:
   4 cbjsw204-1103.nls.jlrint.com  %RTD-1-ADDR_FLAP:
  42 hajsw112-0107.nls.jlrint.com  %RTD-1-LINK_FLAP:
  43 solsw137-b02b.nls.jlrint.com  %RTD-1-LINK_FLAP:

Regards, Wynford

try changing:

Code:

cat messages |awk '{print $4 " " " " $9}' | sort | uniq -c | sort -r|sort +2|more

to

Code:

awk '{print $4 " " " " $9}' messages | sort | uniq -c | sort -k1nr,3 |more

Think that should be close to what you're after ??

---------- Post updated at 10:36 AM ---------- Previous update was at 10:27 AM ----------

Hi Tytalus, et al

I actually need my output to be like the following, so that the count is in descending order listing all hosts for each message type: (I have removed the appending domain name for privacy)

118 mexsw116-mxg05s1 RTD-1-ADDR_FLAP
67 pbs051 RTD-1-ADDR_FLAP
49 mexsw107-mxc13s1 RTD-1-ADDR_FLAP
10 logmdf11se06 RTD-1-ADDR_FLAP
9 pbs041.nlse RTD-1-ADDR_FLAP
6 gnksw116-bcmso0 RTD-1-ADDR_FLAP
5 mexsw117-mxg07s1 RTD-1-ADDR_FLAP
4 mexsw122-mxl12s1 RTD-1-ADDR_FLAP
1 nyu10se01.nlse RTD-1-ADDR_FLAP
1 mexsw129-mxp19s1 RTD-1-ADDR_FLAP
1 gnksw150-br02o1 RTD-1-ADDR_FLAP
1 gnksw149-br02o0 RTD-1-ADDR_FLAP
2 fce11929 SYS-2-PS_FAIL
1 fce11926 SYS-2-PS_FAIL
1 ablsw02 SYS-2-PS_FAIL
1 ablsw01 SYS-2-PS_FAIL
1 fce11929 SYS-2-PS_INSUFFICIENT
96 wasw144a SYS-3-PORT_IN_ERRORS
4 wasw154a SYS-3-PORT_IN_ERRORS
3 wasw148a SYS-3-PORT_IN_ERRORS
2 dtsw108a SYS-3-PORT_IN_ERRORS
1 whjsw01 SYS-3-PORT_IN_ERRORS
95 wasw144a SYS-3-PORT_RUNTS
4 wasw154a SYS-3-PORT_RUNTS
2 wasw148a SYS-3-PORT_RUNTS
2 dtsw108a SYS-3-PORT_RUNTS

Regards,

Wynford

---------- Post updated at 10:59 AM ---------- Previous update was at 10:36 AM ----------

I've cracked it now, here is the command and resulting output:

cat messages |awk '{print $4 " " " " $9}' | sort | uniq -c |sort +2|sort -rk3|more

43 solsw137-b02b.nls.jlrint.com %RTD-1-LINK_FLAP:
42 hajsw112-0107.nls.jlrint.com %RTD-1-LINK_FLAP:
4 cbjsw204-1103.nls.jlrint.com %RTD-1-ADDR_FLAP:
3 cbjsw205-1103.nls.jlrint.com %RTD-1-ADDR_FLAP:
3 cbjsw198-1102.nls.jlrint.com %RTD-1-ADDR_FLAP:
2 cbjsw190-1101.nls.jlrint.com %RTD-1-ADDR_FLAP:
1 whjsw169-0607.nls.jlrint.com %RTD-1-ADDR_FLAP:
1 cbjsw264-2004.nls.jlrint.com %PLATFORM_ENV-1-PWR:
3 whjsw101-0102.nls.jlrint.com %LINK-4-ERROR:
158 solsw137-b02b.nls.jlrint.com %LINK-3-UPDOWN:
7 whjsw192-0901.nls.jlrint.com %LINK-3-UPDOWN:
7 solsw259-b71a.nls.jlrint.com %LINK-3-UPDOWN:
6 whjsw215-1001.nls.jlrint.com %LINK-3-UPDOWN:
6 whjsw213-0905.nls.jlrint.com %LINK-3-UPDOWN:

Thanks for helping.

Regards, Wynford