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
Thank you Girish.
Thanks Girish, but the data is coming as user wise, not in the close to our requirement :
User name -- User roles -- Company -- Enabled
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
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.
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.
Thank you very much Girish, got it now.
Is it possbile to get the company name in the veiw, like with all company names.
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.
#1
André Arnaud de Cal...
292,492
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
