Hi All,
I've been using an alert for a while which looks for when a node's database record hasn't updated as it should. Great alert, highly recommend it, however I do get an alert storm when the clocks go back.
The functional part of the alert is this line:
where datediff(minute,lastsystemuptimepollutc, getutcdate())>=3*StatCollection
Which fails because when there's an hour between the last poll and the next poll it's all true. I'm looking to make that a bit smarter while we're still in summer.
Does anyone have a good idea for incorporating a check on whether the timezone's just gone back?
(i've got a couple flavours of this that dont alert for a few extra minutes that might dodge the issue, but i'd prefer something more direct that wont break if I adjust the polling windows too much)
