Is there a way to export change logs from the cases module?

We are trying to track how many times a case is updated from one state to another or when it gets reassigned. I can export the most recent case information, but so far I cannot find a way to locate the logs to export and report on. Does anyone know if this is possible?

The Change Log is not directly exportable from the UI. If you have Enterprise edition or above, you can create an Advanced Report where the query is pulling from the cases_audit table. Once you build your query and run the report, you will be able to export it.

Other than that, if you have direct access to your database, you can access that information within the cases_audit table.

How would I find out if I have the Enterprise edition? I believe we are running on version 6.7.12 (Build 14). I checked in our Reports and do not see an option to create a report from the cases_audit table.

If you click on the action menu where your User profile is, and select "About", you should see the edition. Alternatively, if you have Advanced Reports, within the Reports module's action menu you should see something called, "Advanced Reports".

Correct. You may want to check out the Sugar Exchange site to see if there are any SugarCRM Add-On applications that other developers have built to see if there is something that provides you with the features that you are looking for.

Having said all this... in 7.6 your best solution is probably to build yourself a custom API to get the information you need and call it from an external source that can manipulate the results and present them in whichever way you choose.

I have a couple of APIs that are called from Wolfram Language notebook (Wolfram: Computation Meets Knowledge ) where the data is subsequently manipulated with calculations and diagrammed for management perusal.