Dynamics GP System and Setup SQL Code
- Change fiscal period names query to change fiscal period names
- Fiscal Years and Periods queries to find fiscal years and periods
- Security Details in GP 10.0 and 2010
- Security Roles and Tasks in GP 10.0 and 2010
- Security and SmartList Details in GP 10.0 and 2010
- SOP Email Setup in GP 2010 shows the status and format of the SOP email setup for each customers as well as the email addresses for the default bill to address
- User Activity in GP shows all the users logged in and a count of the batches, resources and tables each user has locked or open
Victoria, sorry to bug again. this script does not return all active users. What i need is a script to return all enabled users in GP
Thank you so much for all your help
Hi Victoria,
I want to ask a silly question. I need to run a script in SQL that will return all active users in Dynamics GP 2010. Please assist me,
Regards
Nish
Nish,
My SQL View for User Activity in Dynamics GP can help with this.
-Victoria
Nish,
Typically ‘active users’ means all users that are currently logged into GP. Is your definition something different? If so, can you please explain what your definition of ‘active users’ is?
-Victoria