Missing connection count

[YashaswiniB]

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
------------------------------

[JerinJose]

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, .*
------------------------------

[YashaswiniB]

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
------------------------------

[hantao]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------