Splunk Search

What is the different between line exist in file and events of Splunk?

indeed_2000
Motivator

Hi

I've index a 12MB file in splunk but have different between line of file and event of splunk

 

file = 114,475          lines

splunk = 104,475   events

 

file lines like this:

123456789|0123456789|0123456789|Tobe                             |Alex                            |

 

 

any idea?

Thanks

Labels (3)
Tags (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Also, check for blank lines.

Where did the line count for the file come from? Is it counting long lines as two (or more lines)?

0 Karma

indeed_2000
Motivator

@ITWhisperer 
1- there are no blank line in file.

2-vi in linux show line numbers.

3-each line one event in splunk.

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @indeed_2000,

check if in the file you have some multiline event.

If not check the correct parsing of you events.

Ciao.

Giuseppe

0 Karma

indeed_2000
Motivator

@gcusello 

1-there is no multiline event.

2- how check correctly events parsed?

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @indeed_2000,

Check (usually is possible with a quick view on events9 if there are more events containing the timestamp that usually is at the beginning of the file.

Ciao.

Giuseppe

0 Karma

indeed_2000
Motivator

@gcusello as i write in post there is no timestamp in this file.

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @indeed_2000,

check if there's a common (in format) beginning of each raw, so you can identify it there are more raws merged in the same event.

Ciao.

Giuseppe

0 Karma

indeed_2000
Motivator

@gcusello would you please tell me an example?

0 Karma
Get Updates on the Splunk Community!

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...