Hi All,

Is there a way to find when was the last time an user had logged in Baan (BaaN V / UNIX / Oracle) ?

Thanks in Advance.

Regards,
ST.

We have a freeware tool that you can try out that collects the user logins, along with their IP address and bw client versions, some other info, and a display session to show this to you. Information is stored in an ASCII flat file if you need this for other purposes.

Here's a post with some discussion on it:
Post about RMCis Client Information Tool (http://www.baanboard.com/baanboard/showthread.php?t=24401&highlight=Client+Information+Tool)

And here's a link directly to the download:
RMCis Client Information Tool (http://www.rmcis.com/tools.html)

If I remember correctly you can determine this by checking the access time of the .profile of the user.

Regards,
Han

Hi Han,

If I do not err then checking .profile didn`t work if a user connects to Baan with BW.

Regards,
Juergen

Hello,

For BaaN IV the log.licd6.1 logs all connexion and deconnexion.
We are processing this file and olg.licd6.1 every 4 hours to archive the last connexion date with a ksh routine:

cat /opt/baan/log/log.licd6.1 /opt/baan/log/olg.licd6.1 | grep "g...egistered fru1apx" | cut -c1-10,29,60-67 | awk '{FS="."} {print $1}' > /tmp/histo
cat /tmp/histo | awk '{print $2," ",$1}' | sort -u >> his.connexions
> /opt/baan/log/log.licd6.1
> /opt/baan/log/olg.licd6.1

Regards

Hi ,

Thanks for the inputs but I couldn't get much out these two files. Again my main motive is to find out those users who have not logged in for say last Six Months.

Thanks.
ST

If you keep the licd log files as the roll over and compare against the users you have in Baan, then you get a list of everyone who list as a Baan user who hasn't logged in (i.e., they don't have an log entry) in awhile.

I have done this in the past to keep license log files by month and then I ran qptool to extract the Baan users and then I processed them in a script.

Jürgen,

Du hast recht, leider funktioniert es nicht wenn mann bw benutzt.

M.fr.Gr.
Han

As of Oracle 8, you can use Logon and/or Logoff Triggers. These triggers can be used as an audit feature to collect what user logged on, or logged off at whatever time and date and store it to a table. We have been using one for quite some time now and it works as billed.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.