Please help me with a sql query which will give me count of process (same number as we see in operation tab) in running,waiting, queued state.
Thanks & Regards,
This is what I have been testing out now that I am using CAPA 4.3 SP1
select RunState, Count(RunState) as 'Count' from [dbo].[C2ORuntimeObjects] where RootID = ROID and DiscriminatorType = 'WorkFlow'group by RunStateUNIONselect RunState, Count(RunState) as 'Count' from [dbo].[C2ORuntimeObjectsArch] where RootID = ROID and DiscriminatorType = 'WorkFlow'and isArchived = 0group by RunState
If you want to include jobs on the Archive pane as well, just remove the "and isArchived = 0"
If anyone has a different/better way please let me know.
Retrieving data ...