Audit Reports

(0) Share

Report

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)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Robert Tole 375 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Robert Tole 375 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Robert Tole 375 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Robert Tole 375 on at

Like (0)

Report

Thanks!

I will look into TableId2Name.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Robert Tole 375 on at

Like (0)

Report

I will.

thank you!!

Was this reply helpful? Yes No

Community site session details

Audit Reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Audit Reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates