topic Re: extracting timestamp from multiple timestamp in Splunk Search

extracting timestamp from multiple timestamp

mmohiuddin — Wed, 18 Feb 2015 22:25:51 GMT

I have the following event with multiple time stamp

Feb 18 2015 16:20:00:456 host=127.XX.XXX.XX 21:20:00:456 XXXX

I need splunk to recognize timstamp from :

the following onwards

Feb 18 2015 16:20:00:456 host=127.XX.XXX.XX "21:20:00:456 XXXX"

the ones marked in " XXX"

What entry do i need to put in props.conf to achieve this.

Please let me know

Thanks

Re: extracting timestamp from multiple timestamp

ppablo — Thu, 19 Feb 2015 00:16:03 GMT

Hi @mmohiuddin

Just to clarify for people who can help you, you want to extract the timestamp 21:20:00:456?

Re: extracting timestamp from multiple timestamp

mmohiuddin — Thu, 19 Feb 2015 13:18:00 GMT

yes I want to extract the timestamp 21:20:00:456

Re: extracting timestamp from multiple timestamp

mmohiuddin — Mon, 28 Sep 2020 18:58:52 GMT

This is the actual log event:

Feb 19 09:00:55 133.17.1.124 Feb 19 14:00:56 LDC-N26-SSLVPN4 AN_SQUID_LOG 1424354456.021 1 10.9.8.21 TCP_MISS/200 1670 GET /myaccess/logout.gif - DIRECT/205.145.103.151 -

It is coming from syslog event.

I need splunk to extract timestamp from

Feb 19 14:00:56 LDC-N26-SSLVPN4

onwards.

This is what I have entered in props.conf on indexer. Source is udp:514

[udp:\514]
TIME_PREFIX = \w+\s+\d+\s+\d+:\d+:\d+\s+\d+.\d+.\d+.\d+\s+
MAX_TIMESTAMP_LOOKAHEAD = 30

But even after doing that and restarting indexer, I am still not able to extract the required timestamp

Feb 19 14:00:56 LDC-N26-SSLVPN4

Please let me know what I am missing here

Re: extracting timestamp from multiple timestamp

cpetterborg — Mon, 23 Feb 2015 04:27:46 GMT

If time is ALWAYS exactly 5 hours off, the just make a timezone shift off the first time in the event. That would be the easiest thing to do.

Re: extracting timestamp from multiple timestamp

woodcock — Tue, 19 May 2015 16:32:30 GMT

Use this:

TIME_PREFIX = .*?host=\d+\.\d+\.\d+\.\d+\s+\"