AX2009 Custome Report for AX User security

Finance and Operations/AX User Forum
1

Hello Everyone,

I have a question and cloud that i did not know the answer.

Would be possible to create a custome report AX2009 that contained user security

How to create a custome report that listed AX2009 Users security such as:

---- User name

— AX Groups

— Access Level

— Company, Etc.

Any input and help are very appreciated.

Thank you.

Edwin

2

You can have a look at the existing reports in Administration Module

  1. Security → User permissions.

  2. Security → User Group permissions.

3

I did review and present those reports to Finance teams.

The AX Artichec wanted a custom report for displaying AX User permissions.

So I wrote a simple T-SQL test query:

SELECT DISTINCT top 10 UI.COMPANY, ARL.DOMAINID, UI.NAME AS “AX Users Name”, UGI.NAME AS “AX GROUPS”,

CASE

THEN ‘No Access’

WHEN ARL.ACCESSTYPEFKEYUSE = 1

THEN ‘View’

WHEN ARL.ACCESSTYPEFKEYUSE = 2

THEN ‘Edit’

WHEN ARL.ACCESSTYPEFKEYUSE = 3

THEN ‘Create’

WHEN ARL.ACCESSTYPEFKEYUSE = 4

THEN ‘Full’

END

AS ACCESS_LEVEL

FROM

dbo.USERGROUPINFO UGI INNER JOIN dbo.ACCESSRIGHTSLIST ARL

ON UGI.RECVERSION = ARL.RECVERSION

INNER JOIN USERINFO UI

ON ARL.RECVERSION = UI.RECVERSION

Questions:

Is that any existing custom reports that contained AX Security?

Many thanks in advance for your help.

Regards,

Edwin