topic Re: Creating unique file name for outputcsv in Splunk Search

Creating unique file name for outputcsv

ShaneNewman — Wed, 27 Feb 2013 16:14:25 GMT

I am trying to use this. It will create a file with the correct file name, it just has no contents... Any Ideas?

my command:

`eval_lab_invalid_chars` | `eval_lab_field_errors` | `remove_inactive_tests` | `lab_table_1` | `compendium_status_3_spaces` | `compendium_filter_status(Good)` | `report_date_grouping_lab` | `new_compendium_filter` | `division_lookup` | `compendium_date_format` | `compendium_new_lab_dedup` | `compendium_new_lab_table` | outputcsv [ search index=compendium sourcetype=lab_compendium | head 1 | eval query="All_lab_new_".strftime(now(),"%b_%d_%Y") | fields query | format "" "" "" "" "" ""]`

When I run the search without the outputcsv command I get results...

Re: Creating unique file name for outputcsv

cramasta — Wed, 27 Feb 2013 16:46:02 GMT

so you if you just use ...|outputcsv somefile.csv
does it work?

Re: Creating unique file name for outputcsv

ShaneNewman — Wed, 27 Feb 2013 16:55:36 GMT

Yes, it will work that way.

Re: Creating unique file name for outputcsv

cramasta — Mon, 28 Sep 2020 13:24:22 GMT

what is the custom name you are trying to accomplish?
All_lab_new_feb_27_2013.csv ?

Re: Creating unique file name for outputcsv

ShaneNewman — Wed, 27 Feb 2013 17:04:32 GMT

That is correct, for 450 searches. This file will be used to maintain integrations.

Re: Creating unique file name for outputcsv

cramasta — Mon, 28 Sep 2020 13:24:25 GMT

try this instead for creating the file name

...| outputcsv [ | stats count | eval filename=strftime(now(), "All_lab_new_%b_%d_%Y") | return $filename]

Re: Creating unique file name for outputcsv

ShaneNewman — Wed, 27 Feb 2013 17:11:58 GMT

Tried that too, same result.

Re: Creating unique file name for outputcsv

cramasta — Wed, 27 Feb 2013 17:16:04 GMT

strange, what version are you running?
and to just be clear, when you define the file name like outputcsv filename.csv
its works
but when you use the unique name its a blank file?

Re: Creating unique file name for outputcsv

ShaneNewman — Wed, 27 Feb 2013 17:18:04 GMT

We are on 4.3.5

That is correct, if I use a static file name it works fine. When using the dynamic name I get a blank file.

I think we are just going to use PowerShell to add the date stamp to the file, after it is generated.

Re: Creating unique file name for outputcsv

cramasta — Wed, 27 Feb 2013 19:18:21 GMT

very strange I have not had that happen in my experience so far.

Re: Creating unique file name for outputcsv

ShaneNewman — Wed, 27 Feb 2013 19:20:55 GMT

I keep hearing that about a lot of the issues we deal with. I am beginning to wonder if there is something wrong with Windows!

Re: Creating unique file name for outputcsv

ShaneNewman — Tue, 05 Mar 2013 17:06:01 GMT

We ended up using PowerShell to do the renames and moving the files to the Shared Location that we wanted to use. Changed outputcsv to outputlookup and setup some transforms.conf to setup the initial location of the files.