5 hours ago
Use a scheduled script:
Code:
key = 'modbus_error_time'
time = storage.get(key, 0)
items = db:getall([[
SELECT *
FROM modbus_errors
WHERE errortime>?
ORDER BY errortime
]], time)
if #items == 0 then
return
end
texts = {}
for _, item in ipairs(items) do
time = item.errortime
date = os.date('%c', time)
texts[ #texts + 1 ] = date .. ' - ' .. item.errortext
end
message = table.concat(texts, '\n')
mail('user@example.com', 'Modbus errors', message)
storage.set(key, time)