24-09-20 01:03 AM
24-09-20 02:13 AM
25-07-24 10:37 AM
Hi Mayank,
Just saw your message, definitely you found other solution but for future reference it may help to other from this thread.
SELECT distinct PR.name as 'Process Name', PAD.refProcessName as 'Object Name',
PAD.refActionName,
PR.ProcessType
FROM dbo.BPAProcess PR (NOLOCK)
JOIN dbo.BPAProcessActionDependency PAD (NOLOCK) ON PAD.processID = PR.processid
Where PR.Name in ('1stProcessName',
'2ndProcessName',
'3rdProcessName')