Bql query to show fail times of devices
bql:select parent.name as 'Device', down as 'Down', lastOkTime as 'Last Ok Time', lastFailTime as 'Last Fail Time' from driver:PingHealth order by down DESC
This query shows the Device Name, Down Status , Last Ok Time, Last Fail time.
it is automatically Ordered with down devices shown up top, ( to remove the auto ordering delete 'order by down DESC' and to order with up devices change DESC to ASC)
Copyright 2022 Jordan Jennings