All Apps and Add-ons

Tenable Add-On: How do you extract fields from values (Tenable data, JSON with XML tag inside)?

tlscharlie
New Member

I've got the Tenable Add-On running, and I'm ingesting vulnerability data into Splunk, which is JSON, and Splunk parses it normally and extracts all the fields I need, except for some key value pairs within a set of XML tags, which are all shown as a single value for the field.

"Field1" : "Value1", 
"Field2" : "Value2", 
"Field3" : "FieldA : \n\n
 Fielda : Valuea \n
Fieldb : Valueb \n

So Splunk will extract the JSON field value pairs until it gets to the XML tag, then it treats everything from the tag open to close as a value for "Field3". I've tried a few things with spath etc, but I'm not getting anywhere. Any obvious ideas? The field extractor errors out with an unspecific error when I try to grab anything inside the XML. I appreciate the help!

0 Karma

tlscharlie
New Member

ah, i'm an idiot, the xml tags didn't show after FieldA: and the end.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...