# Generate daily report **URL:** \ **Category:** Elasticsearch\ **Created:** [September 9, 2020, 11:17am UTC](https://discuss.elastic.co/t/generate-daily-report/247993 "2020-09-09T11:17:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![headtea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/headtea/32/24271_2.png) [@headtea](https://discuss.elastic.co/u/headtea)\ **Post date:** [September 9, 2020, 11:17am UTC](https://discuss.elastic.co/t/generate-daily-report/247993/1 "2020-09-09T11:17:03Z")
I have a dashboard in kibana (version 7.9.0). I need the dashboard to be exported to a PDF or an excel spreadsheet daily and emailed to someone. The time for the results should be in [the last 24 hours](https://i.imgur.com/O2EhAO7.png). [This doc page](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html) suggests clicking `share` and then `copy POST url`. Problem is, [I don't have that option](https://i.imgur.com/UbUsVvy.gif). The only thing I need is the default table from auditbeat called `Login Events [Auditbeat System] ECS`. Does anyone know what's missing? Is it possible to do? Thanks ahead! ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [September 9, 2020, 1:16pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/2 "2020-09-09T13:16:48Z")
Reporting (for Pdf & Png) and Watcher (for email with attachment) require a license You can enable a trial license from your kibana [here](https://www.elastic.co/guide/en/kibana/current/managing-licenses.html) ---
**Author:** ![headtea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/headtea/32/24271_2.png) [@headtea](https://discuss.elastic.co/u/headtea)\ **Post date:** [September 9, 2020, 1:29pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/3 "2020-09-09T13:29:41Z")
Thanks for the response! Same for excel? I only need one table. I can send emails automatically with a cronjob ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [September 9, 2020, 1:45pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/4 "2020-09-09T13:45:13Z")
There is no support for exporting dashboard into Excel The only thing you can use CSV to export specific data table or search result ---
**Author:** ![headtea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/headtea/32/24271_2.png) [@headtea](https://discuss.elastic.co/u/headtea)\ **Post date:** [September 9, 2020, 1:47pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/5 "2020-09-09T13:47:53Z")
So my only option is to create a web automation script that would automatically click `export to CSV` and email it? ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [September 9, 2020, 1:50pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/6 "2020-09-09T13:50:28Z")
The dashboard is a set of multiples differents viz and i don't see how to export it on CSV ... The best approch is to create a script that capture the dashbaord as a screenshoot and send by email may be ---
**Author:** ![headtea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/headtea/32/24271_2.png) [@headtea](https://discuss.elastic.co/u/headtea)\ **Post date:** [September 9, 2020, 1:57pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/7 "2020-09-09T13:57:34Z")
There's an export to CSV button though: ![](https://us1.discourse-cdn.com/elastic/original/3X/a/d/ad4698de74dd0e03464907cf4a76ade53c8d827f.gif) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 7, 2020, 1:57pm UTC](https://discuss.elastic.co/t/generate-daily-report/247993/8 "2020-10-07T13:57:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.