Splunk Search

Can I use kv_mode = auto AND kv_mode = XML for sourcetype?

tyronetv
Communicator

I have an application sourcetype that is a mix of normal informational data and also houses a subset of web requests and web responses all in XML format.

I would like to present the XML data as a searchable element, i.e, account=1234, while at the same time allowing the current key/value pairs to be searched.

As I read the docs, kv_mode is basically all or nothing. In that, it's one mode only.

How would I go about capturing both field elements from my logs using the splunk field identification process and not having to write thousands of extract statements?

Tags (3)
0 Karma
1 Solution

lguinn2
Legend

If you want to use Splunk's automatic extraction capabilities, you have to pick one or the other. But - you could split your data into two sourcetypes. For example, instead of mysourcetype, use mysourcetype-XML and mysourcetype-KV. Then your searches could look for sourcetype=mysourcetype* to get both types of data.

Generally, a sourcetype contains data that is syntactically homogeneous, as much as possible.

Another alternative is to use the xmlkv command to parse the XML fields during execution of a particular search.

View solution in original post

0 Karma

lguinn2
Legend

If you want to use Splunk's automatic extraction capabilities, you have to pick one or the other. But - you could split your data into two sourcetypes. For example, instead of mysourcetype, use mysourcetype-XML and mysourcetype-KV. Then your searches could look for sourcetype=mysourcetype* to get both types of data.

Generally, a sourcetype contains data that is syntactically homogeneous, as much as possible.

Another alternative is to use the xmlkv command to parse the XML fields during execution of a particular search.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...