AX2012 End User - How to view list of the groups belong to the user

Finance and Operations/AX User Forum
1

Hi Guys,

Seek for your expertise and advise regarding this, since i have a lot of request to replace, assign and remove users group for the user. Thus, Is there anyway that I can pull out or view the list of user groups are belong to specific user ?

Many thanks for your kind assistance!

Please note:

  • I have System Administrator role and not developer of the system.
  • I’m currently view the list of user groups on “System Administration > Common > Users > User groups” and manually go through one by one group on the huge list of the groups to remove or add user inside (this have take me so much time consuming).

Hopefully someone would give a nice shot! Thanks!

2

I don’t see any inquiry or report to view user groups assigned to a user.

But you can get a developer to actually get this data from UserGroupList table.

Also use the existing method, \Data Dictionary\Tables\UserGroupList\Methods\groupsForUser

3

Hi Kranthi,

Thanks for your reply and suggestions. However, we are not work closely with developer nor vendor.

4

Then some one should be able to write a SQL query on UserGroupList table, to get the result.

5

Hi Kranthi,

Yes sure, Could you guide me on where can i run SQL query and what code should i run to get the details ?

Thank you.

6

Never mind, i thought you have someone to manage the SQL.

What you can do is export the table data to excel and can apply filter on the Excel data.

AOT-> Data dictionary → Tables → UserGroupList , then Ctrl + O

This opens the table browser. On the table browser press Ctrl + T - this will export the data into excel.

(Or) without browsing into the table, you can generate auto report on it.

Right click on the table → Add-Ins → auto report.

Click on select button to apply the filters, then click OK to generate the report.

7

Hi Kranthi,

Thanks for your kind assistance and advise. Unfortunately, I have no idea where the AOT located is. Thus, I unable to test the suggestion whether it work or not.

After do some exploring inside the System Administration > Area page, i have found a way I can easily get the list using below step:

  1. Go to System administration > Area page
  2. Under Periodic label, expand Database options and click on SQL administration.
  3. SQL administration window will popup, then expand All tables options.
  4. Scroll down to find UserGroupList table. Then, click on Browse table under top menu bar Table actions.
  5. Once Table browser window popup, press Ctrl + G to show search field.
  6. Fill up userId of the user and press enter, all the list of user group (groupId) belong to the user will show up. (you also can run SQL query statement inside the Table browser).

That’s it ! hopefully it will help others as well !

Thank you/

8

Dear Fairz,

During in AX, press CTRL+D will get you AX AOT (Application object tree)

7823.1.png

Regards,

CSBong

9

Hi CSBong,

Thanks for your advise! It works! Now i’m able to access to AOT to test on Kranthi suggestions!

Hi Kranthi,

Im able to try your suggestion, yes it exactly the same as i’m figure out and that’s it what i want. Thank you very much for your kind assistance on this! I’m so much appreciated it.

I have verified both your answer as the solution for my questions.

Thanks again,

10

You are Welcome

11

Hi Fariz,

You’re welcome.

Regards,

CSBong.