Getting Data In

_time need to be pick from log middle entry

snehal8
Path Finder

Hello All,

Can any one help me on this event injection in Splunk.

 

sample data

122.0.0.2 NOT_AVAILABLE abc Agent= 2021-09-27 11:15:39 5648 WARN xyz
NOT_AVAILABLE NOT_AVAILABLE NOT_AVAILABLE NOT_AVAILABLE 2021-09-27 11:16:08 5432 DEBUG Field: xyz
- value: ID
- unformatted value: vvcsa
- formatted value: abcsc
- returnType:
- boost: 1
- append: False

 

Here it have to be two events with respective date time.

 

 

 

 

 

 

Labels (1)
Tags (1)
0 Karma

snehal8
Path Finder

Thank you for the reply.

 

The event should be broken by follows

1st Event 

122.0.0.2 NOT_AVAILABLE abc Agent= 2021-09-27 11:15:39 5648 WARN xyz

 

2nd Event

NOT_AVAILABLE NOT_AVAILABLE NOT_AVAILABLE NOT_AVAILABLE 2021-09-27 11:16:08 5432 DEBUG Field: xyz
- value: ID
- unformatted value: vvcsa
- formatted value: abcsc
- returnType:
- boost: 1
- append: False

 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

I presume "NOT_AVAILABLE" represents sensitive data that can't be shared in a public forum.  Regrettably, this method of sanitization makes it rather difficult to create a regex that Splunk can use to split events.  Can you sanitize the data another way?

---
If this reply helps you, Karma would be appreciated.
0 Karma

snehal8
Path Finder

whenever there is no data in logs its represent as "NOT_AVAILABLE" entry. 

Please do consider this in regex as well. 

 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

So the event could contain "NOT_AVAILABLE" or it could contain anything else, right?  That's makes it nearly impossible to define a rule for separating events.  I'm not sure I can help here.

---
If this reply helps you, Karma would be appreciated.
0 Karma

snehal8
Path Finder

Its can contain the IP address or if its empty then it contain "NOT_AVAILABLE".

Please do let me know if it help.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Please show where the event should be broken.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...