topic Re: export Splunk data to template excel in Reporting

export Splunk data to template excel

divjak — Wed, 28 Aug 2013 08:42:47 GMT

Ave!

Is there any easy way to extract Splunk data into predefined (template) excel document?
I have a simple result table and I want, by simple click on button, export all data in table to predefined .xls worksheet to a specific location in document.

Thanks for help.

Re: export Splunk data to template excel

HiroshiSatoh — Wed, 28 Aug 2013 09:11:54 GMT

Although it is may be used to help

1.simple click on button
(1) customize the Excel Export.
(2) And output to Excel using the API.

2.Other
(1)To create a VBA macro that captures data output by Excel Export.

Re: export Splunk data to template excel

divjak — Wed, 28 Aug 2013 09:39:29 GMT

pfiuu ... I see there is no easy way... let struggle

thanks for respond Hiroshi

Re: export Splunk data to template excel

HiroshiSatoh — Wed, 28 Aug 2013 11:16:52 GMT

Python SDK might be easiest because some EXCEL library in Python.
Good luck!

Re: export Splunk data to template excel

Ayn — Wed, 28 Aug 2013 15:15:09 GMT

Use the Excel Export app!

http://apps.splunk.com/app/760

Re: export Splunk data to template excel

watsm10 — Wed, 28 Aug 2013 15:53:14 GMT

A couple of ways I have done this in the past. We are currently using the automated option and is working for us. We are able to produce daily, weekly and monthly reports in Excel format using templates.

Manual

Using the export option from the search bar (after the search has completed) or use a saved search where the CSV file is sent via e-mail.
Dump the contents of the CSV file into the template you created and it will be mapped to display the data in the correct way. (Look up "excel link values")

Automated

Install a free mail server (hMail server).
Point Splunk to send emails to the mail server.
Attach a VBScript to the mail server to scan each email for a CSV attachment and save it.
A VBScript is run on a CRON job to copy the CSV file to the Excel template (stored locally).
The template you created will be mapped to display the data in the correct way. (Look up "excel link values")
The file will be saved locally, but you could always configure it to be sent to an e-mail recipient.

Re: export Splunk data to template excel

araitz — Wed, 28 Aug 2013 16:20:17 GMT

Exporting to a pre-defined template is actually something I have done for a few customers, but I haven't made the leap into making it a full blown feature.

Re: export Splunk data to template excel

divjak — Thu, 29 Aug 2013 05:27:38 GMT

I am using Excel Export app already but I want that process of copy paste in template excel format to be automated..just by click on button it will retrieve a .xls document with results from Splunk in template format.

Re: export Splunk data to template excel

divjak — Thu, 29 Aug 2013 05:29:43 GMT

nice solution, but it is possible without too many other programs? Just Splunk and Excel maybe..

Re: export Splunk data to template excel

divjak — Thu, 29 Aug 2013 05:44:11 GMT

Has anybody experience with Python's xlrd, xlwt and xlutils.copy? I am thinking of modifying Excel Export app by adding xlrd and xlutils.copy (since there is only xlwt) and then making some changes like this ...maybe it is not so difficult because I need a simple copy of template and insert results from table in Splunk to exact place in template.xls file in same table order as it is in Splunk..and then save it.

Re: export Splunk data to template excel

jadengoho — Sat, 04 Jan 2020 09:23:40 GMT

Does anyone successfully accomplish this ?