last command

ahmed.vaghar · 10-01-2015, 11:06 AM

Hello Experts,

Am trying to use last -w command to get the users logged in to the machine,It is working fine.But my requirement is to get only fews fields to the output file like username,hostname and Date to the output file,Can someone help on this ?

Regards,

TB0ne · 10-01-2015, 11:09 AM

Quote:

Originally Posted by ahmed.vaghar

Hello Experts,
Am trying to use last -w command to get the users logged in to the machine,It is working fine.But my requirement is to get only fews fields to the output file like username,hostname and Date to the output file,Can someone help on this ?

Simplest way would be to pipe it into awk, and print out what you need. Like:

Code:

last -w | awk '{print $1","$2}'

ahmed.vaghar · 10-01-2015, 11:36 AM

Awesome.

Thank you TB0ne really you have given a break.

Can you also please help me how to write the output in csv or excel file ? Am trying the below command it is giving syntax error.

last -w| awk 'printf "%-15s\t%-15s\%-15s\t%-15s\n", "USERNAME", "LOGGEDIN_FROM", "LOGIN_DATE","LOGIN_TIME","LOGIN_DUARATION"}' '{print $1","$3","$5","$6","$7","$8","$9","$10}'

Thank you very much for your help.

Regards

grail · 10-01-2015, 12:39 PM

I would urge some caution and to check your results as the date component, and maybe others, is not a single field

ahmed.vaghar · 10-01-2015, 01:22 PM

Grail,

I agree with you,

Below the command.

last -w -F | awk 'printf "%-15s\t%-15s\%-15s\t%-15s\n", "USERNAME", "HOSTNAME","LOGIN_TIME", "LOGOUT_TIME","LOGIN_DUARATION"}' '{print $1","$3","$5$6$7$8","$11$12$13$14","$15}'

robertdaleweir · 10-01-2015, 04:51 PM

Quote:

Originally Posted by ahmed.vaghar

Grail,

I agree with you,

Below the command.

last -w -F | awk 'printf "%-15s\t%-15s\%-15s\t%-15s\n", "USERNAME", "HOSTNAME","LOGIN_TIME", "LOGOUT_TIME","LOGIN_DUARATION"}' '{print $1","$3","$5$6$7$8","$11$12$13$14","$15}'

Hi ahmed.vaghar
Your awk function seems to throw errors when I run it.

ahmed.vaghar · 10-01-2015, 05:01 PM

Can you try this ?

last -w -F | awk '{print "USERNAME" $1","$3","$5$6$7$8","$11$12$13$14","$15}' | tac | tr ',' '\t'

robertdaleweir · 10-01-2015, 06:45 PM

Quote:

Originally Posted by ahmed.vaghar

Can you try this ?

last -w -F | awk '{print "USERNAME" $1","$3","$5$6$7$8","$11$12$13$14","$15}' | tac | tr ',' '\t'

Hi ahmed.vaghar
Works fine, thank you.

ahmed.vaghar · 10-01-2015, 07:51 PM

Can you help me out here ?

grail · 10-02-2015, 02:46 AM

What do you require? I have not seen another question and you seemed to have what you needed??

ahmed.vaghar · 10-02-2015, 08:43 AM

I need to write this output in csv or excel file with the column names.

Please help me

szboardstretcher · 10-02-2015, 08:48 AM

Ok.

Code:

echo "user,ip,begin,end,total"
last -w -F | awk '{print $1","$3","$5$6$7$8","$11 $12 $13 $14","$15}' | tac

TB0ne · 10-02-2015, 10:19 AM

Quote:

Originally Posted by ahmed.vaghar

I need to write this output in csv or excel file with the column names. Please help me

We did help you...a better approach for you would be to take the hints/advice you've been given, and LEARN from them. You could easily think about what you were given, and have figured out how to get a CSV file on your own.

Please try to show some effort of your own.