Button for exporting alarms in CSV locally

[admin]

Create alerts.lp file and upload it to user directory via FTP using apps login.

Code:

<?

require('apps')

setdlheader('text/csv; charset=utf-8', 'Alerts', 'csv')

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

write(csv)

Then in visualization create a link that points to /user/alerts.lp