Monthly report email

[Martin Gluckman]

Hi 

Am trying to find a way to generate a CSV report monthly and send that via email.

Creating a scheduled report from a saved search is all fine but I can't find a way to automatically send this monthly via email. The second prize would be to send an email alert that the CSV report has been generated and a link to the report.

You so much everyone!

Martin.

[Camila Salome Romero]

Hi Martin,

Currently, it's not possible to send these reports via email, this feature has been requested to the OpenSearch project and is planned to be included in a future release. You may follow its progress in the following issues:

- https://github.com/opensearch-project/dashboards-reports/issues/345

- https://github.com/opensearch-project/dashboards-reports/issues/72

As a workaround, you may create a script that queries the Wazuh indexer API to generate the CSV report and send it via email. You may execute said script periodically using a command wodle or a cron job if you prefer.

Here's an example of a script that sends custom emails

I hope this helps you!

Regards, Camila!

[Martin Gluckman]

Thank so much Camila!

Thinking aloud here what about a cron job that checks the folder where Wazuh creates the CSV files and mails them automatically to a Helpdesk for e.g. and then keeps a simple log of sent files so as not to repeat?

Could a simple cron job fix this till the macro features you mention are ready?

Martin