How to verify what modifications on process were made by particular user?

Camunda 7 Topics Discussion & Questions
,
1

Hi,
i’m facing an issue where i need to verify (manually in cockpit or just query in data base, doesn’t matter) what modification on process did particular user made manually in cockpit. I couldn’t find such option in cockpit, maybe i missed it somewhere?
I’m interested in information:
time stamp + user id + process instance id + Operation type + property + old value + new value + activity ID

I’m aware that i need to join both runtime and history tables but i’m not sure which ones should be joined with OP_LOG and on which attribute should i match them.

Could you support me on this one?

Cheers,
C.

2

Hello,

Could you give some examples of what does modification on process mean for you?
Maybe this query will be helpful for you - https://docs.camunda.org/manual/latest/reference/rest/history/user-operation-log/get-user-operation-log-query/
Within the last alpha release 7.9.0-alpha1 we introduced Manual User Operations in Cockpit (enterprise version).

Hope that helps.

Best regards,
Yana

3

Hi Yana,
by modification on process i mean moving activity token from one activity to another, as a result i would like to see which activity was canceled and which started by particular user.

About this query you linked, when i searched for particular user operations, it caused NPE (i’m logged in as admin):

java.lang.RuntimeException: java.lang.NullPointerException
	org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:61)
	org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:56)
	org.camunda.bpm.webapp.impl.security.SecurityActions.runWithAuthentications(SecurityActions.java:38)
	org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:56)
root cause

java.lang.NullPointerException
	java.io.Reader.<init>(Reader.java:78)
	java.io.InputStreamReader.<init>(InputStreamReader.java:72)
	org.camunda.bpm.webapp.impl.filter.AbstractTemplateFilter.getWebResourceContents(AbstractTemplateFilter.java:92)
	org.camunda.bpm.webapp.impl.engine.ProcessEnginesFilter.serveIndexPage(ProcessEnginesFilter.java:230)
	org.camunda.bpm.webapp.impl.engine.ProcessEnginesFilter.serveIndexPage(ProcessEnginesFilter.java:160)
	org.camunda.bpm.webapp.impl.engine.ProcessEnginesFilter.applyFilter(ProcessEnginesFilter.java:110)
	org.camunda.bpm.webapp.impl.filter.AbstractTemplateFilter.doFilter(AbstractTemplateFilter.java:42)
	org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilterSecure(SecurityFilter.java:67)
	org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilter(SecurityFilter.java:51)
	org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:59)
	org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:56)
	org.camunda.bpm.webapp.impl.security.SecurityActions.runWithAuthentications(SecurityActions.java:38)
	org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:56)

Therefore i’m more interested in SQL query to find user operations. Could you point me to DB tables which should i join to see this?