This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

Export Alert list to CSV or email
#1
Hello,

Is there any way to export the current Alert list to a CSV file or to send it via email ?

Thank you
Reply
#2
Here's how to get CSV for alerts:
Code:
rows = { '"Date/time","Script name","Message"' }
items = db:getall('SELECT * FROM alerts ORDER BY id DESC')

for _, item in ipairs(items) do
  datetime = os.date('%c', item.alerttime)
  rows[ #rows + 1 ] = string.format('%q,%q,%q',
    datetime, item.scriptname, item.alert)
end

csv = table.concat(rows, '\n')
Reply
#3
(24.07.2020, 06:32)admin Wrote: Here's how to get CSV for alerts:
Code:
rows = { '"Date/time","Script name","Message"' }
items = db:getall('SELECT * FROM alerts ORDER BY id DESC')

for _, item in ipairs(items) do
  datetime = os.date('%c', item.alerttime)
  rows[ #rows + 1 ] = string.format('%q,%q,%q',
    datetime, item.scriptname, item.alert)
end

csv = table.concat(rows, '\n')
the best solutions is create a csv file and sent via mail, the same for register object
Reply
#4
(11.02.2021, 14:53)Frank68 Wrote:
(24.07.2020, 06:32)admin Wrote: Here's how to get CSV for alerts:
Code:
rows = { '"Date/time","Script name","Message"' }
items = db:getall('SELECT * FROM alerts ORDER BY id DESC')

for _, item in ipairs(items) do
  datetime = os.date('%c', item.alerttime)
  rows[ #rows + 1 ] = string.format('%q,%q,%q',
    datetime, item.scriptname, item.alert)
end

csv = table.concat(rows, '\n')
the best solutions is create a csv file and sent via mail, the same for register object
Hello

If I wanted to create a scheduled script on the first of the month and choose only the alarms of the previous month as is the select string, I can use the where? with a part of the date?

Thank you
Reply


Forum Jump: