Kibana: Generate scheduled reports

[TiNico22]

Related to #1634
Considering that pdf and office report is in the roadmap, adding a scheduled report option should be great.
Frequency / time picker / dashboard to generate / export type (html | pdf | office)

[guidanz]

We have created Skedler, a powerful report scheduling solution for Kibana - Elasticsearch. Please see the blog for an introduction to this solution:
http://guidanz.com/blog/report-scheduler-for-kibana/. Email us(info at guidanz dot com) if you need further information about this solution.

[palmerabollo]

+1

[sabikhi]

Which release are we targeting this?

[TimCgn]

+1

[josdotso]

+1

[Inderjeet26]

+1

[tdwolf]

+1

[absmith82]

+1

[theazyfa]

+1

[yinchuan]

+1

[jakauppila]

+1

[b00tsy]

+1

[dangnhutuan]

+1

[zp-markusp]

+1

[kyblik]

+1

[ocuil]

+1

[german23]

+1

[chuyendang]

+1

[CyberTaoFlow]

+1

[ScottBeeson]

+1

[rkhapre]

+1

[TimCgn]

Ich kehre zurück am 12.10.2015.

Bei dringenden Anliegen wenden Sie sich bitte an meine Kollegen über den
Pallas Helpdesk ([email protected], 02232-1896-94).

