Create User log file

vyanku · 2007-01-05

Can we create user log file which contains information login time,date and the information about the activity perform by user like which forms he opend,which table he access etc.?
How? :-k

ara3n · 2007-01-05

If you are on sql you can write the code on table triggers.

ssingla · 2007-01-05

edit.

vyanku · 2007-01-05

If you are on sql you can write the code on table triggers.

Is SQL then OK but I am using Native DB. and the problem of bigger logfile we can solve it by using restrictions setup.

But problem is IS it possible in native database?How can we identify that the user opened this form and that report?

ritz · 2007-01-05

I think your one problem can be solved by "Change Log" setup in the Native DB.(I think this is what u looking for!)
I am not sure whether we can keep the track of who opened which form or report.

vyanku · 2007-01-05

I think your one problem can be solved by "Change Log" setup in the Native DB.(I think this is what u looking for!)
I am not sure whether we can keep the track of who opened which form or report.

I know the change log setup bit it provides us only the date and time worked .I want to keep track on every user who opened which form or report.Is it possible in navision?

kriki · 2007-01-05

vyanku wrote:

I know the change log setup bit it provides us only the date and time worked .I want to keep track on every user who opened which form or report.Is it possible in navision?

Not that I know of. At least if you don't want to put some code in each report or form.

ritz · 2007-01-05

I know the change log setup bit it provides us only the date and time worked .I want to keep track on every user who opened which form or report.Is it possible in navision?

In the change log you have information about the userid also!! :-k is this what you do not want?

vyanku · 2007-01-05

I want all this information as will as the information that which from or report the user accessing ?

kine · 2007-01-05

Sorry, no such a tool exists. You can just :

1) Log the login and logout (standard just count the work time per day, but can be customized)
2) Log user data changes (Change log)

You cannot log the object manipulation (running form, report etc.) - or you can, but this will have big impact to performance. You can turn on Code coverage for all users (by code, customization) and let the codecoverage to login all code which is executed. You just needs to save these data to some table where they will persist logout...)

Create User log file

Comments

Categories