5,195
hi,
i was using the below querry to find the idle time for current gp users when i was using gp10 version (SQL server 2005). but when upgraded to gp2013 the idle time is showing zero (sql server 2014).please advice
*This post is locked for comments
The link got changed at some point, my apologies, this updated link should work:
http://www.timwappat.info/post/2015/10/30/Inactivity-Auto-Logout-for-Dynamics-GP-part-II
I have updated the link in the original post.
@tim wappat: i just went through your link but its not working in my browser."Server Error in Application "TIMWAPPAT.INFO"....like is www.timwappat.info/.../Inactivity-Auto-Logout-for-Dynamics-GP-part-II.
still i am searching the auto logoff application or querry for idle user in GP2013
I will definitely look these links.:)
Read my three posts on auto logout and the user messaging process in the GP client, although this is in the context of writing a plug in, it will give you an understanding of the behaviour you are seeing.
http://www.timwappat.info/post/2015/02/18/Check-for-User-Messages(1)-Dynamics-GP-Process-Monitor
http://www.timwappat.info/post/2015/10/30/Inactivity-Auto-Logout-for-Dynamics-GP-part-II
http://www.timwappat.info/post/2013/08/23/Auto-Logout-for-Dynamics-GP
Tim
[View:http://www.timwappat.info/post/2015/10/31/Inactivity-Auto-Logout-for-Dynamics-GP-part-II:750:50]
Please be inform you that as mr.tim informed the idle time is not reading in GP2013 (sqlserver2014 db)something is happening. it was working perfect in GP10 (sqlserver2005).my intention is to auto logout the idle user. please anybody help me
Btw Ali did your dynamics database for gp 2013 named dynamics or something else (like DYNAMICS2013) just asking in case you have multiple instances on your sql server.
Hmmm but it's showinng me the time on my server and I don't think it's something because of gp 2013.
Almas,
I'm suggesting, that perhaps a reason for the idle time showing zero (from the original question), is that the application is polling (asking) the database with a SQL select query every minute, to check the messages table for messages to pop up on the client machine (the change time message does not come from the database, it is in process).
In previous versions of GP this process did not exist, less was running in the background, so the database connection idle value would have represented more closely a user idle time.
I'm not discussing the functionality of the user messaging itself merely highlighting the impact its existence is going to have on idle times in the database.
Tim
Tim what if user is not login, lets say user 'almas' is not login and user Tim don't aware of it and save some message for almas in table 'SY30000'? I don't think table will refuse to save message for user 'almas' because she is not login to gp? then process will check and if found user login pops the message irrespective of the fact user is doing anything or not. I think it's a different scenario here. For Example system don't bother if use is idle or doing anything, it just pop up date changing message for user if he found user in session.Just a thought..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (