Visit Our UNIX and Linux User Community


sorting data from who by IP


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers sorting data from who by IP
# 1  
Old 06-16-2008
sorting data from who by IP

Hello. I have an RS/6000 running AIX 4 and I need to be able to see if there are any users that are logged on more than once from the same terminal so I can kick them off to make room for other terminals. 64 connections is the limit. Currently I am doing this:

who | more
and then manually looking for duplicate IP's and then doing
ps -t pts/whatever or tty
to find the PID then killing the PID. Is there an easier and faster way of doing this? Thanks

-paul
# 2  
Old 06-16-2008
Instead of manually looking for duplicate IDs you can pipe the output to sort for getting unique records...

Code:
who | sort -uk6.2,6

# 3  
Old 06-16-2008
Thanks - but that is not showing me duplicates, instead it looks like there are no duplicates. I just tested by opening up two more connections from my machine and ran that command.
# 4  
Old 06-16-2008
By removing the U, so it is just
who | sort -k6.2,6

it works. Thanks again
# 5  
Old 06-16-2008
Question Can you show a sample command and output?

It can sometimes be difficult to "imagine" what your output looks like. Thus, examples are always a good way to convey the requirments.

Does this code:
Code:
who | tr -s " " | cut -d" " -f1,6 | sort | uniq -c

provide you with
count username ip_address?
If so, it may be the start of your process.

Last edited by joeyg; 06-16-2008 at 01:03 PM.. Reason: added sample code line
# 6  
Old 06-16-2008
Here is a snippet of who | sort -uk6.2,6 :

# who | sort -uk6.2,6
bhb tty11 Jun 16 11:06
rf1 pts/67 Jun 16 10:21 (10.203.32.105)
rf1 pts/20 Jun 16 10:58 (10.203.32.109)
bhb pts/4 Jun 16 06:24 (10.203.32.110)
rf1 pts/28 Jun 16 09:54 (10.203.32.117)
bhb pts/63 Jun 16 09:00 (10.203.32.123)
rf1 pts/9 Jun 16 09:42 (10.203.32.124)
bhb pts/50 Jun 16 09:26 (10.203.32.126)
root pts/54 Jun 16 08:30 (10.203.32.132)
bhb pts/25 Jun 16 07:21 (10.203.32.151)
bhb pts/10 Jun 16 10:49 (10.203.32.152)
bhb pts/35 Jun 16 07:40 (10.203.32.157)
bhb pts/2 Jun 16 10:47 (10.203.32.159)
bhb pts/23 Jun 16 07:20 (10.203.32.163)
bhb pts/26 Jun 16 07:22 (10.203.32.171)
bhb pts/1 Jun 16 06:26 (10.203.32.172)
bhb pts/41 Jun 16 07:53 (10.203.32.173)
bhb pts/27 Jun 16 11:13 (10.203.32.183)
bhb pts/21 Jun 16 10:28 (10.236.1.131)
bhb pts/24 Jun 16 11:54 (10.236.32.93)
bhb pts/42 Jun 16 09:24 (10.238.0.148)
bhb pts/39 Jun 16 07:52 (10.238.1.29)
bhb pts/31 Jun 16 10:34 (10.238.1.42)

here is a snippet of who | sort -k6.2,6 :

# who | sort -k6.2,6
bhb tty11 Jun 16 11:06
bhb tty14 Jun 16 09:44
bhb tty17 Jun 16 09:47
bhb tty37 Jun 16 08:25
bhb tty49 Jun 16 09:21
bhb tty8 Jun 16 07:54
root tty1 Jun 16 08:18
rf1 pts/67 Jun 16 10:21 (10.203.32.105)
rf1 pts/20 Jun 16 10:58 (10.203.32.109)
bhb pts/4 Jun 16 06:24 (10.203.32.110)
rf1 pts/28 Jun 16 09:54 (10.203.32.117)
bhb pts/63 Jun 16 09:00 (10.203.32.123)
rf1 pts/9 Jun 16 09:42 (10.203.32.124)
bhb pts/50 Jun 16 09:26 (10.203.32.126)
root pts/54 Jun 16 08:30 (10.203.32.132)
bhb pts/25 Jun 16 07:21 (10.203.32.151)
bhb pts/10 Jun 16 10:49 (10.203.32.152)
bhb pts/35 Jun 16 07:40 (10.203.32.157)
bhb pts/2 Jun 16 10:47 (10.203.32.159)
bhb pts/23 Jun 16 07:20 (10.203.32.163)
bhb pts/26 Jun 16 07:22 (10.203.32.171)
bhb pts/1 Jun 16 06:26 (10.203.32.172)
bhb pts/41 Jun 16 07:53 (10.203.32.173)

