Use this script to list all running ICase (Axon.ivy) in a particular IProcessModelVersion

query_all_running_cases_in_a_particular_pmv_of_an_axonivy_engine.sql

use axonivysystemdatabase;

-- state = 1 means RUNNING

declare @pmv_id int

set @pmv_id = 123456 -- set your PMV's Id here

select cx.*, te.processmodelversionid from
	 (select c.*, ts.taskelementid as 'taskelementid' from iwa_case c left join iwa_taskstart ts on c.taskstartid = ts.taskstartid) cx
			left join iwa_taskelement te on cx.taskelementid = te.taskelementid
	where state = 1 and processmodelversionid = @pmv_id