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

Notifications

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... 301,075 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans