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 / Finance | Project Operations, Human Resources, ... / Database log over User...
Finance | Project Operations, Human Resources, ...
Unanswered

Database log over User information

(0) ShareShare
ReportReport
Posted on by Community Member

Client wants to Capture changes made (added, changed and deleted) in  AX users (Table SysUserInfo / Userinfo) and also added/deleted user-Group relations (Table UserGroupList). I define the logging for these tables in Database Log Setup but changes are nod captured into log.

Checking in AOT or SQL side records are created and deleted in these table, but Database Log do not capture the changes. What might be reason for this behaviour?

Other tables logging ( InventTable for example) works fine.

I have the same question (0)
  • Brijen S. Shah Profile Picture
    Brijen S. Shah 292 on at

    Hi FredViidul,

    This is a standard functionality of AX. Moreover UserInfo table is a system table so you cannot make any changes on this table to enable CreatedBy, CreatedDateTime, ModifiedBy and ModifiedDateTime.

    You can customize SysUserInfoDetail form and add your code to write method of UserInfo dataset and SecurityRole dataset.

    Regards,

    Brijen S. Shah

  • Community Member Profile Picture
    Community Member on at

    Yes Database log is standard functionality - my question is why this standard functionality do not work?

    If I switch it in for UserInfo / UserGroupList, Database log does not record any changes I made in these tables :(

  • Brijen S. Shah Profile Picture
    Brijen S. Shah 292 on at

    Hi FredViidul,

    Sorry but I don't understand how are you making changes on UserInfo / UserGroupList tables as there are System Objects and cannot be changed.

    Regareds,

    Brijen S. Shah

  • Community Member Profile Picture
    Community Member on at

    Why you think I want to change system objects - I do not?? Regarding changes, mentioned in initial question, I mean new, deleted or changed recors in the tables.

    I want to use standard Database log over these tables and it does not work - I'm asking If anyone knows why this functionality do not work with UserInfo / UserGroupList tables? As simple as that!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,182 Super User 2026 Season 1 on at

    Hi Fred,

    Some global system tables do show log values only in the DAT company. Have you tried switching to the DAT company? It has been a long time ago since I got this question. I do recall indeed some drawbacks on the table(s) you mention.

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 681

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 446 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 202 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans