How to retrieve a List of Roles and which SSRS Reports can be run by the role (using x++)

Hi Dax team,

Is there a way using x++ to list roles in an excel sheet and the corresponding report/reports that can be run using the role.

Somewhat like 2 columns in excel - Roles and SSRS reports

Thanks in advance

Hmm, what about changing the requirement a bit? What you configure security for are not reports, but menu items. So… what about generating a list of output menu items?

Or how do you plan to match roles with reports?

[mention:64fb33d4ab384f5ebca3050a0d9ca94f:e9ed411860ed4f2ba0265705b8793d05] Yes, That is the perfect suggestion. So could you help me getting the list of Roles and the output menuitems they can access? How can we achieve that?

To be honest, I don’t remember how exactly it worked in AX 2012. But here are a few things to consider:

  • Use temporary tables populated by SysUserLicenseMiner, which is what Named User License Counts report does. Here is an example. I personally used this approach in past.
  • Look at the logic behind Security tools > View related security roles.
  • Get the data from Security Development Tool. You asked for X++ code, but maybe SDT will give you what you need even without coding.