Script to list users and their last login?

Login or Register to Ask a Question and Join Our Community

Script to list users and their last login?

Tags

last command, shell scripts

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting Script to list users and their last login?

10-01-2010

Registered User

2, 0

Join Date: Sep 2010

Last Activity: 27 October 2010, 4:23 AM EDT

Posts: 2

Thanks Given: 1

Thanked 0 Times in 0 Posts

Script to list users and their last login?

hi all,

I'm trying to write a script to create a file with a list of all users, their gid, gecos field and their last login time

e.g.

Quote:

user1 22 Fred Bloggs Sep 20

fairly new to scripting, this is what I've got so far

Code:

#!/bin/sh( userlist= cat /etc/passwd  | awk -F: '{print $1," ",$4," ",$5}'  
 for name in $userlist   
 do login= last -1 $name   
 echo $name $login >> `hostname`_userlogins.txt   done)

The output of the first part is fine but I can't get the loop and last command working, and need to append the output of 'last -1' for each user to the end of their 'line'

Any help would be greatly appreciated!

Last edited by Yogesh Sawant; 02-10-2011 at 05:52 AM.. Reason: added code tags

tanngo

View Public Profile for tanngo

Find all posts by tanngo

10-01-2010

Registered User

7,747, 559

Join Date: Feb 2007

Last Activity: 20 April 2020, 11:28 AM EDT

Location: The Netherlands

Posts: 7,747

Thanks Given: 139

Thanked 559 Times in 520 Posts

Quote:

Originally Posted by tanngo

hi all,I'm trying to write a script to create a file with a list of all users, their gid, gecos field and their last login time e.g.user1 22 Fred Bloggs Sep 20fairly new to scripting, this is what I've got so far#!/bin/sh( userlist= cat /etc/passwd | awk -F: '{print $1," ",$4," ",$5}' for name in $userlist do login= last -1 $name echo $name $login >> `hostname`_userlogins.txt done)The output of the first part is fine but I can't get the loop and last command working, and need to append the output of 'last -1' for each user to the end of their 'line'Any help would be greatly appreciated!

Moderator's Comments:

Mod Comment

This is almost unreadable, please edit the post, indent the code and use code tags.

Franklin52

View Public Profile for Franklin52

Find all posts by Franklin52

10-01-2010

Registered User

6,402, 678

Join Date: Mar 2008

Last Activity: 8 June 2016, 9:58 PM EDT

Posts: 6,402

Thanks Given: 288

Thanked 678 Times in 647 Posts

Rearranging your script a bit. Could not see a sensible use of "for" but you can make good use of "while" to give you a per-user loop.
Don't know what Operating System you have of what Shell is "/bin/sh" on your computer.
This script may or may not need modification for your Shell.
On my computer "last -1" outputs unwanted text if the user has not logged in since the wtmp file was last reset - hence the extra grep to see if "last -1" replied with what we wanted.

Code:

#!/bin/sh
(
cat /etc/passwd | awk -F: '{print $1,$4,$5}' | sort | \
while read username gid gecos
do
        last_login=`last -1 ${username}|grep \^${username}|awk '{print $4,$5}'`
        echo "${username} ${gid} ${gecos} ${last_login}"
done
) > `hostname`_userlogins.txt

Last edited by methyl; 10-01-2010 at 11:48 AM.. Reason: layout and code tags

This User Gave Thanks to methyl For This Post:

methyl

View Public Profile for methyl

Find all posts by methyl

10-03-2010

Registered User

2, 0

Join Date: Sep 2010

Last Activity: 27 October 2010, 4:23 AM EDT

Posts: 2

Thanks Given: 1

Thanked 0 Times in 0 Posts

Thanks Methl,

that works a treat!

Apologies for the original post, we're only ion IE6 at work and it wouldn't format the post correctly :-(

tanngo

View Public Profile for tanngo

Find all posts by tanngo

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get Home Directory for Users in Login Hook Script

I'm writing a script to use as a LoginHook for my Mac users. As part of this script, I need to write to a location in their home directory, but I can't seem to access the path - at this point in the login process, $HOME is empty and ~ gives the path to root's home. Unfortunately, I can't just do...

2. Shell Programming and Scripting

help to create script for added date to list users

hi my friends im asking for the possibility to creat a script in ubuntu for added date to list users for doing this : - search in debug connected user of all connected users - if a new user is connect for the first time to my server the script record the date of the connection and added it...

3. Shell Programming and Scripting

script to ignore the user from list of users

Hi, I have a situation where I want to ignore few users from list of users and print rest of user in log file. say, I want to ignore aaa, bbb, ccc, ddd .. ppp from list of 20 user (do not want to include) What is the good command or any script? Thanks in advance.

4. UNIX for Advanced & Expert Users

Need A Script To List All Failed Log In Users

I need to list all the failed log in users as part of audit report. How can I do so in Linux to find all the audit log records and then upload to a table for future reference. I am using oracle 10g on Linux. Hope I will get a quick response from the experts. Thanks in advance for the tips.

5. Shell Programming and Scripting

Script to list primary group of users

Dear All I am facing a problem with my script. I have to found the primary group of users . So first I selected all the groups and users register from a specific user : ONE Then I am making a file with all groups attached to the user : ONE Then I am making a file with all...

6. Shell Programming and Scripting

FTP script to login and list files to log file

Hi Guys I did a forum search for "ftp scripts" Looked at 8 pages and didnt see anything that would help. Most seem to be logging into a ftp server and transfering files. What I need to do is login to a FTP server. Goto a folder and list it so it showes newest files first. It would be nice to...

7. HP-UX

No users can login

Dear Forum, I had this case before, all of sudden all users including root can't login. What done is by connecting to console port and resetting root password, "pwunconv" command, reboot server. My question is, how this can happen??? thanks :confused:

8. UNIX for Dummies Questions & Answers

How to do a login time and date list of users never logged on?

Hello, I'm trying to do a list of user that never connected to a couple of servers. I want to do a diff between the servers lists, and print out only the users that never has logged on each server. Here my first step : SERVER01: # finger `egrep -v -e "^\s*#" /etc/passwd | awk '{ print $1 }' |...

9. Programming

how can get users list and their login time?

i'm sorry if yesterday i posted this thread in unix for dummies forums, :D i am a newbie in C programming i want to get active users list and their login time... i have search and learn about passwd and utmp, but i only can get user list without their login time... do you have an idea...

10. Shell Programming and Scripting

users login

Hello everyone I need to send to a file the last command from all users who log in and log out by week or month. My questions are I can do it with the command or I need to do a script ? If the answer is I need to do a script, someone can help me because Im complete new to make a...

Login or Register to Ask a Question