Blue Prism Product

last person joined: 24 minutes ago 

Chat about Blue Prism products
Expand all | Collapse all

Fetching resource name from the queue

Jump to Best Answer
  • 1.  Fetching resource name from the queue

    Posted 11-27-2018 10:07
    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?


  • 2.  Hi Kavisha,   I am not sure…

    Posted 12-03-2018 20:50
    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


  • 3.  Hi Mahesh, The function…

    Posted 12-04-2018 10:16
    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


  • 4.  RE: Hi Mahesh, The function…

    Posted 09-03-2020 11:08
    Hi,

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

    Thanks\ Rajesh

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



  • 5.  RE: Fetching resource name from the queue

    Posted 09-04-2020 02:22
    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
    ------------------------------



  • 6.  RE: Fetching resource name from the queue

    Posted 09-04-2020 02:34
    Okay!
    Can you please help me, how can I get it from db?
    Br\Rajesh

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



  • 7.  RE: Fetching resource name from the queue
    Best Answer

    Posted 09-04-2020 02:40
    Edited by Jerin Jose 23 days ago
    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
    ------------------------------



  • 8.  RE: Fetching resource name from the queue

    Posted 28 days ago
    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
    ------------------------------