19 February 2009

Who Has Been Logged in Too Long?

The MBS Guru was kind enough to take a small nugget of SQL code and turn it in to something useful. People occasionally ask "How can I figure out if people are logged in for too long?". Well, the Activity table in the Dynamics database holds the login date and time and The MBS Guru has taken that info and built the SQL code to use in a business alert in Dynamics GP. That way you can get notified if someone has been logged into GP for longer than a specified period.

I'll add a link to this in the SQL Repository as well. Thanks Guru!