Export Alert list to CSV or email

[iJAF]

Hello,

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

Thank you

[admin]

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')

[Frank68]

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

[Frank68]

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

[andrepneves@gmail.com]

Hello All!

We need to use this in an event script linked to a button to download it directly to the user machine or send this by email.

How can we do this?

Thanks in advance for your help,
André

[Daniel]

You can convert this script with the script above:
https://forum.logicmachine.net/showthrea...2#pid28872
Just create event script on a object which is added to visu.