# SQL view for user activity in Dynamics GP | Victoria Yudin

- URL: https://dynamicaccounting.net/sql-view-for-user-activity-in-dynamics-gp-victoria-yudin/
- Date: 2011-09-14
- Topics: SQL & Data, Install, Upgrade & Admin
- Type: link to an external article
- Source: https://victoriayudin.com/2011/09/12/sql-view-for-user-activity-in-dynamics-gp/

Victoria brings us a new [SQL view for user activity in Dynamics GP.](https://victoriayudin.com/2011/09/12/sql-view-for-user-activity-in-dynamics-gp/)

“…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.”

Very Nice.