Sponsored Content
Top Forums Shell Programming and Scripting User Logged In The Most - Bash Post 302497532 by Corona688 on Thursday 17th of February 2011 01:05:46 PM
Old 02-17-2011
Okay, this works for me when I feed it your last output on stdin:
Code:
#!/bin/bash

while read USER TERM WKDAY MON DAY TIME DASH END DURATION
do
        [ "$TERM" == "console" ] || continue
        [ "$DASH" == "-" ] || continue
        [ "${DURATION:0:1}" == "(" ] || continue

        # Remove brackets
        DURATION="${DURATION:1:$((${#DURATION}-2))}"
        # Strip +07 garbage
        DURATION="${DURATION//+[0-9][0-9]/}"

        # Split 05:30 into 05 and 30
        IFS=":" read HOUR MIN <<< "$DURATION"

        # Strip leading zeroes, otherwise BASH will assume the
        # numbers are octal!
        HOUR="${HOUR#0}"
        MIN="${MIN#0}"

        ((MIN+=(HOURS*60)))

        echo $USER $MIN
done | awk '{ t[$1]+=$2;        }
        END {   most=""
                for(key in t)
                        if(t[most] < t[key])    most=key;

                printf("%s\t%02d:%02d\n", most, t[most]/60, t[most]%60);
        }'

Code:
$ ./last.sh < lastdata
panman82        16:09
$

A pure awk solution might be more elegant but the necessary string operations seem much easier in the shell.

Last edited by Corona688; 02-17-2011 at 02:14 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Is user logged on??

How can i check to see if a user is logged on to the network? (1 Reply)
Discussion started by: provo
1 Replies

2. Shell Programming and Scripting

user logged on?

Hi, What commands do i need to check if a user is logged on to the network? thanks. (1 Reply)
Discussion started by: provo
1 Replies

3. UNIX and Linux Applications

user logged on any server

the method to find out the all the user who are the current user of the system? i tried with the who. but with that i receive the TTY like something. (3 Replies)
Discussion started by: NIMISH AGARWAL
3 Replies

4. UNIX for Advanced & Expert Users

Send email as a different user than the user logged in

Hi I am using mailx to send email and am wondering if there is a way I can send the email from a different user than the user logged in. something like do-not-reply@xyz.com Thank you. (1 Reply)
Discussion started by: rakeshou
1 Replies

5. Shell Programming and Scripting

How can one know how much time user logged?

Hello, i know who command gives you the time when particular user logged in. And subtracting today's date and time from the one found in who we can get how much time user logged in. But this can get very much clumsy as we can't subtract date directly in unix . Is there any other way or command... (4 Replies)
Discussion started by: salman4u
4 Replies

6. Shell Programming and Scripting

Does running a cron job of a user require the user to be logged in?

Suppose user 'asdf' is not logged into server 'bbbb', but the server is up. User 'asdf' has cron job. Will it be executed? (1 Reply)
Discussion started by: thulasidharan2k
1 Replies

7. Red Hat

How to confirm an user logged in is a remote user?

How do I confirm if a user logged in, is remote or local? In the case if the user is remote, how to be sure what authentication/method is it using, like LDAP, NIS or other? (2 Replies)
Discussion started by: kirtikjr
2 Replies

8. Shell Programming and Scripting

current logged in user

Hey guys I need a script that reads a login name and verifies if that user is currently logged in i have found few commands like "who" and "users" but i wonder how can i verify it that login name is logged in or not? (3 Replies)
Discussion started by: nishrestha
3 Replies

9. Shell Programming and Scripting

Last user logged in

hi! How can I find into: /var/log/messages.4 /var/log/messages.3 /var/log/messages.2 /var/log/messages.1 /var/log/messages The last user do a login? (for example user1) My idea is to search by the pattern "Accepted password for" buy I necessary search into all files first and in the... (2 Replies)
Discussion started by: guif
2 Replies

10. Shell Programming and Scripting

Logged in windows user name

Hi All, We use putty to connect to a unix box. We want to identify the folks involved in running certain shell scripts on the server. I want to identify the windows user id of those folks who have logged through Putty to run the scripts.As unix-id is shared by more than two folks, tracking... (3 Replies)
Discussion started by: mdkareemuddin
3 Replies
SQL-TYPES-WITH-PDO_4D-AND-PHP(3)					 1					  SQL-TYPES-WITH-PDO_4D-AND-PHP(3)

SQL types with PDO_4D and PHP - SQL types with PDO_4D and PHP

       Supported SQL types

       +-----------------+--------------------------------------+---+
       |  Type SQL 4D	 |					|   |
       |		 |					|   |
       |		 |	      Equivalent 4D		|   |
       |		 |					|   |
       |		 |		   Note 		|   |
       |		 |					|   |
       +-----------------+--------------------------------------+---+
       | ALPHA_NUMERIC	 |					|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ VARCHAR		|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ TEXT		|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ TIMESTAMP		|   |
       |		 |					|   |
       |		 |		   DATE 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ INTERVAL		|   |
       |		 |					|   |
       |		 |		   HOUR 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ DURATION		|   |
       |		 |					|   |
       |		 |		   HOUR 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ BOOLEAN		|   |
       |		 |					|   |
       |		 |		 BOOLEAN		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		  T{ BIT		|   |
       |		 |					|   |
       |		 |		 BOOLEAN		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ BYTE		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT16		|   |
       |		 |					|   |
       |		 |		 SMALLINT		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ SMALLINT		|   |
       |		 |					|   |
       |		 |		 SMALLINT		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT32		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		  T{ INT		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT64		|   |
       |		 |					|   |
       |		 |		  INT64 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ NUMERIC		|   |
       |		 |					|   |
       |		 |		  INT64 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ REAL		|   |
       |		 |					|   |
       |		 |		   REAL 		|   |
       |		 |					|   |
       |		 | Unsupported (use VARCHAR conversion) |   |
       |		 |					|   |
       |     FLOAT	 |					|   |
       |		 |					|   |
       |		 |		  FLOAT 		|   |
       |		 |					|   |
       |		 | Unsupported (use VARCHAR conversion) |   |
       |		 |					|   |
       |DOUBLE PRECISION |					|   |
       |		 |					|   |
       |		 |		  FLOAT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ BLOB		|   |
       |		 |					|   |
       |		 |		   BLOB 		|   |
       |		 |					|   |
       |		 | Must  use  a prepared statement, and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       |  BIT VARYING	 |					|   |
       |		 |					|   |
       |		 |		   BLOB 		|   |
       |		 |					|   |
       |		 | Must use a prepared	statement,  and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       |      CLOB	 |					|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ PICTURE		|   |
       |		 |					|   |
       |		 |		 PICTURE		|   |
       |		 |					|   |
       |		 | Must  use  a prepared statement, and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       +-----------------+--------------------------------------+---+
PHP Documentation Group 											  SQL-TYPES-WITH-PDO_4D-AND-PHP(3)
All times are GMT -4. The time now is 10:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy