Refine your search:

We have a Summary Index saved search that uses a 5 minute sliding window and runs every 5 minutes. Sometimes events arrive several minutes or hours late and the Summary Indexing window for the event has already passed, thus leaving the summary index inconsistent with the original index.

Our strategy at the moment relies on events arriving within 5 minutes, our search's parameters are:

 earliest="-10m@m" latest="-5m@m"

We keep this window small, as we need dashboards that report in near real-time.

Is there a good strategy to detect events not present in a summary index due to this issue? Or perhaps a way to tell when an event arrives with a big difference in the real indexed time vs. the timestamp as reported by the event?

asked 09 Sep '10, 14:00

stephanbuys's gravatar image

stephanbuys
1487
accept rate: 8%


2 Answers:

Detecting late events in general is fairly straightforward. The values of _time and _indextime are unix time_t style integers of those two values.

search terms | where (_indextime - _time) > 300

would show you events that came over 5 minutes late, for example.

The summary index frequently doesn't have the original events, only aggregate information about them, so I can't give a strategy for detecting what might have been missed in the general case.

link

answered 09 Sep '10, 18:27

jrodman's gravatar image

jrodman ♦
5.8k2515
accept rate: 42%

This will definitely help get us there. Thank you very much.

(10 Sep '10, 10:32) stephanbuys

You can use transaction to collect and throw away duplicates. This will need some editing for your environment.

( search_terms ) OR ( index=summary search_name=searchName ) | transaction _time, other_identifying_fields keepevicted=true | where eventcount=1 | sistats count by _time, other_identifying_fields
link

answered 10 Sep '11, 04:06

BobM's gravatar image

BobM
1.5k110
accept rate: 31%

Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×200
×150
×15

Asked: 09 Sep '10, 14:00

Seen: 520 times

Last updated: 10 Sep '11, 04:06

Copyright © 2005-2012 Splunk, Inc. All rights reserved.