Search code examples
axaptacdc

Capturing User who deleted record using CDC. SQL DYNAMICS AX

I want to Capture the Username who deleted the record . But CDC does not track who deleted record. Can you tell me how to acheieve this????

Solution

  • You can use database logging for tracking specific types of changes to AX tables and fields. Changes that can be tracked include insert, update, delete or rename key. 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.

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