Mit freundlichen Grüßen
Tim Kretschmann

Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht "Re:
[kibana] Generate scheduled reports (#1640)" gesendet am 09.10.2015
22:10:23.

Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während
diese Person abwesend ist.

---

//// pallas
Pallas GmbH / Hermülheimer Str. 8a / 50321 Brühl
Geschäftsführer: Stephan Sachweh

HR B 52019 Amtsgericht Köln

Managed Service - Einfach sicher
http://www.xing.com/companies/pallasgmbh

Besuchen Sie uns: it-sa in Nürnberg, 06.-08. Oktober 2015,
Halle 12, Stand 766 (Partnerstand Rheinische Fachhochschule Köln)

[skatz]

+1

[danyim]

+1

[devopsian]

+1

[billw2012]

+1

[garaki]

+1.. which release is this being planned for?

[jeromefroe]

+1

[dcomsa]

+1

[marioschaefer]

+1

[felixmd]

+1

[drolfe]

+1

[nittonfemton]

+1

[axansh]

+1

[benone]

+1

[TimCgn]

Ich kehre zurück am 07.01.2016.

Bei dringenden Anliegen wenden Sie sich bitte an meine Kollegen über den
Pallas Helpdesk ([email protected], 02232-1896-94).

Mit freundlichen Grüßen
Tim Kretschmann

Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht "Re:
[kibana] Generate scheduled reports (#1640)" gesendet am 27.12.2015
11:40:41.

Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während
diese Person abwesend ist.

---

//// pallas
Pallas GmbH / Hermülheimer Str. 8a / 50321 Brühl
Geschäftsführer: Stephan Sachweh

HR B 52019 Amtsgericht Köln

Managed Service - Einfach sicher
http://www.xing.com/companies/pallasgmbh

[kaib]

+1

[TimCgn]

Ich kehre zurück am 07.01.2016.

Bei dringenden Anliegen wenden Sie sich bitte an meine Kollegen über den
Pallas Helpdesk ([email protected], 02232-1896-94).

Mit freundlichen Grüßen
Tim Kretschmann

Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht "Re:
[kibana] Generate scheduled reports (#1640)" gesendet am 05.01.2016
15:25:35.

Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während
diese Person abwesend ist.

---

//// pallas
Pallas GmbH / Hermülheimer Str. 8a / 50321 Brühl
Geschäftsführer: Stephan Sachweh

HR B 52019 Amtsgericht Köln

Managed Service - Einfach sicher
http://www.xing.com/companies/pallasgmbh

[spacecwoboy]

+1

[NDevox]

+1

[iosven]

+1

[german23]

FYI:

http://www.ragingcomputer.com/2014/03/kibana3-automated-email-reports-using-windows

You can use this to generate reports with Kibana3 or Kibana4, and i. E. you can use the windows task scheduler to schedule the reports.

It works quite fine with Kibana4 for me, you are able to provide the direct url of the visualization or dashboard (you can also modify i.E the query search bar by providing the necessary filters in the url on the fly, without having to save the dashboard)

[elvarb]

I have used PhantomJS like @german23 mentions, If you have kerberos authentication on Kibana then PhantomJS will fail to authenticate because it uses Chrominium. You can try to use TrifleJS instead because that uses IE to generate the report, http://triflejs.org/

[anoinoz]

+1

[chakrayadavalli]

+1

[mesilov]

+1

[asldevi]

+1
may I know which release is this targetted at?

[german23]

Relating to
https://www.elastic.co/blog/heya-elastic-stack-and-x-pack
it seems like the scheduled reporting for Kibana will be part of the "X-Pack", which is basically a subscription.

Seems like they put such a great feature behind a paywall again...

[surry355f1]

+1 for freeware

[homeyjd]

+1

[givoly]

+1
How does one vote up the priority of this? We have to manually take daily/weekly screenshots and distribute via email. That's just brain dead in this day and age... Yes, there is a commercial tool, which we may resort to...

[spalger]

@givoly the priority system is explained in the contributing doc: https://github.com/elastic/kibana/blob/master/CONTRIBUTING.md#how-issues-work

[givoly]

@spalger - thanks for the explanation. New to this :-)
So I'll :+1: and explain this in a bit more detail. When there is time-based data, Kibana shows a "point in time". However, thing can change over time. It's critical to capture the point in time and track these. For this, reporting need to happen right at specific points in time (daily/weekly/monthly, for instance). Therefore, it is probably a P1 rather than a P2 based on these definitions, because no reasonable (non-commercial) workaround exists. Also the inability to format the results to processable output (screenshots are hardly those) make historic analysis manual and unscalable. Bottom line - it should probably be a P1. My $0.02.

[n1t1nv3rma]

+1 for freeware, else move to Splunk? :-1:

[Funbit]

+1...

[axansh]

+1

[axansh]

I have found work around for same.
I used http://phantomjs.org/screen-capture.html for capture screenshot of dashboard.
Format can be pdf or jpeg/png- 5 min job..

[Secespitus]

+1

[blubbi321]

+1

[piglesiasm]

+1

[parvez]

Hi Guys, I have created report generation app using nodeJS and PhantomJS. Enjoy! It is pretty basic and would love your feedbacks and PRs for enhancing! https://github.com/parvez/snapshot_for_kibana

[mirnujAtom]

+1

[guidanz]

We recently released Skedler v2.2 version that makes it extremely easy to schedule, generate, and distribute PDF, XLS reports from Kibana dashboards and search. It is great for teams that need a quick economical solution to generate high quality reports from Kibana - Elasticsearch. With the new version, you can schedule time window based reports (helpful to create different time window reports from the same dashboard or search), pause/resume report generation, and customize the reports with logo, headers, various page sizes et al. Skedler is tested and supported in a variety of linux platforms (centos, debian, ubuntu), ES (1.6+), and Kibana (4.1+) versions. A free version of Skedler is also available.
Please see the blog: https://www.skedler.com/blog for more details.
Here is a sample generated report: Alameda-Crime-Dashboard.pdf

[mpok3]

+1

[YashoShetty]

Hi,

Can anyone explain me this scenario, Lets say we introduce Shield into Kibana for authorisation, then how are these tools for example skeddler or the phantom.Js script going to work out, I did try out the phantom.js script for a particular url of kibana dashboard, but after the authentication it always retrieved the screen shot of the Initial landing page for Kibana. With respect to skedler i did not see any mechanism to submit the authentication. Can anyone guide me on this.
Also i am trying out the x-pack version where we readily get the PDF export, can any one put out a code as to how we attach / schedule those pdf reports?
Using watcher how do we send e-mail attachment if the authentication is activated.

[donrudo]

+1

[torse]

+1

[TimCgn]

Ich kehre zurück am 04.08.2016.

Bei dringenden Anliegen wenden Sie sich bitte an meine Kollegen über den
Pallas Helpdesk ([email protected], 02232-1896-94).

Mit freundlichen Grüßen
Tim Kretschmann

---

Dear Sir or Madam,

I am out of office. Your e-mail will not be forwarded. During my absence
our Pallas Helpdesk ([email protected], 02232-1896-94) will help you to
get in touch with an alternative contact within our company. Thank you for
your patience.

Sincerely yours,
Tim Kretschmann

Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht "Re:
[elastic/kibana] Generate scheduled reports (#1640)" gesendet am 25.07.2016
12:26:31.

Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während
diese Person abwesend ist.

---

//// pallas
Pallas GmbH / Hermülheimer Str. 8a / 50321 Brühl
Geschäftsführer: Stephan Sachweh

HR B 52019 Amtsgericht Köln

Managed Service - Einfach sicher

[safirjava]

+1

[eperry]

+1

[german23]

With the new Version of Kibana, 4.6.0, the built-in reporting function is now avaiable.

https://www.elastic.co/blog/reporting-2-4-0-released

This come as commercial plugin for Kibana, just like Graph is doing - no money no benefit.

This is really unfortunate, because I think such an basic feature as reporting should be avaiable for everyone - it is really sad which way elastic has choosen the last years, that every bit of "comfort" or additional benefit is locked behind an very big paywall (really, who the ... is going to pay ten thousands euros just for a reporting feature?)

Make the plugins buyable each by itself - we are happy to pay for sth we get an benefit for our stack!
We are not willing to pay though for unused, expensive support.

I think this issue can be closed now?

[jmkgreen]

According to an Elastic sales rep I spoke with weeks ago, the firm did try selling individual components but found it difficult to technically support a single component when it turned out the customer's use of the remaining components in the stack required help too.

[eperry]

if that is the case that it is coming out then i agree close the case.

It is sad that all new features are being surrounded by licensing, but most of them I don't need. But it will just encourage other people to come up with competing products. I already found an alternative that is actually more robust then kibana, Apache Zepplin. I am about to start looking at it.

[german23]

@jmkgreen, from the support point of view thats seems like a valid point, thanks for sharing this.

I dont know any details, but i can imagine that most people that are using the ELK-Stack dont want or dont need any support to the software, but rather want to buy the simple license.

I am no businessman whatsoever and i think that there are a few good reasons for the current licensing model, it is just frustrating to not beeing able to get the full potential out of the indexed data without paying a huge amount of money.

@eperry thanks for pointing to Apache Zeppelin, i will for sure have a look at it

[elvarb]

There exists now a very compelling licensing model that does not include support, only community support. It is limited to companies with fewer than 50 people I think.

[eperry]

Btw how it the version number 2.4 of this new reporting plugin? If it is new should it not be 1.0? or was it part of another opensource project?

[NDevox]

@eperry. Not necessarily, versioning numbers are decided by the producer, a lot of products are released as pre 1.0 versions.

In elastic's case they try to keep all products on the same version number so you know what to versions to get with each other. Elastic is currently v 2.4 so this plugin is released as that was well.

[jmkgreen]

@elvarb I'm not seeing any such model on the https://www.elastic.co/subscriptions page?

[Funbit]

@elvarb @jmkgreen I would like to know about that "compelling licensing model" too, because every time I see "Request info" button instead of the price it usually means that the price will go higher than I (or even a company) can afford..

[elvarb]

@Funbit @jmkgreen I think you need to contact Elastic directly for more information.

[ynux]

https://www.elastic.co/blog/you_get_a_report_you_get_a_report describes how to schedule reports from watcher. Both licensed, though.

[donrudo]

I think the commercial features from Kibana should not be related with this enhancement request for the Open Source version; the community can still develop an open sourced kibana plugin to add reports support.

[chenryn]

https://github.com/elasticfence/kaae/wiki/KAAE-Report-Example

[eperry]

Oh that like nice, going to check it out after I finish my upgrade to 2.4.1

[monotek]

If a mail with a JPG is enough for you: https://github.com/monotek/kibana-mailreports

[Proximator]

Any update?

[epixa]

Reporting, including scheduled reports, was initially released in 4.6 as a plugin, and then it became part of X-Pack in 5.0, and since 6.3 it's been shipping as part of the default distribution in Kibana. CSV reporting is available for free, and PDF reporting requires a gold license. There are some animated gifs on https://www.elastic.co/products/stack/reporting that show it in action.

I'm going to close this out, but if anyone has any specific enhancements they'd like to see in reporting, please feel free to open an issue with details!