i want to calculate idle time for particular user navision in cal .
how we can calculate how much time my session was idle or any user session is idle ?
in navision2013 on-words .
*This post is locked for comments
follow
community.dynamics.com/.../125051
www.olofsimren.com/kill-sessions-in-dynamics-nav
www.uxceclipse.com/set-idle-client-timeout-period-dynamics-nav
saurav-nav.blogspot.co.at/.../nav-three-tier-auto-kill-idle-session.html
There are setting you can operate with in order to kill idle sessions for some period. Please follow Understanding and Configuring Session Timeout: msdn.microsoft.com/.../dn584639(v=nav.71).aspx
This might be also helpful: robertostefanettinavblog.wordpress.com/.../nav-services-sessions-counting-killing-timeout
As far i know i don't there are built in functions to calculate idle time for a user, you might need to check the session event table and calculate based on the event date.
hi sir thanks for reply
this is not i want ,
i want to calculate idle time for any particular user or session in cal in navision2013+
HI sir ,
Session table i am gating only log in datetime for any session but i cant get that session how much time idle from login .
i want to calculate how much time user is not active from login time that activity or registered time of activity session i am not gating in navision till now .
Check this link
stoneridgesoftware.com/how-to-create-a-kill-session-or-idle-session-timeout-in-nav
I do not think there is builtin function to achieve what you want. In that case what I would do is, I would write a stored procedure in SQL to return idle time for users and from C/AL call that SP.
Hi Bhagwan,
We're looking for this for more than 3 years. Until Microsoft supports it as a native function like GLOBALLANGUAGE, COMPANYNAME, USERID, SESSIONID... We haven't seen it available with CAL.
You need a special way as our tool community.dynamics.com/.../idle-session-management
Dear Bhagwan ,
There are no function to calculate user wise idle time , NAV only give Idle user time out nothing else ,
But if you looking for the critical reason or mandatory requirement ,
you can use "Change log Entries" and get the count of user active time period
Further you can deal with Change log Entries table on DB level and make triggers to capture user active time and idle time period(NOTE : please get some additional help from DB admins before you doing this )
because this will be highly effect to your data base and the system
Please verify the answer if you got help to resolve your issue
@maneesha: really nice idea, but change log should only be used to log changes of master data. so if adding logging for productive data, then it could decrease performance very badly.
as an idea, if you do that, use e.g. some of the ledger entry (g/l entry, item ledger entry, customer/vendor ledger entry, ...) tables to log the user activities and in the change log setup log only one field per table.
best would be to cover the issue with a trigger in the sql database. better for the performance.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Saurav.Dhyani 2 Super User 2025 Season 2
RK-25090803-0 1
