Hi,
Configure and manage database logging AX 2012
Database Log setup for any table
Go to system Administration ->setup ->Database->Database Log Setup
After clicking Database Log setup you need to select your table if you are not getting your table then click on show all tables then you can get your table too.
Then Complete wizard as per requirement of enabling log for insert,update,delete on fields or table.
I want to suggest do not take all tables its will effect performance of ERP.
If log are not getting generated after setting all steps then you need to check table property and savedatapercompany should yes to work that.
But you can user savedatapercompany property only if your table is empty.
Recommended practices include the following:
You can delete database logs. You can select all logs for a particular table, specific types of database log, or a date and time that a log was created to delete.
1. Click System administration > Inquiries > Database > Database log. Click Clean up log.
2. Choose a method of selecting logs to delete by entering the table ID that they refer to, or the type of log, or the created date and time.
3. Use the Database log cleanup tab to determine when to run the log cleanup task.
View Database Log
1. System Administration --> Reports --> Database --> Database log
2. System Administration --> Inquiries--> Database --> Database log
3. Right click on any records which has database log setup --> Select Record Info --> Select record in Overview tab --> select history for that record --> there you can find previous value and current value
Reference
Reference
Reference
Reference
Reference
Configure and manage database logging AX 2012
Database Log setup for any table
Go to system Administration ->setup ->Database->Database Log Setup
After clicking Database Log setup you need to select your table if you are not getting your table then click on show all tables then you can get your table too.
Then Complete wizard as per requirement of enabling log for insert,update,delete on fields or table.
I want to suggest do not take all tables its will effect performance of ERP.
If log are not getting generated after setting all steps then you need to check table property and savedatapercompany should yes to work that.
But you can user savedatapercompany property only if your table is empty.
Recommended practices include the following:
Create a plan for how long you will retain logged data, and how you will archive or delete data.
- Limit log entries, and improve performance by selecting specific fields to log instead of whole tables.
- Consider increasing how often you perform SQL Server transaction log backups after you have configured database logging.
You can delete database logs. You can select all logs for a particular table, specific types of database log, or a date and time that a log was created to delete.
1. Click System administration > Inquiries > Database > Database log. Click Clean up log.
2. Choose a method of selecting logs to delete by entering the table ID that they refer to, or the type of log, or the created date and time.
3. Use the Database log cleanup tab to determine when to run the log cleanup task.
View Database Log
1. System Administration --> Reports --> Database --> Database log
2. System Administration --> Inquiries--> Database --> Database log
3. Right click on any records which has database log setup --> Select Record Info --> Select record in Overview tab --> select history for that record --> there you can find previous value and current value
Reference
Reference
Reference
Reference
Reference
Uadilsupp_yu_1990 Allison Reed https://wakelet.com/wake/ovCrfyYuav1vkK6xc7XHt
ReplyDeletebrilbuledoors