I missed some of the events for my search query, when I try to evaluate the time diff between event time and index time, Index time is early than event time. How can I resolve the timing issue? Where should I navigate and check??
index=Bullseye sourcetype=BullseyeAppLogs source="\\\\BP1XTXII492\\BULLSEYE.logs.devc$\\1817*.log" | eval indextime=strftime(_indextime,"%Y-%m-%d %H:%M:%S") | eval diff= _indextime-_time | table _time, indextime, diff
output:
_time↕ indextime↕ diff↕
2017-03-22 18:56:13 2017-03-22 19:01:48 335
2017-03-22 18:55:45 2017-03-22 19:01:48 363
2017-03-22 18:44:03 2017-03-24 18:28:29 171866
2017-03-22 18:43:27 2017-03-24 18:28:29 171902
2017-03-22 18:42:41 2017-03-22 18:44:57 136
2017-03-22 18:42:26 2017-03-22 18:44:57 151
2017-03-22 18:34:35 2017-03-22 18:35:09 34
2017-03-22 18:33:55 2017-03-22 18:35:09 74
2017-03-22 18:33:48 2017-03-24 18:28:02 172454
2017-03-22 18:33:14 2017-03-24 18:28:02 172488
2017-03-22 18:31:09 2017-03-24 18:28:24 172635
2017-03-22 18:30:46 2017-03-24 18:27:15 172589
2017-03-22 18:30:42 2017-03-24 18:28:24 172662
2017-03-22 18:30:35 2017-03-24 18:27:10 172595
2017-03-22 18:29:48 2017-03-24 18:27:15 172647
2017-03-22 18:29:02 2017-03-24 18:27:10 172688
2017-03-22 18:19:43 2017-03-24 18:28:21 173318
2017-03-22 18:19:11 2017-03-24 18:28:21 173350
2017-03-22 18:16:57 2017-03-22 18:18:02 65
2017-03-22 18:16:24 2017-03-22 18:18:02 98
... View more