You are viewing limited content. For full access, please sign in.

Question

Question

Monitoring Data- SQL

asked on February 15, 2022 Show version history

I am attempting to pull the monitoring data per instance for completed reports on SQL, but I can't quite figure it out. Have any of you been able to pull this data?

 

I am looking for the following data: instance id, step name, step id, step status, start date, finish data, duration, action by, action; basically all the different data points that are in the monitoring module. 

Capture2.PNG
Capture2.PNG (25.33 KB)
0 0

Replies

replied on February 21, 2022

Attempting to pull the data, to graph on PowerBi. Found the following post, that got me the answer to my question:

 

https://answers.laserfiche.com/questions/191240/Laserfiche-Forms-Metrics--Tableau-Reporting

1 0
replied on February 15, 2022

The data you are looking for are stored in multiple tables: cf_bp_main_instances, cf_bp_worker_instances,cf_bp_worker_instance_history, cf_bp_steps, cf_submissions.

Can you share with us why you want to get these data with SQL queries? 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.