Fetching resource name from the queue

[KavishaRani]

I want to retrieve the Resource used for processing of a particular queue item for my Queue Report. Is there a way out for this?

[MaheshKushare]

Hi Kavisha,   I am not sure about your question and requirements /scenario. but there is one option in blue prism where you can read/get the resource name on whiuch your process in running. you can use the in build blue prism function GetResourceName() hope this will help you. Thanks, Mahesh

[KavishaRani]

Hi Mahesh, The function GetResourceName() gives the resouce name on which the current process is being run. My question is regarding queue report generation. I am generation a queue report. My process was executed on more than one machines so different machines locked different queue items. I want to fetch the resource name against each item of the queue. When we export the queue report to excel, you must have noticed that we get a column for resource name. Can we fetch the resouce name using any blueprism feature? Thanks, Kavisha

[RajeshSrirambha]

Hi,

I have the same question. May i know how you solved it, please?

Thanks\ Rajesh

------------------------------
Rajesh Srirambhatla
Senior Consultant
Capgemini
Europe/Stockholm
------------------------------

[AndreyKudinov]

AFAIK there is no way to get it normal way - either get it from db or store that info in queue item itself and update it with GetResourceName() when you acquire item lock.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

[RajeshSrirambha]

Okay!
Can you please help me, how can I get it from db?
Br\Rajesh

------------------------------
Rajesh Srirambhatla
Senior Consultant
Capgemini
Europe/Stockholm
------------------------------

[JerinJose · Accepted solution]

Hi,

BPA workqueue items table has session id. do an inner join to BPA session and BPA resources table on the session Id and resource id so you can get the resource name.

select q.keyvalue as 'KEY_Value',r.name as 'Resourcename' from BPAWorkQueueItem q inner join BPASession s on q.sessionid=s.sessionid inner join BPAResource r on s.runningresourceid=r.resourceid inner join BPAWorkQueue W on q.queueid=w.id where w.name='queuename'

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------

[RajeshSrirambha]

Hi Jerin,

Sorry for the late reply. I didn't get a chance to implement it till now.

And Thank you so much for the help. I really appreciate it. I get Key column value and Resource Name with an input value 'work queue name'. I will try to add more BP tables to get more meaningful report. Thank you.

Br Rajesh

------------------------------
Rajesh Srirambhatla
Senior Consultant
Capgemini
Europe/Stockholm
------------------------------