Getting Data In

What is the best practice for avoiding irrelevant date in Cisco log being taken as time stamp?

bkatzlin
Explorer

Hi,
what would be the best practice for avoiding that a recent log line like the following one would be wrongly tagged as coming from two years ago?

Jun 23 23:15:47 cisco123.mylocal.net Compiled Fri 20-Oct-17 20:51 by prod_rel_team

 current sourcetype: cisco:ios
 _time: 2017-10-20T23:15:47.000

My plan would be setting a specific subtype and disabling the timestamp processor for that particular case.
transforms.conf:

[set_subtype_compiled_message]
REGEX = Compiled\s\w+\s\d+-\w+-\d+\s\d+:\d+\sby
DEST_KEY = MetaData:Sourcetype
FORMAT = sourcetype:cisco:ios_compiled

props.conf:

[cisco:ios]
TRANSFORMS-set_subtype_compiled_message

[cisco:ios_compiled]
DATETIME_CONFIG = NONE

Any better ideas, pros and cons?

Regards,
Bernd

0 Karma
1 Solution

Azeemering
Builder

In the props.conf use:

[cisco:ios]
MAX_TIMESTAMP_LOOKAHEAD=15
TIME_FORMAT=%b %d %H:%M:%S      
TIME_PREFIX =^

MAX_TIMESTAMP_LOOKAHEAD --> The number of characters into an event Splunk software should look
for a timestamp.
TIME_FORMAT -->Specifies a "strptime" format string to extract the date.
TIME_PREFIX -->If set, Splunk software scans the event text for a match for this regex. In this case the ^ asserts position at start of a line

View solution in original post

woodcock
Esteemed Legend
0 Karma

Azeemering
Builder

In the props.conf use:

[cisco:ios]
MAX_TIMESTAMP_LOOKAHEAD=15
TIME_FORMAT=%b %d %H:%M:%S      
TIME_PREFIX =^

MAX_TIMESTAMP_LOOKAHEAD --> The number of characters into an event Splunk software should look
for a timestamp.
TIME_FORMAT -->Specifies a "strptime" format string to extract the date.
TIME_PREFIX -->If set, Splunk software scans the event text for a match for this regex. In this case the ^ asserts position at start of a line

sloshburch
Ultra Champion
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...