Dynamics Community Forum Thread Details

NO ACTIVITY USERS

I need detail of GP users who logged in GP but they are not doing anything for last 1 hour in GP. Can you help me to find out is there any table record this detail. In my case GP users should not allow to loggin and keep the instance open without doing anything, they must loggout if they do not want to use GP. it is not USER ACTIVITY table, because it will not give you whether this person doing anything on it, it give loggin time and company details. It is not SQL profiler.

Otherwise I need to cut the users connectivity if they are not using GP for last 1 hour automaitcally by using some SQL trigger

Regards,

Noushad

Hi Noushad

Sounds like you need the Inactivity Timeout feature of the Omni Password module of the Omni Tools suite.

This is a product I initially wrote, but is now sold by http://www.rocktonsoftware.com.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

The links in this message may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.

Quick Links