This content has been marked as final.
Show 2 replies
-
1. Re: Sql query to fetch activevos process Id and its corresponding rowid object from mdm base object table
kunal pandit Aug 17, 2020 2:32 AM (in response to Mohammed Asim)Check the aeb4ptaskparameter table for the berowid id. The data corresponding to this ID will be present in aeb4ptaskparametervalue table.
-
2. Re: Sql query to fetch activevos process Id and its corresponding rowid object from mdm base object table
Gaurav Singh Sep 29, 2020 5:35 AM (in response to Mohammed Asim)Hi Asim,
you can use following query:
select pt.processid, pv.STRINGVALUE as rowid_object, ptp.paprocessid as parent_process
from avos.aeb4ptask pt
inner join avos.aeb4ptaskparametervalue pv
on pt.processid = pv.processid and pv.parameterid = 27
inner join avos.aeb4ptaskpa ptp on ptp.processid = pt.processid;
P.S: parent_process is the processid that you see on AVOS admin console under monitoring menu.
Hope this helps.