01-27-2012
Can you give us some figures related to the scale of your problem?
How many users in /etc/passwd ? Or are you also interested in deleted users?
How many day-to-day users?
How big is this wtmpx file ? Size unformatted and number of lines formatted?
How old is this wtmpx file? (Look at the first few records with fwtmp).
How powerful is the computer?
My usual approach is to break the wtmpx file into separate years and then use "last -f filename" in descending year order until we find the real last login. Obviously the day-today active users will be in this year's file by now. The "last" program itself reads wtmpx files backwards which is why it is so fast for active users.
We would use the "-n 1" parameter to "last" because we are only interested in the last login (this saves a lot of processing).
As your project design evolves, will you be running this report regularly? If so, it would be a good idea to consider starting a new wtmpx file regularly (and keeping the history if you need it) or even using a simpler system of recording the last login in the user's home directory.
I prefer the system of recording the last login in the user's home directory and then locking the account after 3 months non-use - or immediately if the user leaves the company. Unless your system allows significant disc space usage in user home directories there is no harm in just locking the account rather than deleting it. That way you will never get two different people with the same login account name and simple mistakes like Maternity Leave are easy to fix.
Last edited by methyl; 01-27-2012 at 06:56 PM..
9 More Discussions You Might Find Interesting
1. Web Development
Hello,
I have created a web page on a server using apache and added .htaccess and .htpasswd in the folder for authentification.
I was wondering if there was anyway to tie-in the login for this page with the login used to logon to the server.
i.e. the same login info. is used for both,... (2 Replies)
Discussion started by: WhotheWhat
2 Replies
2. Cybersecurity
Hello,
I have created a web page on a server using apache and added .htaccess and .htpasswd in the folder for authentification.
I was wondering if there was anyway to tie-in the login for this page with the login used to logon to the server.
i.e. the same login info. is used for both, when... (1 Reply)
Discussion started by: WhotheWhat
1 Replies
3. Shell Programming and Scripting
Friends ,
With "last root | head -1 " command , we can find the last loging date and month . But i want to find last login year.
Help me if u have any idea regarding this issue.
Thanks
AVklinux (3 Replies)
Discussion started by: avklinux
3 Replies
4. HP-UX
Thanks
AVKlinux (4 Replies)
Discussion started by: avklinux
4 Replies
5. Solaris
Thanks
AVKlinux (10 Replies)
Discussion started by: avklinux
10 Replies
6. Shell Programming and Scripting
Hello,
We have a requirement of finding which users logged into a UNIX (Solaris) box and how many times they logged in so far and their last login.
I used "last" command in my script and got everything fine but not able to capture the "year" of date/time of the users' login. Looks like "last"... (2 Replies)
Discussion started by: prvnrk
2 Replies
7. Solaris
Hello World ~
HW : SUN Fire V240
OS : Solaris 8
Error message prompts 'rmclomv ... SC login failure ...' on terminal.
and
Error Message prompts continually 'SC Login Failure for user Please login:' on Single Mode(init S)
The System is in normal operation, though
In case of rain, Can... (1 Reply)
Discussion started by: lifegeek
1 Replies
8. AIX
Hi Friends
I have a query. we had a requirement to see the last login details of our users so I ran the command last <username> and the output i get is:
wtmp begins Apr 17 21:48
Now I need to know couple of things:
1. How can I see the year this log is being read from wtmp file
2. Is... (4 Replies)
Discussion started by: nathandrake13
4 Replies
9. UNIX for Advanced & Expert Users
Hey folks,
When a user is added to a new group, the user has to be log out and log in again to make the new group effective. Is there any system command or technique to refresh user group ID update without re-login?
I am not talking about to use "login" or "su -l" commands which can only make... (2 Replies)
Discussion started by: hce
2 Replies
LEARN ABOUT XFREE86
wtmpx
utmpx(4) File Formats utmpx(4)
NAME
utmpx, wtmpx - utmpx and wtmpx database entry formats
SYNOPSIS
#include <utmpx.h>
/var/adm/utmpx
/var/adm/wtmpx
DESCRIPTION
The utmpx and wtmpx files are extended database files that have superseded the obsolete utmp and wtmp database files.
The utmpx database contains user access and accounting information for commands such as who(1), write(1), and login(1). The wtmpx database
contains the history of user access and accounting information for the utmpx database.
USAGE
Applications should not access these databases directly, but should use the functions described on the getutxent(3C) manual page to inter-
act with the utmpx and wtmpx databases to ensure that they are maintained consistently.
FILES
/var/adm/utmpx user access and adminstration information
/var/adm/wtmpx history of user access and adminstrative information
SEE ALSO
getutxent(3C), wait(3C)wait.h(3HEAD)
SunOS 5.10 22 Feb 1999 utmpx(4)