Database log concepts

The database log is an interesting feature in AX. It gives you the ability to capture data manipulation as an audit capability. This could in inserting records, modifying records or deleting records. This can also be setup down to a field for example down to a specific field. This video gives you a overview of the concepts in the database log.

While this is an interesting feature for auditing capability use it sparingly because it is working at the data layer in AX so it does mean that for each database operation insert, update, delete etc. There needs to be a respective operation in the database log based on what you have configured. So consider monitoring activities like master file data etc and avoid high volume transactional tables.

As well there are some feature like in purchasing that have application oriented auditing feature like change control that might be worth investigating.

Cheers

Lachlan

3 responses to “Database log concepts

  1. Pingback: Sales transaction log – customers | OrganicAX·

  2. Pingback: Sales transaction log – customers - Microsoft Dynamics AX Community·

  3. Pingback: Sales transaction log – customers - OrganicAX - Microsoft Dynamics AX - AX User Group·

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s