topic Re: Blue Prism DB structure in Product Forum

Blue Prism DB structure

wingkithui — Wed, 12 May 2021 03:37:42 GMT

Dear,

I am trying to retrieve some data from BP DB daily, the purpose is to retrieve daily data such as how many works do the robot created, completed, and failed.

I have a work queue item and every time robot finish the process, robot will update the queue item or create a queue item.

I can get what I want in BP control room but I have no idea how to retrieve those data from BP Database.

Could anyone share their experience or some advice to me?

Thanks.

Re: Blue Prism DB structure

PabloSarabia — Wed, 12 May 2021 04:48:20 GMT

Hello,

The table is "[BPAWorkQueueItem]". Here you have the items with the status, Join with this one "[BPAWorkQueue]" to know the name of the queue.

Bye 🙂

Re: Blue Prism DB structure

wingkithui — Thu, 13 May 2021 03:55:40 GMT

Thanks for your answer Sarabia,

But is it possible to get the column with lock?

As I also want to get not only the status, but also those items are locked when they are processing.

Re: Blue Prism DB structure

NicholasZejdlik — Thu, 13 May 2021 14:32:10 GMT

For the lock column, join BPAWorkQueueItem with BPACaseLock.

Another useful join is if you need to extract tags from work queue items, you can join BPAWorkQueueItem with BPAWorkQueueItemTag, then BPAWorkQueueItemTag with BPATag.

Re: Blue Prism DB structure

EmersonF — Thu, 13 May 2021 14:55:57 GMT

For discoveries you can use the same Query that Blue Prism uses for this, this is the query responsible for viewing the Queue management.
With that to be able to create good indicators

If this helps you in any way, mark it as useful.