hi,
my users are keep login and not logout promptly . so, i need to make automatic time out policy. i am using GP10 SP2 .
please advice
*This post is locked for comments
hi,
my users are keep login and not logout promptly . so, i need to make automatic time out policy. i am using GP10 SP2 .
please advice
*This post is locked for comments
I am curious what SQL script you are running to actually delete the users that are Idle for say more than 30 minutes? I assume you are not just deleting the user from the DYNAMICS..ACTIVITY table.
Hi Rafeesh,
Can you send me the second step that you did after executing the script in the SQL Job?
Thanks,
Farman
You are welcome.
If your problem has been resolved, then mark this as a verified. Because this will helps to some others who having the same problem.
hi,
i went through Mr.Mahmoud querries to find who are idle in the system and created an application to delete the user who are idle more than 30 min in my system and schedule it to GP server to run every 15 min . its working fine. thanks to all.
By the way R2 released today!!!
Web Client has this feature as well in GP 2013.
There are also plenty of third party programs that can do this for you.
Have a look on the Rockton Software's GP Toolbox for auto-logout feature.
www.rocktonsoftware.com/.../dynamics-gp-toolbox
Also have a look on the below blog.
www.timwappat.info/.../Auto-Logout-for-Dynamics-GP
Hope this helps!!!
Have a look on the below blog from Mohammad R. Daoud. The SQL script contains will helps you to find the idle users and then we can create a SQL Job scheduler to delete those users with particular interval.
mohdaoud.blogspot.in/.../script-to-get-users-logged-in-to-gp_2325.html
If you have any doubt regarding the same feel free to contact me. I have done the same for one of my previous customer.
Email ID: soma.moorthy@gmail.com
Hope this helps!!!
Create a job in the sql server with the "activity" table in the dynamics database with your specific criteria and schedule it
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156