topic Re: Exporting list of Objects used in Process in Product Forum

Exporting list of Objects used in Process

FirstName — Mon, 20 Feb 2017 20:27:00 GMT

Hello I've been trying to find a way to export a list of Objects used by each process, essentially creating an ODI through blue Prism rather than having to do it manually as I have been. I've tried spying Blue Prism itself, to see if I can read this, but it doesn't seem to be working. Also, it seems like something which may already exist within Blue Prism, and something I've just not encountered yet. Any help with this would be great. Thanks

Hello there,

MarkusKrahn — Wed, 01 Mar 2017 17:24:00 GMT

Hello there, There is a dependency list for processes and objects which you can find under Edit > Dependencies in the Process / Object Studio Toolbar. Trialed a quick spy and reader on the dependency list and it works fine :) The list is a treeview which you can read using a Reader stage in your object (Get Treenode Child Items) Have not tried implementing an entire lookup for each process though (get process, step into process studio, display dependencies, read treenode child items) Hope it helps BR Markus

Hi Markus

FirstName — Tue, 07 Mar 2017 16:39:00 GMT

Hi Markus Thanks for the response, and taking the time to have a look into this... I'm not sure if I'm spying it as you have, but I don't seem to be able to see 'Get Treenode Child Items' as an option... Unusually, I do have two 'Get Treenode' options, however neither of them give me anything useful... Did you just spy the 'Advanced Find' Window within Win32 spying mode? Thanks Gary

Hey Gary,

MarkusKrahn — Thu, 09 Mar 2017 13:16:00 GMT

Hey Gary, I can't double check at the moment, but i believe i simply spied the treeview object in the window using Win32. I'll look it up in the office tomorrow and verify. BR Markus

Hi Markus

FirstName — Thu, 23 Mar 2017 14:22:00 GMT

Hi Markus Were you able to check this at all? I've tried again and it's still not seeming to appear as an option for me. Thanks

Guess a SQL query should be

LuXu — Fri, 28 Jul 2017 19:14:00 GMT

Guess a SQL query should be able to achieve this

Re: Exporting list of Objects used in Process

milangoradiya — Mon, 22 Jul 2024 12:31:18 GMT

Hi All

I Know its old thread but I have a question,
Do we get this details through Blue Prism DB Query. Want to fetch BP Object name which is related to BP process names.

Re: Exporting list of Objects used in Process

John__Carter — Tue, 23 Jul 2024 11:14:03 GMT

Hi Milan the BPAProcessNameDependency table contains the process ID and the names of VBOs it has been configured to use. So if your query joins with BPAProcess, you'll be able to get the process name.

Re: Exporting list of Objects used in Process

bruce.liu — Wed, 24 Jul 2024 00:25:19 GMT

You can use the following SQL script to obtain the dependency between processes and objects.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/blue-prism-dependency-sql-script

The script recursively retrieves assets that are both directly and indirectly associated with any Blue Prism process and object. It breaks down intricate dependencies info into an easily consumable format.

Re: Exporting list of Objects used in Process

milangoradiya — Thu, 25 Jul 2024 09:33:49 GMT

Hi both,

Thank you so much for the response.
My issue is resolved with below SQL Query, It may help to other.

SELECT distinct PR.name as 'Process Name', PAD.refProcessName as 'Object Name',
PR.ProcessType
FROM dbo.BPAProcess PR (NOLOCK)
JOIN dbo.BPAProcessActionDependency PAD (NOLOCK) ON PAD.processID = PR.processid
Where PR.Name in ('1stProcessName',
'2ndProcessName',
'3rdProcessName')