topic Re: Query to Fetch Process Name from Object Name in Product Forum

Query to Fetch Process Name from Object Name

Neel1 — Wed, 24 Aug 2022 09:27:56 GMT

Hello Guys- i am looking for a SQL query to be run in DB to get Process Name on specifying the object name.

Re: Query to Fetch Process Name from Object Name

PvD_SE — Wed, 24 Aug 2022 10:01:15 GMT

Hi N,

Would that be:
All Processes that reference to the Object
or
The currently running Process that called the Object?

Re: Query to Fetch Process Name from Object Name

Neel1 — Wed, 24 Aug 2022 16:13:50 GMT

Hello Paul - i m looking all Processes referencing to that object by SQL Query method

Re: Query to Fetch Process Name from Object Name

ewilson — Wed, 24 Aug 2022 21:30:48 GMT

Hi @Neeraj Kumar,

Here's a kickstart for you:

SELECT [name] FROM [BPTest].[dbo].[BPAProcess] WHERE ([ProcessType] = 'P' AND [processxml] LIKE '%<resource object="Utility - HTTP"%');

I used the Utility - HTTP VBO as a test. Seems to work. You'll want to make the VBO name configurable as well as the database name (BPTest in my case) and possibly the DB schema depending on your environment.

NOTE: This will only return the processes that use the target VBO at the top level. In other words, if those processes use a VBO that uses the target VBO as a child, those won't be returned. Hopefully that makes sense.

Cheers,
Eric

Re: Query to Fetch Process Name from Object Name

Neel1 — Mon, 03 Oct 2022 09:04:55 GMT

Thanks @ewilson - it worked fine.