CentOS 7.7.1908, Splunk v9.1.0.2 I want to get an example event for each sourcetype on each host (excluding one host). This is my search: index=prefix_* host!="NotThisHost" sourcetype=*
| sort - _time
| dedup 1 host, sourcetype
| table host, sourcetype, _time, _raw I run this for the period "yesterday." This all works, but I'm not getting a result for a particular sourcetype which has "myString" in the sourcetype name. If I rerun the exact same search with: index=prefix_* host!="NotThisHost" sourcetype=*myString*
| sort - _time
| dedup 1 host, sourcetype
| table host, sourcetype, _time, _raw I do get the expected results for the sourcetype with "myString" in the sourcetype name. So, the only change is to zero in the sourcetype with the "myString" in the sourcetype name. I'm stumped. I'm an admin user, so I have all the permissions. I had another admin user try the same 2 searches and they saw the same behavior where the sourcetype with "myString" in the sourcetype name was not in the first search, but appeared in the second. Not much help on the web with the Google AI or without. One suggestion was to see if your sourcetype had a hidden trailing space (it does not). I've tried with and without the "sort - _time"; no change. I've tried with various integers for dedup; no change. It's a pretty simple search, so I'm stumped. Anybody got any bright ideas? This feels like a bug to me. There'd be no way to recreate enough for a splunk issue ticket; and, I wouldn't bother anyway unless I could reproduce on 10.0.1 (when it comes out).
... View more