jBPM Process Node total hits

NodeHits.sql

select
   pil.externalId,
   pil.processId,
   nil.nodeid,
   nil.nodetype,
   nil.nodename,
   count(nil.nodeid) as total_hits
from
    NodeInstanceLog nil
inner join
    ProcessInstanceLog pil on pil.processInstanceId = nil.processInstanceId     
where
    nil.type = 1
group by 
     pil.externalId,
     nil.nodeid,
     nil.nodename