We have been using Sugar for more than 6 years. We have audit log records that go back to the start of our use of Sugar. The Archive Data tool does not have the ability to archive audit tables. What is the best practice to remove older data from these…

Currently, the datetime is a standard MySQL datetime field. However, we have items that happen quickly and the datetime field doesn't reflect quick changes, especially in the _audit tables. Can we change the datetime to be datetime(3) which will capture…

Hello, is there a proper / safe way to enable the audit for modules that are not audited ? for instance, documents ? Many thanks, Fred

I am trying to manually update the audit table and I see a new field called event_id. What is this for?

Hi All, I have a Question that puzzles me very rarely this happen but does happen!!! So!, the record is not updated but the audit is recording it and cannot find anything that tells was an error? Does anyone know what is the ordering of saving data…

How can I show dropdown option value in the audit log if I don't have any dropdown option value? And Value is saved in the Database. Please suggest a solution to handle the audit log list.

Hi Friends, I want to create a new column (field) inside cases_audit table and store the IP address of users who has modified or changed the audited field. I am using SugarCRM community Edition 6.5.21 . Any input would be of great help. Regards, AKG

Hi everyone, I'm new with the SugarCRM and I have some difficulties... On the table "accounts_audit" I added two new columns that need to be filled with the value of a custom field. My intention is not to put this value on the field "Field_name", but…