topic Re: How do I identify/summarize active/inactive users? in Operating System - HP-UX

How do I identify/summarize active/inactive users?

Stuart Abramson_2 — Wed, 13 Aug 2003 17:40:27 GMT

hpux-admins:

We are moving one old server's users and applications to another old server, to consolidate them on one server.

How do I find out who uses the old system and who doesn't.

I wrote a little script to "finger" each name in /etc/passwd:

awk -F: '{print $1}' passwd | while read USER
do
finger $USER
done

but it just spits out raw info:

Login name: lwwajeg In real life: Joe Gagor
Bldg: LPD Shippin
Directory: /home/lwwajeg Shell: /usr/bin/ksh
Last login Fri Jul 5, 2002 on ttypd
No Plan.

Login name: wiwakn In real life: Kumar Natarajan
Directory: /home/wiwakn Shell: /usr/bin/ksh
Never logged in.
No Plan.

Login name: a334hep
Directory: /home/a334hep Shell: /usr/bin/ksh
Last login Fri Aug 8 07:20 on ttypb
No Plan.

Can I summarize that somehow with "awk"?

What I want is something like, all on one line:

username home directory Last login

Stuart

Re: How do I identify/summarize active/inactive users?

Mark Greene_1 — Wed, 13 Aug 2003 17:44:00 GMT

See the man pages for last and wtmp

mark

Re: How do I identify/summarize active/inactive users?

James R. Ferguson — Wed, 13 Aug 2003 17:46:26 GMT

Hi Stuart:

Since 'finger' yields information, you have a 'var'adm'wtmp' file of last logins. A one-line summary analysis of last logings can be obtained with 'last'. See the man pages for more information.

# last

# last jrf #...look specifically for user 'jrf'

Regards!

...JRF...

Re: How do I identify/summarize active/inactive users?

John Meissner — Wed, 13 Aug 2003 17:51:18 GMT

you can use this script:

Re: How do I identify/summarize active/inactive users?

John Meissner — Wed, 13 Aug 2003 17:51:47 GMT

you can use this script:

Re: How do I identify/summarize active/inactive users?

Kent Ostby — Wed, 13 Aug 2003 18:55:58 GMT

Stuart --

Output your finger data to : users.raw
Add this line to your script as well:
awk -f formatu.awk < users.raw > users.report

vi a file called formatu.awk in whatever directory you are working and cut and paste the following awk script:

/^Login / {daname=$3;next}
/^Directory/ {dadir=$2;next}
/^Never / {dalast="Never"
printf("%-9s %-40s %-s \n", daname, dadir, dalast);
next}
/^Last login/ {dalast=$3" "$4" "$5" "$6;
printf("%-9s %-40s %-s \n", daname, dadir, dalast);
next}
Double check to make sure that the full printf lines are on one line in the file and that should do it.

Re: How do I identify/summarize active/inactive users?

Con O'Kelly — Thu, 14 Aug 2003 01:17:13 GMT

Hi Stuart

# finger -s
This gives you a summarised version & puts everything on one line.

One other point is that often wmtp files are cycled, This can mean finger is unable to get any info on a particular user if that user has not logged in since the wtmp file was cycled.
If you have a trusted system /usr/lbin/getprpw gives more reliable "login" information (look for "slogint" & "ulogint").
Unfortunately its a bit messing extracting the info you want.

Cheers
Con

Re: How do I identify/summarize active/inactive users?

Doug Burton — Thu, 14 Aug 2003 11:23:45 GMT

Stuart,

I hope this helps. Final output goes into the /tmp/UserStatus file.