All Apps and Add-ons

Nested JSON from aws config logs not properly extracted for app

rwardwell
Explorer

AWS config logs are not being parsed properly for the AWS app. The full json elements are being included in the field names so I have fields that look like:
detail.configurationItem.availabilityZone

detail.configurationItem.awsAccountId

detail.configurationItem.awsRegion
detail.configurationItem.configuration.activeTrustedSigners.enabled
detail.configurationItem.configuration.activeTrustedSigners.quantity
detail.configurationItem.configuration.allocatedStorage
detail.configurationItem.configuration.amiLaunchIndex

detail.configurationItem.configuration.architecture

And I need to get rid of the detail.configurationItem.*. I can use rename to do this but that only works at search time. There are also about 1000 fields so entering them all as field aliases isn't an option.

Has anyone seen this before or have any suggestions how to remove the top level elements from the field name.

0 Karma

Nanda
Loves-to-Learn Lots

Can you please share your solution if you managed to fixed it ?

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 ...