web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Audit Reports
Microsoft Dynamics AX (Archived)

Audit Reports

(0) ShareShare
ReportReport
Posted on by Robert Tole 375

We do not have enough licenses to run the 'user permissions*' report.  We can only run the other permission reports for 1 user or group at a time.  This is too time consuming with 200+ users.

I have created a query using the USERGROUPLIST and USERINFO tables to show who has specific groups.

 I cannot find the tables that show the permissions for each group.  Can I create a report to show this detail?  What tables do I need to use?

 

Thanks,

Rob

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    The table you are looking for is a system table called:  AccessRightsList.  This will give you detailed information about permissions for each group.

  • Robert Tole Profile Picture
    Robert Tole 375 on at

    Bob,

    Thanks!

    Why are some fields blank in the ELEMENTNAME field?  I can't get this table to to tie against the user group permissions table.  Is there something I am not seeing?

  • Community Member Profile Picture
    Community Member on at

    The elementname will be missing on permissions set on tables.  Look at the "ID" field whenever you see a blank elementname.  

    The ID will correspond to the table ID.

    You should be able to link USERGROUPLIST to ACCESSRIGHTSLIST on groupID's.

    The accessType field in table ACCESSRIGHTSLIST will give you what permission each group have.  See these links:

     

    http://msdn.microsoft.com/en-us/library/aa875695.aspx

    http://msdn.microsoft.com/en-us/library/aa849536.aspx

     

    Hope this helps!

  • Robert Tole Profile Picture
    Robert Tole 375 on at

    It does, but I do not understand where to get the table id's from. Is there a table listing the tables?

  • Community Member Profile Picture
    Community Member on at

     Robert,

    Apologizes for getting back to you late.  What type of report are you attempting to write?  If it is an AX report, you can use tableId2Name function.

  • Robert Tole Profile Picture
    Robert Tole 375 on at

    Since we cannot run the 'user permissions*' report due to licensing.  I am creating two sql queries for auditing purposes.

     1. A list of users and their associated groups.

    2. A list of groups and their permission details.  (The user group permissions report can only run 1 group at a time.)

     I am not familar with the report writer in AX, so I though SQL would be best.

     

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    There is not a table that will list out table names and their id's that I am aware of.

    I think a good solution would be to create a custom table with this data.  Then you can write a small job that sweeps thru every table in AX, uses TableId2Name and then writes into that table. 

  • Robert Tole Profile Picture
    Robert Tole 375 on at

    Thanks!

     I will look into TableId2Name.

  • Community Member Profile Picture
    Community Member on at

     Robert,

    Take a look at this job I wrote:

    static void listTableId(Args _args)
    {
        #AOT

        TreeNode treeNodeTables = TreeNode::findNode(#TablesPath);
        TreeNode treeNode;
        ;

        treeNode = treeNodeTables.AOTfirstChild();

        while (treeNode != null)
        {
            info(strfmt("ID %1, Name: %2", tablename2Id(treeNode.AOTname()), treeNode.AOTname()));
         
            treeNode = treeNode.AOTnextSibling();
        }
    }

    This will list out the table ID's and their names.  Now all you have to do is create a custom table and modify this job to write into that table with this data.

    Note:  This will take a while to complete since there are many tables!

  • Robert Tole Profile Picture
    Robert Tole 375 on at

    I will.

     

    thank you!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans