torwin
2nd August 2004, 17:48
Hello,

We are currently trying to assess the usage of our customised sessions.
i.e. are the customisations we have peformed being used ?

In order to acheive this I am considering running bshcmd6.1
every, say, 10 seconds over a period of several weeks, formatting
and collecting the output. Then comparing that output against our ( huge )
list of customised objects, to find out with objects are not accessed.

Has any one else done an exercise like this ? Any tips ?

Thanks in advance

dave_23
2nd August 2004, 18:05
Better yet - turn on session history at the user level. then write a perl
prorgam to parse the $BSE/lib/TIME.HIS file and pull out the
sessions used and compare them with your list of custom sessions.

Dave

torwin
3rd August 2004, 16:20
Thanks for the reply Dave.

The only reservation I have about turning on the User History ... is that I thought it had a performance impact.

We have apprx. 700-1000 users on the environment at any one time.

dave_23
3rd August 2004, 17:22
BWU Performance subcommittee swears to me that it doesn't, i guess
baan must have fixed it in a 6.1c.06 series porting set.

One way around this would be parse, and truncate the logfile every hour or so...

Also, if it did hurt, it would affect startup of the bshell, if you're doing
a bshcmd on 700+ bshells every 30 seconds or so, then that's going to come with its own performance hit, and give you spotty data as well...

Dave

Markus Schmitz
4th August 2004, 08:53
I suggest like Dave, that you use the history. We turn the history on at all our clients by default and partially we are talking here about installations with up to 700 users.

The history entry is only written, if a user ends a specific session. So this is not so bad.

If you would go for bshcmd, then you would have to send one command to each bshell every other second. This would create much more load.

Regards

Markus

torwin
5th August 2004, 18:10
Thanks for the comments.. as a follow up to this.. is there a quicker way of
enabling "user history" for all users rather than going into each individual
user and putting a tick in the box.

I know that each users $BSE/lib/u<username> file contains a history parameter
which is either set to 0 ( off ) or 1 ( on ), is there a quick way of setting
all users history on either through UNIX or oracle ?

dave_23
5th August 2004, 18:47
off the top of my head... something like

cd $BSE/lib/user
for a in `ls -1 u*`; do
grep -v history $a > $a.1
echo "history:1" >> $a.1
mv $a.1 $a
done

torwin
5th August 2004, 19:26
Thanks Dave, but ... altering the ufile doesn't turn on the user history and I don't want to run create runtime on all users because there could be major ( unknown ) problems. As well as the history variable in the ufiles there is a history field in table ttaad200000. I am just taking a look now to see if the history can be enabled by setting both these values ( ufile and ttaad200000 field value ). If anyone knows anymore about this I would be glad to hear about it.

Thanks.

NPRao
5th August 2004, 19:39
You can just enable on the user data template. If you change the "u" files they can be overwritten whenever the users make change to their user data and do runtimes.

dave_23
5th August 2004, 20:22
Thanks Dave, but ... altering the ufile doesn't turn on the user history


Sure it does.. ttaad200 is just used to build the ufile, nothing else uses it. the ufile determines everything.

NPRao!
Looks like you missed the glory of user management in Baan IV!
no templates, etc.. all single user settings.

Dave

Markus Schmitz
6th August 2004, 08:39
I agree with dave. The ufile is all there is!!

To make it complete change the setting of the history bit with General tablke Maint. and use Davs's approach for the ufile.

avm204
18th August 2004, 06:52
Hi,

As u said, u want to check the usage of your customized session. U can create on table in BaaN with fields like User, date, time etc. and insert new record as soon as user open your customized session or after processing the session.

From that table u can create another report and get the necessary information of usage of report.

Regards,

ajay

jroberts
3rd September 2004, 18:38
I like AVM204's approach.
I have considered creating a baan table to do this as well.
One of the things I like about this is that you can sort \ retreive the data much easier than a log file.

I have thought about taking this approach one step further than just session usage.

A) For our customized reports, I am curious how users are using them, so logging the form selections that users have chosen would be interesting.

B) For auditing purposes, in Maintain \ Update sessions, you could easily audit who did what when into a history table.

I worry sometimes that our users do not know the 'best' way to run particular sessions. After analyzing the detailed logs of how users utilize a particular session, it would be easy to target specific training by user \ session.

John

NPRao
3rd September 2004, 21:22
This looks similar to the other thread -

How can I log Baan GUI users? (like "last") (http://www.baanboard.com/baanboard/showthread.php?t=16271&highlight=bms)

sikima
7th September 2004, 22:53
You can create quick Baan program to enable or disable history.

Select table ttaad200000, change flag and insert new record in ttaad400000 (this is trick).
When Baan convert in Runtime DD, it reads all records from there.

Convert in Runtime DD.

Entire process = 30 min :o