Sponsored Content
Top Forums Shell Programming and Scripting Awk script to sort and display total occurancies Post 302658655 by rakeshkumar on Tuesday 19th of June 2012 05:43:39 PM
Old 06-19-2012
Awk script to sort and display total occurancies

Hi

I am not a good awk programer but the below code serving my purpose

Code:
Input
process  12936 user-name   15u  IPv4 7438309      0t0  TCP prdabc.cesi.com:42016->efh.ijk.com:50002 (ESTABLISHED)
process  12942 user-name   13u  IPv4 7764990      0t0  TCP abc.abc.com:9402->192.168.1.1:63919 (ESTABLISHED)
process  12942 user-name   19u  IPv4 7807116      0t0  TCP abc.abc.com:9402->192.168.1.1:63958 (ESTABLISHED)
process  12942 user-name   21u  IPv4 7800224      0t0  TCP abc.abc.com:9402->192.168.1.2:dvt-system (ESTABLISHED)
process  12942 user-name   22u  IPv4 7850124      0t0  TCP abc.abc.com:9402->192.168.1.3:50744 (ESTABLISHED)
process  12942 user-name   23u  IPv4 7800259      0t0  TCP abc.abc.com:9402->192.168.1.2:procos-lm (ESTABLISHED)
process  12942 user-name   24u  IPv4 7800282      0t0  TCP abc.abc.com:9402->192.168.1.2:pda-data (ESTABLISHED)
process  12942 user-name   25u  IPv4 7800285      0t0  TCP abc.abc.com:9402->192.168.1.2:pda-sys (ESTABLISHED)
process  12942 user-name   26u  IPv4 7800319      0t0  TCP abc.abc.com:9402->192.168.1.2:semaphore (ESTABLISHED)
process  12942 user-name   13u  IPv4 7764990      0t0  TCP abc.abc.com:9402->192.168.1.1:63919 (ESTABLISHED)
process  12942 user-name   19u  IPv4 7807116      0t0  TCP abc.abc.com:9402->192.168.1.1:63958 (ESTABLISHED)

The below code Displays number of ips with 90402 port
lsof -i -p 9402 | grep "9402-" | awk '{print $9}' | awk '{FS=":"}{print $2}' | awk '{FS="->"}{print $2}'

The below code is displaying the unique entries
lsof -i -p 9402 | grep "9402-" | awk '{print $9}' | awk '{FS=":"}{print $2}' | awk '{FS="->"}{print $2}'| sort | uniq

But I want to format it something like below
<IP-Address>     <Number of occurrences>
192.168.1.1                     3
192.168.1.2                     2

Any Help is much appreciated
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ls I do not want to display total with ls

I'm trying to write the filenames only to a file. The following line works: ls -l /home/alex >> log/filetrack.log But the file filetrack.log also contains the "total" i.e. the first line is total 3462984 Also, I would like only the filename, date and size to be listed. However, my main... (3 Replies)
Discussion started by: rx82000
3 Replies

2. Shell Programming and Scripting

Using sort with awk script

I have a file with four fields and an awk script that strips out one field displaying the remaining three. I have added headings for each of these fields such as Player - Year - RBIs then below it comes the data. What I am trying to do is sort the RBIs field in my script from most to least at the... (9 Replies)
Discussion started by: Trellot
9 Replies

3. Shell Programming and Scripting

sort files by date, delete oldest, if total size bigger than

hello people i need your help please i want to achieve the following with the simplest, most efficient shell-tools: i have a directory with a lot of files from users. the script should check which partition the dir is on if the partition with the directory is more than 90% full ... (2 Replies)
Discussion started by: scarfake
2 Replies

4. Shell Programming and Scripting

awk script to calculate total

Hi First field is the Record Type. A Record Type 5 can have multiple Record Type 6's before another Record Type 5 appears. I want to calculate the total of fields at position 8-11 on Record type 6 when Record Type 5 has a field at position 11-14 equals to '2222'. then it should delete the lines... (2 Replies)
Discussion started by: appsguy616
2 Replies

5. Shell Programming and Scripting

Display LineNo Incase Total Number Of Delimiter Does matches in a given variable

I have many files .dat extension. requirement is to display line no if no of delimiter does not matches in a given variable lets say File: REF_BETOS.dat HCPCS_OR_CPT_CODE~BETOS_CODE~TERMINATION_DATE 0001F~Z2~ 0003T~I4~B20061231 0005F~Z2~~~ 0008T~P8~B20061231... (1 Reply)
Discussion started by: ainuddin
1 Replies

