Business Dashboards: This option is intended to give users access to the generic dashboard tooling either to compose new dashboards or just to consume existing ones.

Process & Task Dashboard: It opens up the Process Dashboard perspective which contains several performance indicators related to the jBPM execution engine.

jBPM Count Processes: Retrieves the total number of process instances grouped by status.

        select total.processname, ifnull(total.instances,0) total,
        ifnull(active.instances_act,0) active,
        ifnull(completed.instances_compl,0) completed,
        ifnull(pending.instances_pend,0) pending,
        ifnull(suspended.instances_susp,0) suspended,
        ifnull(aborted.instances_abrt,0) aborted
        from
        (select pi.processinstanceid as pId, pi.processname as processname, count(*) as instances
        from processinstancelog pi group by pi.processinstanceid,processname) as total
        left outer join
        (select pi.processinstanceid as pId, count(*) as instances_act
        from processinstancelog pi
        where pi.status=1 group by pi.processinstanceid) as active
        on (total.pId=active.pId)
        left outer join
        (select pi.processinstanceid as pId, count(*) as instances_compl
        from processinstancelog pi
        where pi.status=2 group by pi.processinstanceid) as completed
        on (total.pId=completed.pId)
        left outer join
        (select pi.processinstanceid as pId, count(*) as instances_pend
        from processinstancelog pi
        where pi.status=0 group by pi.processinstanceid) as pending
        on (total.pId=pending.pId)
        left outer join
        (select pi.processinstanceid as pId, count(*) as instances_susp
        from processinstancelog pi
        where pi.status=4 group by pi.processinstanceid) as suspended
        on (total.pId=suspended.pId)
        left outer join
        (select pi.processinstanceid as pId, count(*) as instances_abrt
        from processinstancelog pi
        where pi.status=3 group by pi.processinstanceid) as aborted
        on (total.pId=aborted.pId)
        where {sql_condition, optional, processname, processname}
        order by processname
      

jBPM Process Summary: Retrieves data from all the process instances.

        select processinstanceid,
        processname,
        status,
        start_date,
        end_date,
        user_identity,
        processversion,
        duration
        from processinstancelog
      

jBPM Task Summary: Retrieves data from all the process tasks.

        select ts.taskid,
        ts.processinstanceid,
        ps.processname,
        ps.processversion,
        ts.taskname,
        ts.createddate,
        ts.enddate,
        ts.userid,
        ts.duration,
        ts.status
        from bamtasksummary ts
        left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)