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.
You can have a look at the existing reports in Administration Module
Security → User permissions.
Security → User Group permissions.
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”,
THEN ‘No Access’
WHEN ARL.ACCESSTYPEFKEYUSE = 1
WHEN ARL.ACCESSTYPEFKEYUSE = 2
WHEN ARL.ACCESSTYPEFKEYUSE = 3
WHEN ARL.ACCESSTYPEFKEYUSE = 4
dbo.USERGROUPINFO UGI INNER JOIN dbo.ACCESSRIGHTSLIST ARL
ON UGI.RECVERSION = ARL.RECVERSION
INNER JOIN USERINFO UI
ON ARL.RECVERSION = UI.RECVERSION
Is that any existing custom reports that contained AX Security?
Many thanks in advance for your help.