Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Help needed with adding column headings in syslog report Post 302460216 by wthomas on Wednesday 6th of October 2010 08:45:57 AM
Old 10-06-2010
Help needed with adding column headings in syslog report

Hi all,
I need your help in adding column headings in the below report.
The headings I want are:
Code:
Count - Host - Message Type

The command used to create the report is as follows:
Code:
for messages in `cat syslog_message_list.txt`
do 
grep $messages syslog.`date +%d%m%y`.log | awk '{print $4 " " " " $9}' | sort | uniq -c |sort +2|sort -rk3 >> syslog.`date +%d%m%y`.report
done

Sample output:
Code:
596 cbfrt01.nls.jlrint.com %DUAL-5-NBRCHANGE:
139 cbfrt02.nls.jlrint.com %DUAL-5-NBRCHANGE:
27 cbsrt36e0-0.castlebrom.jlrint.com %DUAL-5-NBRCHANGE:
2 [192.168.23.102.199.221] %DUAL-5-NBRCHANGE:
1 cbsrt34e0-0.castlebrom.jlrint.com %DUAL-5-NBRCHANGE:
1 cbsrt33e0-0.castlebrom.jlrint.com %DUAL-5-NBRCHANGE:
1472 [19.189.126.81.193.114] %ENVMON-3-FAN_FAILED:
126 whjsw101-0102.nls.jlrint.com %LINK-4-ERROR:
73 solsw183-b38a.nls.jlrint.com %LINK-4-ERROR:
19 solsw362-nw24.nls.jlrint.com %LINK-4-ERROR:

Regards, Wynford

Last edited by Scott; 10-06-2010 at 10:31 AM.. Reason: Code tags, please...
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ls -l column headings

I'm trying to see if there's a way to see column headings when I type the ls -l command. I know what some of the fields mean for example in the following listing: total 136 drwxr-xr-x 2 root root 4096 Jun 5 15:16 bin drwxr-xr-x 3 root root 4096 Jul 9 15:25 boot drwxr-xr-x 9... (6 Replies)
Discussion started by: thoughts
6 Replies

2. UNIX for Dummies Questions & Answers

adding a column

Hi everybody, I've got a file with 36074 fields. I need to insert an additional new columns 2,3,4 and 5 after the first field. The columns to insert are the same for all the lines: it's "1" doe the new field 2 and "0" for the rest. I did have a look in the forum and the suggested solution I... (7 Replies)
Discussion started by: zajtat
7 Replies

3. Shell Programming and Scripting

Adding column

Hello, I'm struggling with the following problem in sh script: Adding a column to the right-end of a file ("master-file": non-constant column number, tab and linux formatted) where the column is the 4th one of file1 (space and DOS formatted) Changing the header of column 4 of file 1 at the... (4 Replies)
Discussion started by: lco
4 Replies

4. Shell Programming and Scripting

Help needed: Adding columns in csv file in loop

Hi Everyone: My shell script creates multiple csv files (~30) in for loop. I want to compile (or merge) 3rd column from each (all) of these files to another file (in loop). Please help. Thanks. (3 Replies)
Discussion started by: smap007
3 Replies

5. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

6. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

7. Shell Programming and Scripting

Adding values of a column based on another column

Hello, I have a data such as this: ENSGALG00000000189 329 G A 4 2 0 ENSGALG00000000189 518 T C 5 1 0 ENSGALG00000000189 1104 G A 5 1 0 ENSGALG00000000187 3687 G T 5 1 0 ENSGALG00000000187 4533 A T 4 2 0 ENSGALG00000000233 5811 T C 4 2 0 ENSGALG00000000233 5998 C A 5 1 0 I want to... (3 Replies)
Discussion started by: Homa
3 Replies

8. Shell Programming and Scripting

Adding column

I have input CSV files as TS DS_WKLDNM InterfaceSpeed 29/07/2014 20:00:00 xxx112/1/18 10000000000 29/07/2014 09:00:00 xxx112/1/19 10000000000 29/07/2014 21:00:00 xxx112/1/2 10000000000 29/07/2014 20:00:00 xxx112/1/20 10000000000 29/07/2014... (10 Replies)
Discussion started by: Moon1234
10 Replies

9. Shell Programming and Scripting

Adding a column

Hello , My requirement is to add additional column sequentially to a text file based on the column value - i/p file id1|varchar id2|varchar id3|number id4|number id5|date id6|date --------------------------------------- o/p file colv1|id1 (if second column value is varchar then... (3 Replies)
Discussion started by: Pratik4891
3 Replies

10. Shell Programming and Scripting

Help with awk command on report with headings

Hi all, I have a report that looks like this: ------------------------------------------------- -- AOC - XXXXXXX -- ------------------------------------------------- Thread Last Sequence Received Last Sequence Applied Difference ----------... (12 Replies)
Discussion started by: cougartrace
12 Replies
lanscan(1M)															       lanscan(1M)

NAME
lanscan - display LAN device configuration and status SYNOPSIS
Remarks The and commands are deprecated. See for more information. DESCRIPTION
displays the following information about each LAN device that has software support on the system: o Hardware Path. o Active Station Address (also known as Physical Address). o Card Instance Number o Hardware State. o Network Interface "NamePPA". The Network Interface "Name" and the "PPA" (Physical Point of Attachment) number are concatenated together. A single hardware device may have multiple "NamePPA" identifiers, which indicates multiple encapsulation methods may be supported on the device. For Ethernet/IEEE 802.3 links, the "Name" is used to designate Ethernet encapsulation, and for IEEE 802.3 encapsulation. For other links (FDDI, Token Ring), only the encapsulation designation is used. o Network Management ID. o MAC Type. o HP DLPI Supported. Indicates whether or not the lan device driver will work with HP's Common Data Link Provider Interface. o DLPI Major Number. o Extended Station Address for those interfaces which require more than 48 bits. This is displayed only when the option is selected. o Encapsulation Methods that the Network Interface supports. This is displayed only when the option is selected. Options recognizes the following command-line options: Display station addresses only. No headings. Display interface names only. No headings. Display information about PPAs that are acquired by APA. No headings. Display MAC types only. No headings. Display Network Managements IDs only. No headings. Display PPA numbers only. No headings. Same as except link aggregate PPA's will be followed by a list of LAN interface PPA's that are configured in the corresponding link aggregate. No headings. Verbose output. Two lines per interface. Includes displaying of extended station address and supported encapsulation methods. WARNINGS
does not display information about LAN devices that do not have software support such as LAN interface cards that fail to bind properly at boot-up time. Obsolescence The and commands are deprecated. These commands will be removed in a future HP-UX release. HP recommends the use of replacement command nwmgr(1M) to perform all network interface-related tasks. AUTHOR
was developed by HP. SEE ALSO
ifconfig(1M), ioscan(1M), nwmgr(1M), lanadmin(1M), linkloop(1M), lan(7). TO BE OBSOLETED lanscan(1M)
All times are GMT -4. The time now is 08:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy