Hi

We have a number of users existing Baan. To trim this data we need to identify the active users say for the last 6 months. Does anybody has utility (shell script) to extract this data.

rgds

..... to extract this data.

rgds

Hi there,

to extract which data? If you havn't collected any, there is nothing to extract I'm afraid.
You might have a look at table ttaad320 in company 000, but here you will only find printjobs and most probably these won't reach back far into the past ... (if the tablename hasn't changed with LN, this is Baans spool history table in Baan IV)
Isn't one able to turn on monitoring on a M$ system, so all user activities will be logged?
Or start a batch job calling licmon6.2 every few minutes and collect the output.
Even on a unix box I couldn't think of any trick to access such data (which user was online at what time having run which program) for the past 6 month.

But I am interested if anyone has an idea :-)

good luck

Norbert

Hello,

Couldn't you run ttaad2402m000 - Print User History for the past six months and just identify users that didn't appear.

Cheers
Neal

Only if they're tracking user history (via the profile)

easier is to:
grep "registered" $BSE/log/log.licd6.X

this can only go back as far as your log.licd6.X goes though

Or start a batch job calling licmon6.2 every few minutes and collect the output.
grep "registered" $BSE/log/log.licd6.X

In LN the new licensing mechanism is handled by SLM (SSA License Manager) and there is no licmon6.2
Couldn't you run ttaad2402m000 - Print User History for the past six months and just identify users that didn't appear.
This works under the assumption you have turned on the user history in the user data templates and have not purged it.
Alternatively, since you are on Windows'2003 machine you can refer to these links to get the last user logon info -

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/bpactlck.mspx
http://www.microsoft.com/technet/scriptcenter/topics/win2003/lastlogon.mspx

Quote:
Couldn't you run ttaad2402m000 - Print User History for the past six months and just identify users that didn't appear.

This works under the assumption you have turned on the user history in the user data templates and have not purged it.


Fair point I knew I was missing something regarding this thread.

Cheers
Neal

Can a user be removed in Baan IV, SQL Server 2000. We have a lot of users who are no longer working with us. We create a user at the OS (W2000 Server) and then also at the DEM level. Run User Dialog, link to role. And dump user to Database.

I have been told that a user cannot be removed.

Can anybody advise me ?

Hi

We have a number of users existing Baan. To trim this data we need to identify the active users say for the last 6 months. Does anybody has utility (shell script) to extract this data.

rgds


Hello,
As your profile reflects, you're on MS$, there's no "shell script".
On Unix you may use last or lastb ?

Regards