Generate List of Users per Company in GP 10

(0) Share

Report

Posted on by Community Member

Is there a way to get a list of all users in GP 10 and the companies they have access to exported to a file? I can get all the users using a SQL query, but I also need to have the company break down as well. Thank you

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report

RE: Generate List of Users per Company in GP 10

Also, if you own eOne's SmartList builder, you can grab a set a of reports to import into SmartList here from a fellow GP blogger :

waqasb.blogspot.ca/.../dynamics-gp-security-smart-lists.html

This will allow you to generate quickly some reports in GP without relying on SQL views / queries, if you don't have access to those tools.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (2)

Report

RE: Generate List of Users per Company in GP 10

Check this out SQL view to show security roles and tasks in Dynamics GP by Victoria Yudin

Your feedback is highly appreciated,

Was this reply helpful? Yes No