Refine your search:

Greetings everyone. I am working to try and aggregate .csv data from a number of sources. Initially its just a few devices but the number will be millions when the project is completed.

For now, I just need to get our test lab working with some essential infrastructure equipment. All of the equipment is configured to regularly export .csv files via FTP. I would like to set up a directory on the test server I have set up to receive these files, and have splunk monitor the directory. I'm pretty sure this is possible, but it leads me to my next question.

If I have numerous different devices all dumping files to the same directory, how does Splunk tell what data came from what device?

asked 30 Sep '10, 18:41

msarro's gravatar image

msarro
39710
accept rate: 75%


2 Answers:

I'd suggest you set up sub-directories underneath the main directory, one for each system dumping their .csv files there.

This way, when setting up Splunk to digest those .csv files, it can extract the host from the sub-directory name using the "Segment on path" option in the input setup.

You can get more information from here http://www.splunk.com/base/Documentation/latest/Admin/Setadefaulthostforaninput

Brian

link

answered 30 Sep '10, 18:47

Brian%20Osburn's gravatar image

Brian Osburn
2.8k14
accept rate: 22%

Thank you for your help, I really appreciate it. Both of these solutions work, and I'm going to set up a hierarchical structure just to keep things organized. Thanks!

(08 Oct '10, 13:54) msarro

  • If it's manageable, have one directory for each host, and use host_segment in inputs.conf to assign hostnames.

  • If the hostname is anywhere in the file path, you can use host_regex in inputs.conf.

  • If the hostname appears in each event, you can use a transform to assign the host. This is per-event.

    Take a look at these doc entries also:
    http://www.splunk.com/base/Documentation/4.1.5/Admin/Setadefaulthostforaninput

    http://www.splunk.com/base/Documentation/4.1.5/admin/Overridedefaulthostassignments

  • link

    answered 30 Sep '10, 18:49

    southeringtonp's gravatar image

    southeringtonp ♦
    4.5k1215
    accept rate: 35%

    Thank you for your help, I really appreciate it.

    (08 Oct '10, 13:54) msarro
    Post your answer
    toggle preview

    Follow this question

    Log In to enable email subscriptions

    RSS:

    Answers

    Answers + Comments

    Markdown Basics

    • *italic* or _italic_
    • **bold** or __bold__
    • link:[text](http://url.com/ "Title")
    • image?![alt text](/path/img.jpg "Title")
    • numbered list: 1. Foo 2. Bar
    • to add a line break simply add two spaces to where you would like the new line to be.
    • basic HTML tags are also supported

    Tags:

    Asked: 30 Sep '10, 18:41

    Seen: 487 times

    Last updated: 30 Sep '10, 18:49

    Copyright © 2005-2012 Splunk, Inc. All rights reserved.