SQL view for user activity in Dynamics GP

There are many different pieces of code that I have seen for this over the years, but more often than not what our users ask me for is a way to quickly see who is logged into GP, what company, and when did they log in. While this can easily be seen on the User Activity window ( GP | Tools | Utilities | System | User Activity ), many users do not have access to this window and sometimes this need arises when someone is either not able to get into GP or does not want to take the time to do so.  Below is a view to show all the users logged in and a count of the batches, resources and tables each user has locked or open. Please note that this code will not show details of what the users have locked or open, just the counts. The idea behind this is that if a user has something locked, you may not want to simply delete them out of the ACTIVITY table, because those resources, tables or batches will still be locked by the user. This code can also be helpful to monitor users who are not logging out of the system at night or have multiple companies open.

Continue Reading:
SQL view for user activity in Dynamics GP