Activity Feed
- Posted Re: Inconsistent Key-Value Pair Searching in Splunk (Some Events Only Found with Wildcards) on Splunk Search. β11-25-2024 05:12 AM
- Karma Re: Inconsistent Key-Value Pair Searching in Splunk (Some Events Only Found with Wildcards) for mattymo. β11-25-2024 04:56 AM
- Posted Inconsistent Key-Value Pair Searching in Splunk (Some Events Only Found with Wildcards) on Splunk Search. β11-07-2024 03:13 AM
Topics I've Started
Subject | Karma | Author | Latest Post |
---|---|---|---|
0 |
β11-25-2024
05:12 AM
Hi!
Thank you for your response π
I made the change below to my query, including the "ERROR" key using regex, and it works properly:
index="idx_xxxx"
| rex field=_raw "\"ERROR\":\"(?<ERROR>[^\"]+)\""
....
... View more
β11-07-2024
03:13 AM
Hey Splunk team,
Iβm facing an issue where Splunk fails to search for certain key-value pairs in some events unless I use wildcards (*) in the value. Here's an example to illustrate the problem:
{
"xxxx_ID": "78901",
"ERROR": "Apples mangos lemons. Banana blackberry blackcurrant blueberry.",
"yyyy_NUM": "123456",
"PROCESS": "orange",
"timestamp": "yyyy-mm-ddThh:mm:ss"
}
Query Examples: This works (using wildcards):
index="idx_xxxx" *apples mangos lemons*
These donβt work: -> index="idx_xxxx" ERROR="Apples mangos lemons. Banana blackberry blackcurrant blueberry." -> index="idx_xxxx" ERROR=*apples mangos lemons* -> The query below, using regex, does not include all error values trying to find any value after the ERROR key:
index="idx_xxxx"
| rex field=_raw "ERROR:\s*(?<error_detail>.+?)(?=;|$)"
| table error_detail
Observations: Non-Latin characters are not the issue because of other events, for example, Greek text in the ERROR field is searchable without wildcards. This behavior is inconsistent: some events allow exact matches, but others donβt. Questions: Could this issue stem from inconsistencies in the field extraction process? Are there common pitfalls or misconfigurations during indexing or source-type assignments that might cause such behavior? How can I debug and verify that the keys and values are properly extracted/indexed? Any help would be greatly appreciated! Thank you! ββ
... View more
Labels