Automate the BOT Monitoring Process

[rokkam_saiteja]

Hi All,

Is there any way to create a process in a such a way to monitor the bots activity by including the following factors and sends a report via email?

If yes please let me know

• Current process status.

• Which process the bot is executing.

• Current progress step

• Error/exception logs if any.

• Total Pending  Queue Items

Thanks

[Michael_S]

@asilarow I feel like you would know a thing or two about monitoring / reporting... any advice? I'll put a bat signal out for @grbanares too 🦇

[sumire]

Hello @rokkam_saiteja ,

How about using Data - OLEDB VBO to directly retrieve values from a database table and store them in a collection?

This way allows for automation in the process.

For example:

process info: BPAProcess, BPASessionLog
workqueue info:  BPAWorkQueueItem

[asilarow]

@rokkam_saiteja - I think I can help here, but before I answer can you please provide the below details:

- Blue Prism version you are currently using, and Is it Blue Prism Enterprise (BPE), Blue Prism Cloud (BPC), or Blue Prism Next Gen?

- If BPE or BPC, then Do you have Blue Prism API set up?

[rokkam_saiteja]

Thanks for that

We are currently using

Blue Prism Enterprise (BPE)

Version: v6.10.5

Api set up is there

thanks

[asilarow]

Hi Rokkam,

So from what I can see this is an on-premise install, right?

And since you're on v6.10.5 then you don't have Blue Prism API as this is only available from Blue Prism v7.0 and higher.

Ok, so now that this is established, the below are your best options:

1. Use Data Gateways to push your session and work queue information to an external dashboard
2. Use SQL to query the Blue Prism database tables, and create a report (example query below):
   

   SELECT TOP (1000) BPAProcess.name, BPASession.startdatetime, BPASession.enddatetime, BPAStatus.description, BPAResource.name AS ResourceName

   FROM BPAProcess INNER JOIN

   BPASession ON BPAProcess.processid = BPASession.processid INNER JOIN

   BPAStatus ON BPASession.statusid = BPAStatus.statusid INNER JOIN

   BPAResource ON BPASession.runningresourceid = BPAResource.resourceid

   WHERE (BPAProcess.ProcessType = 'P') AND (BPAStatus.description = 'running')

3. You can also use a 3rd party tool to do this... but it always comes with an additional cost

[rokkam_saiteja]

Hi @asilarow 

I am unable to configure Data Gateways

how can i push data to external dashboard after configuring data gateway?

Thanks.

[Michael_S]

@rokkam_saiteja You'll need your admin to grant you the relevant roles. You can find info on user roles and permissions in the resources that @asilarow linked - see here:

https://docs.blueprism.com/en-US/bundle/blue-prism-enterprise-7-4/page/Guides/data-gateways/dg-permissions.htm

Good luck 💙

[grbanares]

Sorry for the late response.

I was leaning towards @asilarow 's answer as well. The best way to capture that level on information on that kind of reporting is to access directly the tables in the database.

Another way to get it going as well is to integrate it with Power BI or any reporting tool you have at the moment. Since the data is in SQL, it should be easily accessible for the tools like Power BI as long as you have relevant access rights to do the query.