Hi,

How to find the user last login time to the application. Through which log file can we found it.
Please suggest.



Regards,

The file $BSE/lib/TIME.HIS stores the user login time and details of the sessions accessed.

The history flag should be checked in the User data template to enable the logging of the information.

This gives the details of the user who have logged into the application. There may be few users who never logged into the application since 2 0r 3 months. I need this info.


Regards,

Hello,
At unix side, you can use last command to see all the history of users who have accessed to the system.
By example, I use the command:
# last -1 user_ID

to see the last time when the user have accessed to the system. If the user not appear, means that the user never accessed to the system.

Hope this helps.

Hi,

I am working on OS AIX 5.3 with Oracle 10g DB and Appltn. ERPLN FP2. I have checked for time last login of the user with the below commands before posting this thread:

1.#lsuser -a time_last_login <userid> ---- which reads info from /etc/security/users file.

2. #last -n 10 and #last <userid> console and also with the below script. This will read info from /var/adm/wtmp file.

USERS=`grep -v NOLOGIN /etc/passwd | cut -d: -f1`
for USER in $USERS
do
echo "-----------$USER---------"
last -n 4 $USER
done

From the above, i am getting info only for those users were 'menu browser' is checked in 'User Data'. I am not getting the info of the users were 'process browser' is checked.

So, please suggest & advice me the best way to get the info.

Thanks in advance

Regards,

Hello,
As another approach if last command not work is to query the file log.licd6.1 in the directory $BSE/log

On that file all the user logins will be registered not matter what user menu.
Using awk you can get the info that you need.

2010-03-04[12:51:01]:I:root:
2010-03-04[12:51:01]:I:root: ******* S T A R T of Information message *******
2010-03-04[12:51:01]:I:root: Log message called from /BAAN/view/port.6.1c.07.20/vobs/tt/licence/licd.c: #1438 keyword: licd
2010-03-04[12:51:01]:I:root: Pid 4611 Uid 0 Euid 0 Gid 0 Egid 0
2010-03-04[12:51:01]:I:root: user_type S language 2 user_name root tty locale ISO88591/NULL
2010-03-04[12:51:01]:I:root: Errno 0 bdb_errno 0
2010-03-04[12:51:01]:I:root: Log_mesg: unregistered xxx.xxxx:jgarcia1.18153
2010-03-04[12:51:01]:I:root: ******* E N D of Information message *******


Hope this helps.

Hi,

Thanks for your effort.
As per my application it is lod.bic6.2. I think instead of that, log.ipc_boot6.2 will helps a lot.

Regards,