How do I record User changes in the database log?

(0) Share

Report

Posted on by Community Member

I have set up the recording of user deletions but would also like to record changes to user details such as the addition or removal of security roles.

For user deletions I selected table "User Information" and clicked Delete.

For user changes I tried selecting the same table and clicked Update but no changes are being recorded.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You could take a look at the database logging feature of Dynamics AX. But be warned, if you really want to track all data changes,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I am using database logging. I just need guidance on how to record user changes.

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please follow the below link it will guide u better,

http://floditt.blogspot.fr/2011/08/simplify-tracking-changes-with.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It looks more complicated than using the AX GUI.

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use database logging for tracking specific types of changes to AX tables and fields. When you configure logging for a table or field, a record of any change to that table or field is stored in the database log table, sysdatabaselog, in the AX database.

You can use the Logging database changes wizard to set up database logging. The wizard provides a flexible way to set up logging for tables or fields.

Click System administration > Setup > Database > Database log setup. Click New to start the Logging database changes wizard.

Complete the wizard

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes I've set up database logging before.

Just need help with recording user changes.

Was this reply helpful? Yes No
Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

hi,

Please find the below link:

https://kaya-consulting.com/how-to-rename-records-in-ax7/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

That's not a relevant link.

Under "Database log setup" I have set "Security user role" on for Delete and Insert but when tested the log entries don't identify either the user or role being deleted/inserted.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

A similar question was discussed in an older thread: Database Log - changes to security roles being audited?.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin, I've downloaded the XPO and will see if it works for me.

Was this reply helpful? Yes No