icon/x Created with Sketch.

Splunk Cookie Policy

We use our own and third-party cookies to provide you with a great online experience. We also use these cookies to improve our products and services, support our marketing campaigns, and advertise to you on our website and other websites. Some cookies may continue to collect information after you have left our website. Learn more (including how to update your settings) here.
Accept Cookie Policy

Accept License Agreements

This app is provided by a third party and your right to use the app is in accordance with the license provided by that third-party licensor. Splunk is not responsible for any third-party apps and does not provide any warranty or support. If you have any questions, complaints or claims with respect to this app, please contact the licensor directly.

Thank You

Downloading Office Documents Template System (ODTS) for Splunk
SHA256 checksum (office-documents-template-system-odts-for-splunk_13.tgz) 40733a772f1b3051126def70c69ff0f06f4baee98e22cf1a239a0743e12cbf4a SHA256 checksum (office-documents-template-system-odts-for-splunk_12.tgz) 9185e86f4c1f2374ad3e36a4f6874425d48327f7ef66ecac66efbc482185e799 SHA256 checksum (office-documents-template-system-odts-for-splunk_10.tgz) 96583f02fb293476cd8d88bfd88aa73e92928f3c2d8ef11c5946bfed0abd54f9
To install your download
For instructions specific to your download, click the Details tab after closing this window.

Flag As Inappropriate

Office Documents Template System (ODTS) for Splunk

Overview
Details
Office Documents Template System (ODTS) for Splunk allows you to easily generate office documents with any Splunk search results inside. You could easily dump splunk results to new document(results are inserted as table) or use predefined templates with any complex formatting to insert results at predefined places or with predefined style.

Application supports several document formats. By default, documents generated in ODT/ODF format supported by OpenOffice/LibreOffice and Microsoft Office (starting with 2007 sp2 and later). Other supported types are: doc, pdf, rtf, txt. Support for doc, pdf, rtf, txt documents requires local OpenOffice/LibreOffice installation (discussed below). Support for docx/xls/xlsx and others may be provided in future.
Application was tested on Windows/Linux(*nix) platforms


Using Office Documents Template System for Splunk

The App provides a new command - "docgen" used to generate office documents. Command has some trivial arguments (discussed later) and accessible at any app


Case 1 - dump splunk results to new document

Very often you just want to insert splunk results to a new document - in this simple case you just need to add docgen command to the end of splunk command's flow:

Example 1:

index=_internal source="*metrics.log" group="per_sourcetype_thruput" | head 20 | stats min(eps) avg(eps) max(eps) by series | docgen
docgen's output provides information about file generated and where you could find it. By default it's SPLUNK_HOME\etc\apps\odts_splunk\results foder

Example 2:

Just another simple example:
sourcetype=access* | top clientip | docgen

Example 3:

What if you want generated document to be found in another folder(another than "results")? Just use -ofile paremeter:
sourcetype=access* | top clientip | docgen -ofile=d:\temp\out.odt
Generated file could be found in d:\temp folder and has name out_<timestamp>.odt


Case 3 - generate DOC, PDF, RTF, TXT documents(i.e. non-ODT)

App could easily dump splunk results to different types of documents like DOC, PDF, RTF (other than ODT). To be able to do that you have to complete two points:

  • 1) install OpenOffice/LibreOffice locally(make sure python-UNO option is checked) and launch OpenOffice/LibreOffice in server mode

You launch OpenOffice/LibreOffice in server mode by running the command (under Windows):
"_path_to_soffice_\soffice" -invisible -headless "-accept=socket,host=localhost,port=2002;urp;"
Under Linux(Unix) it may look like:
soffice -invisible -headless "-accept=socket,host=localhost,port=2002;urp;"
2002 is a port number that you could change

  • 2) open App's setup page and provide absolute path to OpenOffice python binary and (optionally) port number used.

Path may look like(ex. for Windows): C:\Program Files\OpenOffice.org 3\program\python.exe
That's all, to generate document type you need add this type as an extension with ofile parameter, for ex. for doc:
sourcetype=access* | top clientip | docgen -ofile=my.doc


Case 2 - generate documents based on predefined template

Using this App you have ability to generate really complex office documents and place search results to specified places. You could do this by providing you own predefined templates.
To create your own templates or change existing you have to install OpenOffice/LibreOffice.
You could find some templates inside APP_HOME/templates(SPLUNK_HOME/etc/apps/odts_splunk/templates) folder:

  • dump_table_custom.odt - simple template that could be change to suite you needs to dump splunk results as table at some places
  • TableFields.odt - template used to insert splunk results as table with predefined style and columns
  • WithAnImage.odt - template with complex formatting (including images). Splunk results inserted as single values inside nested tables
  • ForTable.odt - template where splunk results inserted as independent tables
  • TableSection.odt - template where splunk results not just one table, but table with sections
  • dump_two_tables.odt - template used to insert several splunk results.

For all those templates you could find sample generated documents inside APP_HOME/results(SPLUNK_HOME/etc/apps/odts_splunk/results) folder to see how it looks like.
To start preparing you own templates or change existing I recommend you to read following article:
How to prepare Basic Templates in Appy
The App uses Appy framework internally and all principles of preparing templates in Appy are valid for ODTS. Just remember that in templates you could use "events" variable that represents splunk's results from main search flow(provided to docgen command).
Article provided and existing templates(from "templates" folder) would be a good starting point for changing or creating new templates.

To use created/changed template provide name of it to -tfile parameter:

Example 1: use docgen with some template (for ex.:TableFields.odt):

index=_internal source=*metrics.log splunk_server="*" | eval MB=kb/1024 | search group = per_sourcetype_thruput |stats sum(MB) as sumMB by series, group | docgen -tfile=TableFields.odt
If relative path name is provided to docgen command than we are searching for templates in SPLUNK_HOME/etc/apps/odts_splunk/templates folder

Release Notes

Version 1.3
Dec. 22, 2012

minor fixes
added setup page to serve doc,pdf,rtf, txt documents generation

Version 1.2
Dec. 10, 2012

Many improvements:
- reduced size
- generation summary: where to find generated document and time of generation
- ability to generate pdf, doc, txt (requires local OpenOffice/LibreOffice installation)

Version 1.0
Nov. 1, 2012

10
Installs
621
Downloads
Share Subscribe LOGIN TO DOWNLOAD

Subscribe Share

AppInspect Tooling

Splunk AppInspect evaluates Splunk apps against a set of Splunk-defined criteria to assess the validity and security of an app package and components.

Are you a developer?

As a Splunkbase app developer, you will have access to all Splunk development resources and receive a 50GB license to build an app that will help solve use cases for customers all over the world. Splunkbase has 1000+ apps and add-ons from Splunk, our partners and our community. Find an app or add-on for most any data source and user need, or simply create your own with help from our developer portal.

Follow Us:
© 2005-2019 Splunk Inc. All rights reserved.
Splunk®, Splunk>®, Listen to Your Data®, The Engine for Machine Data®, Hunk®, Splunk Cloud™, Splunk Light™, SPL™ and Splunk MINT™ are trademarks and registered trademarks of Splunk Inc. in the United States and other countries. All other brand names, product names, or trademarks belong to their respective owners.