Blue Prism DB structure

[wingkithui]

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.

[PabloSarabia]

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 🙂

[wingkithui]

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.

[NicholasZejdlik]

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.

[EmersonF]

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.