How To Setup Database Log in AX 2012 using manually/using X++ Code for single Table/using X++ Code for all Table.

using Manually:
step1 :  select System Administration -> setup -> Database -> Database log Setup

: 

Step2 : when you click you will see this -> click on new



Step3: you will popup with wizard database logging -> Click on Next



Step4: select you table from here -> then click on Next



Step5: select tick in insert ,update, delete, according to you requirement. it is basically when        someone  insert , delete or update any record it will show in log. -> after that click on next



Step6: it will show how many tables you have selected and what command you have selected



once it done then check your select table in same place setup -> database-> database log setup
here you can find all changes which you have done.

now go to -> inquery-> database log (here you can check all the logs.


using X++ code for one table

Static Void aks_DBlogging(Args _args)
{
TableId tableId = tableNum(InventItemSalesSetup);
    DatabaseLog log;
    SysDictTable dictT = new SysDictTable(tableId);
    SysDictField dictF;
    Set fields;
    SetEnumerator   se;
    log.logType = DatabaseLogType::Update;
    log.logTable = tableId;
    fields = dictT.fields(false,false,true);
    se = fields.getEnumerator();
 
    while (se.moveNext())
    {
        dictF = se.current();
        log.logField = dictF.id();
        log.insert();
        info(strFmt("Adding field %1", dictF.name()));
    }
    SysFlushDatabaselogSetup::main();
}

using X++ code for All Table


static void aks_DBlogging(Args _args)
{
   tableId         tableId;
    int             tablecounter;
    DatabaseLog log;
    SysDictTable dictT;
    SysDictField dictF;
    Set fields;
    SetEnumerator   se;
    Dictionary      dict = new Dictionary();

    for (tablecounter=1; tablecounter<=dict.tableCnt(); tablecounter++)
    {
        tableId = dict.tableCnt2Id(tablecounter);

     // TableId tableId = tableNum(InventItemSalesSetup);

     dictT = new SysDictTable(tableId);

    log.logType = DatabaseLogType::Update;
    log.logTable = tableId;
    fields = dictT.fields(false,false,true);
    se = fields.getEnumerator();
    while (se.moveNext())
    {
        dictF = se.current();

        log.logField = dictF.id();
        log.insert();
        info(strFmt("Adding field %1", dictF.name()));
    }
    }
    SysFlushDatabaselogSetup::main();
 
}