6. Emergency UNIX and Linux Support

Grab total page read from webalizer display in html

Hi, I need a way to grab the total combines since inception, total pages read from webalizer on my centos server or any other location (as long as since inception) and display the result live on my website So with each visit it would be increasing, or perhaps live (ajax) not sure But can... (0 Replies)
Discussion started by: lawstudent
0 Replies

7. UNIX for Dummies Questions & Answers

Display total hard disk size?

Hi, Using Redhat, how do I display total hard disk size? I know how to do that in Solaris, you can type, format. It will show how big the disks are. This is what I did so for. $ df -t ext3 -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 ... (1 Reply)
Discussion started by: samnyc
1 Replies

8. Homework & Coursework Questions

Shell script/awk to sort text

1. The problem statement, all variables and given/known data: I have a file with a fragment of a novel, which I have to clear from punctuation and sort all the words contained one per line and non duplicated, all this going to a file called "palabras". Here is fragment of the input file: ... (4 Replies)
Discussion started by: ektorzoza
4 Replies

9. UNIX for Beginners Questions & Answers

Shell script to call and sort awk script and output

I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 Replies
IP-TCP_METRICS(8)						       Linux							 IP-TCP_METRICS(8)

NAME
ip-tcp_metrics - management for TCP Metrics SYNOPSIS
ip [ OPTIONS ] tcp_metrics { COMMAND | help } ip tcp_metrics { show | flush } SELECTOR ip tcp_metrics delete [ address ] ADDRESS SELECTOR := [ [ address ] PREFIX ] DESCRIPTION
ip tcp_metrics is used to manipulate entries in the kernel that keep TCP information for IPv4 and IPv6 destinations. The entries are cre- ated when TCP sockets want to share information for destinations and are stored in a cache keyed by the destination address. The saved information may include values for metrics (initially obtained from routes), recent TSVAL for TIME-WAIT recycling purposes, state for the Fast Open feature, etc. For performance reasons the cache can not grow above configured limit and the older entries are replaced with fresh information, sometimes reclaimed and used for new destinations. The kernel never removes entries, they can be flushed only with this tool. ip tcp_metrics show - show cached entries address PREFIX (default) IPv4/IPv6 prefix or address. If no prefix is provided all entries are shown. The output may contain the following information: age <S.MMM>sec - time after the entry was created, reset or updated with metrics from sockets. The entry is reset and refreshed on use with metrics from route if the metrics are not updated in last hour. Not all cached values reset the age on update. cwnd <N> - CWND metric value fo_cookie <HEX-STRING> - Cookie value received in SYN-ACK to be used by Fast Open for next SYNs fo_mss <N> - MSS value received in SYN-ACK to be used by Fast Open for next SYNs fo_syn_drops <N>/<S.MMM>sec ago - Number of drops of initial outgoing Fast Open SYNs with data detected by monitoring the received SYN-ACK after SYN retransmission. The seconds show the time after last SYN drop and together with the drop count can be used to disable Fast Open for some time. reordering <N> - Reordering metric value rtt <N>us - RTT metric value rttvar <N>us - RTTVAR metric value ssthresh <SSTHRESH> - SSTHRESH metric value tw_ts <TSVAL>/<SEC>sec ago - recent TSVAL and the seconds after saving it into TIME-WAIT socket ip tcp_metrics delete - delete single entry address ADDRESS (default) IPv4/IPv6 address. The address is a required argument. ip tcp_metrics flush - flush entries This command flushes the entries selected by some criteria. This command has the same arguments as show. EXAMPLES
ip tcp_metrics show address 192.168.0.0/24 Shows the entries for destinations from subnet ip tcp_metrics show 192.168.0.0/24 The same but address keyword is optional ip tcp_metrics Show all is the default action ip tcp_metrics delete 192.168.0.1 Removes the entry for 192.168.0.1 from cache. ip tcp_metrics flush 192.168.0.0/24 Removes entries for destinations from subnet ip tcp_metrics flush all Removes all entries from cache ip -6 tcp_metrics flush all Removes all IPv6 entries from cache keeping the IPv4 entries. SEE ALSO
ip(8) AUTHOR
Original Manpage by Julian Anastasov <ja@ssi.bg> iproute2 23 Aug 2012 IP-TCP_METRICS(8)
All times are GMT -4. The time now is 06:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy