0

I am struggling with a large database and try to find ways to reduce data mess. I really wonder why there is no scheduled job to delete old log entries from civicrm_log but this is not my question. Diving into this data I found out that there log entries created everytime an activity was created or updated. But it seems to me that these logs are never shown to admin in the backend?! For contacts there is a tab for the logs but for activities I could not find any page where the logs for an activity are listed.

Is there a way to avoid log creation for activities? Is there any way to list these logs to users or what is the reason to create these logs?

1

Under Administer - CiviReport - Create Report From Template there is one called "Database Log Report". That shows you more or less what's in civicrm_log.

For advanced logging (at Administer - System Settings - Misc - Logging), which I don't think is what you're talking about but just in case, the lack of an activity report is a known issue. The advanced logging Contact logging report does not always show proper logs for non-Contact records.

  • Thank you... so if I do not use this report I do not really need these logs, is this correct? – Tobias Krause Jul 22 '20 at 17:38
  • There are some places that use them to determine the history and who created a record, like civicase, or I think for example the "Date added" custom search for contacts, but at worst it should just show blank if you don't care about that. You can back up that table first before truncating it if you want to be careful. – Demerit Jul 22 '20 at 17:56
  • 1
    Just to let you know: I checked if the custom search by "Date added" still works when activity related logs are deleted from civicrm_log and it does. – Tobias Krause Jul 23 '20 at 8:07
  • Cool. Yes that one would only depend on the contact records. – Demerit Jul 23 '20 at 10:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.