Hello,

Baan IV c3
Informix version - 9.21-fc7

I need to know the list of all the users who have accessed a particular session in our Baan environment for the past 3 months. It would be bonus to see what changes have been made as well.

Advice me the procedure I need to follow. Can this be done using the available Baan tools ro do I need to fetch assitance from some Informix DB ppl?

Please help me in accomplishing this activity.

Thanks,
Kartik

if History is enabled for user in "Maintain user data" session then you could get it using session "Print user history".


Else set it - so that you could get it for future .

My requirement is specific to one session. I want to have the list of all the users who have accessed this session in the past 3months.

Checking this flag ON for the user would result in a log file,which would capture all activities with respect to all the sessions he accesses.

Btw, the flag is checked OFF presently.

Can it be possible from the database end, by checkin who all tried to update the fields on the table on which session was developed.


Thanks,
Kartik

I think this can only be achieved by writing some code in the program script.
You must generate a logfile by yourself.

An example could be:

logfile = "/tmp/session_history.log"
fplog = seq.open(logfile, "a")
logreturn = seq.puts( log.date & " " &
"Company: " & str$(company) &
"User: " & logname$, fplog)
logreturn = seq.puts("-------------------------------", fplog)
seq.close(fplog)

Thanks for you reply.

This is how I m gonna track the session usability from my now onwards.

I am actually looking for a way to track the list of users who accessed this session in the past 3months. I am sure its not possible from the baan tools end, but Is there any probability of gettin this information from the database stand point?

Is there any other way when the history checkbox is unchecked for all the users?


Thanks,
Kartik

Hi,

Another option is to see which tables the session that you want to trace updates.

If the table is set with Audit yes (run session ttaad4560m000 in c4 Display audit sequences) then the information regarding the user, the session, time, which fields he has modified, previus value, new value, etc etc is kept there by the Audit process of Baan.

Cheers,

Felipe