Setup New table for database log

Goto system administration module



After that Database base logging Wizard will start


Press Next. On next page select “Not Specified” node of tree. All custom table/ user table will be placed under “Not Specified” Node. Dynamics Ax Default tables are placed under their respected module name.



Expend the not specified node.  And select the student table there.



Here you can track not only table but also possible you can track one or more fields of specific table. In current example we enable tracking or logging on whole student table.



Now question is how we can see what will comes in in sysdatabaselog table on insert update or delete on table.  You can view from this link




Point to be noted, that all the tables where save per company enables, all log files will be appears in their legal entities. Data is stored in table globally or for all legal entities, you can find their log files under default legal Entity “Dat”.
Now we explore the database structure of SysDatabaselog table. This will help us to get the logged information in X++ code.
Followings are some important fields of SysDatabaseLog table.

1. Table:  This filed contains the integer value for each table. A unique integer number attached to each table in dynamics Ax. This fileds tells us on which table operation is performed.
2. Creation Date: This contains the date and time on which entry in sysDatabaseLog is created.
3. Data:  X++ container type this contains the data.
4. LoggType: This described insert, update or delete operation is pefromed at the result current entry is done in sysDatabaselog. It is of enum type. DatabaseLogType::Insert