Logging all XMDBTool connection made from client and background process

The functionality to log all the incoming connections are now available in the Expense Management version 10.2.13. Logs are now available for all the connections created to the server using the XMDBTool client and the XMDBTool background process. This functionality helps in tracking all the commands that were executed using the XMDBTool client and the XMDBTool background process.

The alco_xmdbtool_log table contains the logs of the XMDBTool connection request. All the connections are logged automatically. The logs include the tenant information, the user information, the XMDBTool command and the source of XMDBTool command (client or bkgprocess) with the timestamp.

The Expense Management application now supports the functionality to delete data from the tables, if the data is older than a specified number of days. The number of days to retain the data can be specified in the xmdbtool.connectionLogs application parameter. For example if the value of the xmdbtool.connectionLogs application parameter is set to 10, then all the data older than 10 days are deleted.