Orion HA Failover Details

A query to add to a custom resource.

It display by default the last 15 failover, and it can be configured to display the today failover or the last 2 days failover.

-- today failover --
-- AND tolocal(e.EventTime) > DateTrunc('day',GETDATE())
-- last 2 days failover --
-- AND tolocal(e.EventTime) < DateTrunc('day',GETDATE())
-- AND tolocal(e.EventTime) > DateTrunc('day',addday(-2,GETDATE()))  
Anonymous