Exporting list of Objects used in Process

[FirstName]

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

[MarkusKrahn]

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

[FirstName]

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

[MarkusKrahn]

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

[FirstName]

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

[LuXu]

Guess a SQL query should be able to achieve this

[milangoradiya]

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.

[John__Carter]

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.

[bruce.liu]

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.

[milangoradiya]

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')