How to logoff a session at certain time interval

srinivas.chittem

Hai ,

This is srinivas. Here i have a small problem, even though it is small but it is challenging.

suppose i opened Navision DataBase with my UserId, menas here a session is created. Again i opened another Database by using Other UserId, menans totally two sessions created. I am using first one rather than second .

Here in the second session database calculates Idletime...

My intension is get that idle time, and that time reaches to 5min (for ex)
that session automatically logoff...

How can i get that idle time? what is the procedure to wirte the program that session should logged off after 5 min automatically?

Is there any functions are available in Navision to get the idle time?

please share your valuable ideas.....

Thanks & Regards,
srinivas.chittem

idiot

The logins are stored in a table called Session.
You can get the Idle Time form there

girish.joshi

There is also code in the Codeunit 1 Application Management that gets executed on logout.

nunomaia

If you are running SQL Server you can run a script to delete idle connections. Check http://www.mibuso.com/dlinfo.asp?FileID=367

kine

There are plenty of threads about that on this forum. Just search for Idle sessions or terminate session etc. to find them.

srinivas.chittem

Hai

I am not finding any SessionTable in Table Object (No table is named as Session ) Will you please give alternative idea to get the idle time of a session....

please it's urgent....


Thanks & Regards,

srinivas.chittem

NaviDev

its a virtual table. try to create a form and type this '2000000009' on the table. or just click File > Database > Information > Session Tab > Current Sessions. Click the Drop down button. and you will see the sessions table.

srinivas.chittem

Hai

i am creating a variable 'dur' type Duration..Acually the idle time of a system is in type duration ....

i am trying to assign 1 min to duration means

dur := 006000t;

but it gives typeConvertion error.....

what exeatly i tried ,

if idle time of a session is 1 min then session should be logged off

here i am getting comparision problem ....

please tell me your views..

thanks & regards
srinivas