How could I query the View connection server database for agent failures?

[SereneVCP]

The view agent on virtual desktops can fail to communicate with the connection server over time, but the agent service does not actually fail and restart.  Is there a way to query the connection server database for agent communication failures and direct vcenter to restart the VM?  Directing the virtual desktop to automatically reboot after a period of time is not an option. 

[sjesse]

if you look at the below link, they have a powershell script that will find affected vms, its possible to use this to automatically reboot the vms

https://blogs.vmware.com/euc/2017/01/vmware-horizon-7-powercli-6-5.html