Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

How to get all companies user names and roles in AX2012

Posted on by

Hi All,

We are able to get the users list and roles from one company, but we have n-number of companies and need to get all users and roles from all companies from single code run instead of changing the company every time.

Is there any way to get the data from all companies , please advise.

Regards,

Akbar

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: How to get all companies user names and roles in AX2012

    Thank you Girish.

  • Verified answer
    GirishS Profile Picture
    GirishS 27,828 Super User on at
    RE: How to get all companies user names and roles in AX2012

    In that case you need an customization.

    Thanks,

    Girish S.

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: How to get all companies user names and roles in AX2012

    Thanks Girish, but the data is coming as user wise, not in the close to our requirement :

    User name   --  User roles  -- Company  --  Enabled

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,828 Super User on at
    RE: How to get all companies user names and roles in AX2012

    Yes, you can ran the report and export the report to pdf or excel.

    After running the report >> on the top right corner you have the option to export.

    Thanks,

    Girish S.

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: How to get all companies user names and roles in AX2012

    Thank you Girish,

    we have written a job to get the user details and associated roles in AX2012.

    You have suggested for D365FO like below :

    D365 FO - There is a report named User role assignments under System Administration >> Inquiries >> Security >> User role assignments.

    is it possible to get the details in Excel/PDF format like below in D365FO without writing a job as it will be very lengthy process to deploy to Prod and run the job , if we get the few columns related:

    User name   --  User roles  -- Company  --  Enabled

    Please advice.

    Regards,

    Akbar

  • GirishS Profile Picture
    GirishS 27,828 Super User on at
    RE: How to get all companies user names and roles in AX2012

    In D365 FO - There is a report named User role assignments under System Administration >> Inquiries >> Security >> User role assignments.

    If this report is available in Ax 2012 - You can filer the company records using Record to Include tab on the dialog form - You can add Company field as range to UserInformation table and add all companies.

    Thanks,

    Girish S.

  • GirishS Profile Picture
    GirishS 27,828 Super User on at
    RE: How to get all companies user names and roles in AX2012

    Check whether there is DataareaId field in SecurityRole and SecurityUserRole table. If yes, you can add the CompanyInfo table using DataAreaId as the relation.

    If there is no DataAreadId field then there is no possibility of adding company name to it.

    Thanks,

    Girish S.

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: How to get all companies user names and roles in AX2012

    Thank you very much Girish, got it now.

    Is it possbile to get the company name in the veiw, like with all company names.

  • GirishS Profile Picture
    GirishS 27,828 Super User on at
    RE: How to get all companies user names and roles in AX2012

    You need to add that fields from query to the view fields. If there are no fields in the view it will throw above error.

    Thanks,

    Girish S.

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: How to get all companies user names and roles in AX2012

    Thank you Girish,

    I just created a View using SysSecRolesForUser, when i am trying to open View it is throwing the below errror:

    You are not authorised to access table ‘UserRoles’ (UserRoles). Contact your system administrator.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans