Knowledge Management

Add field using eval to existing data model field

tromero3
Path Finder

Hello! I am just starting to work with data models (and eval expressions) and I am a bit stuck.  I have a data model titled "Intrusion" with has 2 diff indexes A & B. Index A events includes a field called "Signature" in the events, but Index B does not. Index B has a field titled "msg" which is similar to the signature field, so I want to add the msg field to the signature field in the data model. 

Currently the data model has "signature" as an eval expression field with the below expression and field settings.  How can I edit the eval expression so that the "msg" field from Index B shows up as the "signature" field in the data model? Or do I need to add a new field/eval expression completely?  Thank you!

Eval Expression:
`if(isnull(signature) OR signature="","unknown",signature)`

Field Name: signature
Display Name: signature
Type: string
Flags: optional

Labels (1)
Tags (3)
0 Karma

anilchaithu
Builder

@tromero3 

A solution would be to rename "msg" field as "Signature". This is called Normalization and is used extensively in to make data CIM compatible..

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