Query to Fetch Process Name from Object Name

[Neel1]

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

[PvD_SE]

Hi N,

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

[Neel1]

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

[ewilson]

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

[Neel1]

Thanks @ewilson - it worked fine.​