topic RE: Missing connection count in Product Forum

Missing connection count

YashaswiniB — Thu, 03 Mar 2022 13:06:00 GMT

Hi all,
We have around 400 vids in production, we want to know the status of machines whether they are missing connection or idle, if they are missing connection we want to restart the machine which is missing connection.

How can we do this?

------------------------------
Yashaswini B
------------------------------

RE: Missing connection count

JerinJose — Thu, 03 Mar 2022 13:54:00 GMT

Hi Yashaswini,

you can create a BP opject that queries the blueprism DB SELECT
[name]

FROM [DBName].[dbo].[BPAResource]
where DisplayStatus = 'Offline'

and get the names of offline resources and iteratively restart the resources using VBscript

System.Diagnostics.Process.Start("ShutDown", "-r -t 00")

same can be done using a windows task scheduler as well.

------------------------------
Jerin Jose
Technical Product Owner
EY
Asia/Kolkata
*"If you find this post helpful mark it as best answer, .*
------------------------------

RE: Missing connection count

YashaswiniB — Thu, 03 Mar 2022 14:38:00 GMT

Hi Jerin,

Thanks for the reply,
We will try this and let you know.
We are trying to avoid any manual intervention to restart the machines.

Also I want the count of MISSING CONNECTIONS ONLY, Is the DisplayStatus same for Offline machines and Connections missing?

------------------------------
Yashaswini B
------------------------------

RE: Missing connection count

hantao — Fri, 29 Dec 2023 08:12:00 GMT

Hi Jose

I saw your reply to Yashaswini and it useful for me too.

but i have an another question as bellow, can you give me more suggestion？

i want to know how to create a BP object to query the blueprism DB

for example:

in bp's exists Objects ,which obj's action should i choose to execute the sql?

[Data - SQL Server]→[Get Collection]?Does this one can be used ?

if this action can be used ,i need to do connection first,but i don't know any connecting information for blueprism db

can you give me more help,thanks !

------------------------------
han tao
------------------------------

RE: Missing connection count

LeonardoSQueiroz — Sat, 06 Jan 2024 21:51:00 GMT

Hi Han Tao,

Check the print model below:

1. Set Connection

2.Open

3. Get Collection

4. Close

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------