Getting Data In

Please write Props for the following data because time format not working

muez
Explorer

Below is data :

30,01/21/20,11:56:24,DNS Update Request,ip,xxx,,,0,6,,,,,,,,,0
11,01/21/20,11:56:24,Renew,ip,xxx,4889E71C9936,,3085275568,0,,,,0x4D53465420352E30,MSFT 5.0,,,,0
36,01/21/20,11:56:24,Packet dropped because of Client ID hash mismatch or standby server.,ip,,105BADA1EB57,,0,6,,,,,,,,,0

Please write props conf for this type of data.
According to splunk, from new year, splunk has stopped recognising two digit time stamps automatically.

0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @muez,
try this props.conf

[your_sourcetype]
TIME_PREFIX = \d\d,
TIME_FORMAT = %m/%d/%y,%H:%M:%S

If you haven't Splunk 8.0.1, remember to update datetime.xml following the Splunk Support instructions ( https://docs.splunk.com/Documentation/Splunk/latest/ReleaseNotes/FixDatetimexml2020?elqTrackId=29cfe... ).

Ciao.
Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @muez,
try this props.conf

[your_sourcetype]
TIME_PREFIX = \d\d,
TIME_FORMAT = %m/%d/%y,%H:%M:%S

If you haven't Splunk 8.0.1, remember to update datetime.xml following the Splunk Support instructions ( https://docs.splunk.com/Documentation/Splunk/latest/ReleaseNotes/FixDatetimexml2020?elqTrackId=29cfe... ).

Ciao.
Giuseppe

muez
Explorer

props is not working, i think I have to follow Splunk Instructions. Thanks

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @muez,
where do you used the props.conf? it must be on Indexer or (when present) on Heavy Forwarder not on Universal Forwarder and then you have to restart Splunk.

Ciao.
Giuseppe

0 Karma

muez
Explorer

We have heavy forwarders where we write props everytime. It doesnt work 😞

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @muez,
your data seems to be structured data, do they come from a csv?
In this case, put props.conf on Universal Forwarder that ingests csv.

Ciao.
Giuseppe

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...