Download process report

hello.aliasad · February 19, 2021, 3:17pm

Hi we have camunda enterprise edition. Is there any way we can download the history report of processes from camunda in csv or excel form?

Yana · February 19, 2021, 3:30pm

Hi @hello.aliasad,

In case you have an enterprise license, I recommend you to create a Support ticket.
Otherwise, please explain in more detail what are you trying to achieve.

Best,
Yana

hello.aliasad · February 21, 2021, 10:29am

Thanks Yana for replying. We wanted to download the report of all process instances. For example, what time a process started, what option did the user select manually. Is there a way we could download the reports in csv form?

Yana · February 23, 2021, 9:42am

Hi @hello.aliasad,

The Rest API (Java API as well) offers the following reports (responses are application/json):

Historic Activity Statistics - retrieves historic statistics of a given process definition, grouped by activities. Link: Get Historic Activity Statistics | docs.camunda.org
Process Instance Duration Report - retrieves a report about the duration of completed process instances, grouped by a period. Link - Get Process Instance Duration Report | docs.camunda.org

Further historic data can be fetch from the database. Database schema: Database Schema | docs.camunda.org

process instance start time - table ACT_HI_PROCINST, column START_TIME_
what option did the user select manually - I am assuming that you are referring to process variables, they are stored in ACT_HI_VARINST table.

I hope that helps.

Best,
Yana