Hey, lately i was working on an SPL and wondered why this aint working. This is simplified index IN(anonymized_index_1, anonymized_index_2, anonymized_index_3, anonymized_index_4)
NOT index IN (excluded_index_1)
earliest=-1h@h latest=@h
EventCode=xxxx
sourcetype="AnonymizedSourceType"
NewProcessName IN (*)
[| tstats count
where index IN(anonymized_index_3, anonymized_index_1, anonymized_index_4, anonymized_index_2)
NOT index IN (excluded_index_1)
earliest=-1h@h latest=@h
idx_EventCode=xxxx
sourcetype="AnonymizedSourceType"
idx_NewProcessName IN(*)
by idx_Field1 _time idx_Field2 host index span=1s
| search anonym_ref!="n/a"
OR (idx_NewProcessName IN (*placeholder_1*, *placeholder_2*) AND (placeholder_field_1=* OR placeholder_field_2=*))
] When I run this SPL, I’ve noticed inconsistent behavior regarding the earliest and latest values. Sometimes the search respects the defined earliest and latest values, but at other times, it completely ignores them and instead uses the time range from the UI time picker. After experimenting, I observed that if I modify the search command to combine the conditions into one single condition instead of having two separate conditions, it seems to work as expected. However, I find this behavior quite strange and inconsistent. I would like to retain the current structure of the search command (with two conditions) but ensure it always respects the defined earliest and latest values. If anyone can identify why this issue occurs or provide suggestions to resolve it while maintaining the current structure, I’d greatly appreciate your input.
... View more