topic Re: Time stamp on custom imported file @Please Help@ in Getting Data In

Time stamp on custom imported file @Please Help@

j666gak — Mon, 05 Mar 2012 18:43:16 GMT

Hello,

I have never done an import on Splunk, so i'm sorry if this has been asked although I can't find it if it has.

I am trying to import a web usage log that is in the following format(below). I have tried doing a custom import as it didn't fit any of the preset ones, although when looking in Splunk after indexing the time stamp is completely wrong.

Tue 03 Jan 2012 10:25:57 AM CET

Considerations -
* Don't need the day "Tue"
* Month is not a numerical value ie 01 for Jan
* Not in 24hr format so shows AM/PM
* Time on the log was taken in CET, is it possible to convert to GMT London? same as Splunk server

I really need help on how to configure this please. If anybody can help I would be really greatful, thanks for your time.

Cheers
Guy

Re: Time stamp on custom imported file @Please Help@

lguinn2 — Mon, 05 Mar 2012 20:30:27 GMT

Splunk is usually very good at parsing timestamps in exactly this format. So, can you show us a few complete events? (anonymizing any private stuff of course) I suspect that Splunk is just confused about where to find the timestamp within the event, not with the format itself.

Re: Time stamp on custom imported file @Please Help@

MarioM — Mon, 05 Mar 2012 20:31:10 GMT

Configure timestamp recognition

Re: Time stamp on custom imported file @Please Help@

lguinn2 — Mon, 28 Sep 2020 11:28:52 GMT

BTW, you can tell Splunk that the input is in one of the following known web log formats:
access_combined (Apache)
access_combined_wcookie (Apache)
iis (Microsoft IIS)

You can find this by choosing More Options, and then setting the value for sourcetype (you will need to select Manual instead of Automatic) to do this.