(un)fortunately, I have killed all the duplicate sessions, so none are showing up in my examples. To get really lazy, is there a way to ONLY show the duplicate IPs?
# 7  
Old 06-16-2008
Yes, who | tr -s " " | cut -d" " -f1,6 | sort | uniq -c
provides me with count, user, IP. But I do need to be able to see the PTS number so I know what PID to kill.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #712
Difficulty: Medium
On a large scale, the ability to treat instructions as data is what makes assemblers, compilers, linkers, loaders, and other automated programming tools possible.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How AS 400 sorting data?

Hi Gurus, I have a requests to sort data based on AS 400 sorting order. below is example: the data is sorted by ascending order. could anybody explain how AS 400 sort data? IMM00007 07918607 1242 423 (3 Replies)
Discussion started by: green_k
3 Replies

2. Shell Programming and Scripting

Sorting the data with date

Hi, PFB the data: C_Random_130417 Java_Random_130518 Perl_Random_120519 Perl_Random_120528 so the values are ending with year,i.e.,130417 i want to sort the values with date. i want the output like this: Perl_Random_120519 Perl_Random_120528 C_Random_130417 Java_Random_130518 can... (5 Replies)
Discussion started by: arindam guha
5 Replies

3. Shell Programming and Scripting

Sorting the Data

My actual data looks like below i have given only format. i can't give exact data format of my requirement due to some reasons. I this set of data lines about 5000 I need to come up with information in below exact format of my data set : Line<space>Number1<space>"somedata":... (1 Reply)
Discussion started by: ckaramsetty
1 Replies

4. UNIX for Dummies Questions & Answers

Help with Data Sorting

Hi All, I have a long list made of 4 columns containing entries such as the following example: a b c d 0 0 0 0 1 2 1 2 2 5 3 4 3 8 4 6 4 10 9 8 5 15 8 10So the top row is the header and I need to arrange the data in a way as to... (11 Replies)
Discussion started by: pawannoel
11 Replies

5. UNIX for Dummies Questions & Answers

Sorting data

Hello guys. I need help figuring this one out. It's probably really easy. Thanks in advance! I have a file say for example containing this: Rice Food Carrots Food Beans Food Plates Kitchen Fork Kitchen Knives Kitchen I need: Food Rice, Carrots, Beans Kitchen Plates, Fork,... (7 Replies)
Discussion started by: visuelz
7 Replies

6. UNIX for Dummies Questions & Answers

Help with Data Sorting Command

Hi, I have a problem on data sorting, example my file as below: 123 123/789 aaa bbb ccc ddd (adf) 112 112/123 aaa bbb ccc (ade) 102 1a3/7g9 (adf)03 110 12b/129 aaa bbb ccc ddd fff(a8f)03 117 42f/8c9 aaa bbb ccc ddd (adf) 142 120/tyu fff... (7 Replies)
Discussion started by: 793589
7 Replies

7. UNIX for Dummies Questions & Answers

Sorting data from a to z

Hi, Let's say I have these 3 columns; NGC1234 6 9 SL899 4 1 NGC1075 8 3 SL709 5 2 And I want to sort the data according to the first column (from a to z) like having them as: NGC1075 8 3 NGC1234 6 9 SL709 5 2 SL899 4 1 Can that be done... (2 Replies)
Discussion started by: cosmologist
2 Replies

8. Shell Programming and Scripting

PERL data - sorting

Hello, I have a page where multiple fields and their values are displayed. But I am able to sort only a few fields. When I looked into the issue, it is seen that the for each row of info , an unique id is generated and id.txt is generated and saved. Only those fields which are inside that id.txt... (3 Replies)
Discussion started by: eagercyber
3 Replies

9. Shell Programming and Scripting

Sorting blocks of data

Hello all, Below is what I am trying to accomplish: I have a file that looks like this /* ----------------- xxxx.y_abcd_00000050 ----------------- */ jdghjghkla sadgsdags asdgsdgasd asdgsagasdg /* ----------------- xxxx.y_abcd_00000055 ----------------- */ sdgsdg sdgxcvzxcbv... (8 Replies)
Discussion started by: alfredo123
8 Replies

Featured Tech Videos