topic RE: How to Identify Offline Bots in Product Forum

How to Identify Offline Bots

vinodchinthakin — Mon, 01 Mar 2021 05:13:00 GMT

Hi,

My bots are working fine in Production. Some times, may be once in a week one of the bots are going for offline state because of certain reasons like server. We are solving the issue during working hours by logging into VM.
I want to know is there any Option in Blue Prism and any other tool which sends us an email when the Bots go Offline. So that we can immediately take action on the issue during weekend or non working hours.

Thanks in advance

VINOD

------------------------------
vinod chinthakindi
------------------------------

RE: How to Identify Offline Bots

NicholasZejdlik — Mon, 01 Mar 2021 15:19:00 GMT

Best way I've found is making an http call to the robot. If it replies, it's online. You can do that through Blue Prism itself using the Utility - HTTP object, or from external code. As far as I know, Blue Prism doesn't have anything built in for this. It makes sense that it can't monitor itself for whether or not it's online. I think if they did implement some kind of alert for that, it would have to be through the Blue Prism server application.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: How to Identify Offline Bots

sumire — Tue, 02 Mar 2021 01:31:00 GMT

Hello,

You can see status information of each RR in the "BPAResource" table in DB.
I use PowerBI to create a dashboard to see the table, and put it on the Microsoft Teams tab.
This way is easy to create and monitor, and it is not difficult to send notifications to my PC by mail, Teams notice and so on.

Hope this helps.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: How to Identify Offline Bots

KotaSuto1 — Tue, 02 Mar 2021 02:02:00 GMT

Hi,
I think you can use 'DML Trigger', which is the default function of SQL Server.
This function works when a record in the specified table is updated, deleted, or inserted.
If you combine this and Database Mail, the notification mail could be send without any other tools when resource PCs becomes offline.

References(MS Documentation):
DML Triggers
Configure SQL Server Agent Mail to Use Database Mail

I hope you will find it helpful 🙂

------------------------------
Kota Suto
Japan
------------------------------

RE: How to Identify Offline Bots

vinodchinthakin — Tue, 02 Mar 2021 04:46:00 GMT

Hi Nicholas,
Thanks for your response.
can you specify what are the inputs I have to provide to call robot using http utility.
what can be address url - is it IP address of VM?
what could be body, content type and method to call a Bot?

Thanks

------------------------------
vinod chinthakindi
------------------------------

RE: How to Identify Offline Bots

vinodchinthakin — Tue, 02 Mar 2021 04:48:00 GMT

Hi Mitsuko,

Can you specify the exact query to fetch "BPAResource" table in DB. by using data sql server vbo?
Thanks

------------------------------
vinod chinthakindi
------------------------------

RE: How to Identify Offline Bots

sumire — Tue, 02 Mar 2021 06:45:00 GMT

Hi vinod,

No, I don't mean to use SQL or VBO.
I use Microsoft PowerBI, and I specify DB directly in PowerBI.

You can use DB tables in PowerBI in similar way that you use tables in Microsoft Access. Just try PowerBI.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: How to Identify Offline Bots

John__Carter — Tue, 02 Mar 2021 08:53:00 GMT

Vinod check out the Help at Interface > Advanced options > Resource PC commands for a description of the HTTP API. Typically you'd use the machine name (or IP) something like this.

http://PC123456:8181/user%20name%20MyUserName%20&password%20MyPassword&ping

Note that the above is using native auth and the ampersand is used to combine the user name, password and ping commands as one.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: How to Identify Offline Bots

vinodchinthakin — Tue, 02 Mar 2021 09:13:00 GMT

Hi John,
Thanks for your response. I think for calling a process, first we need to expose it to as Webservice. I remember few months ago, we have created a process and exposed as web service, then called using http request, but we have received an error like it is not able to recognize or not able to connect IP.

------------------------------
vinod chinthakindi
------------------------------

RE: How to Identify Offline Bots

vinodchinthakin — Tue, 02 Mar 2021 09:19:00 GMT

Hi Mitsuko,
Thanks for the reply. I don't have any knowledge on PowerBI and we dont have any person in our company who works on PowerBI.
Can I use any trial version or should I go with premium one.? can you suggest in which VM/machine we need to install in order to read DB tables/data.?

------------------------------
vinod chinthakindi
------------------------------

RE: How to Identify Offline Bots

sumire — Tue, 02 Mar 2021 10:56:00 GMT

Hi vinod,

Here is link. I use free ver of PowerBI. Even with the free version, I don't have any trouble with functionality.
https://powerbi.microsoft.com/
I installed it on my windows10 PC. Any windows machine is OK if it can reference the Blue Prism DB.

Here is link to guides and documents.
https://powerbi.microsoft.com/learning/

I believe that PowerBI and Blue Prism DB are a good match.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: How to Identify Offline Bots

DevendraSingh_R — Fri, 12 Mar 2021 16:05:00 GMT

Hi Vinod,

As "BPAResource" table in DB holds each RR details including status.
You can write python script to extract RR status detail and send mail in the same script.
And the script can be scheduled as per required frequency.

------------------------------
Devendra Singh Rawat
Solution Architect
Ericsson
India
------------------------------