Splunk Dev

Security investigation - Correlating values similar values from different sources

MLGSPLUNK
Path Finder

Hi Community.

My customer is ingesting two sources of data: one from IDP and another from a Firewall. Both are CIM compliant and already are ingested fine.

Both sources have a definition for "high" category of event. The problem is the IDP is sending the value as "high" and the FW is sending it as "High" (different capital letter).

If I want to correlate both sources in one chart, I get one line with high and another with High.

My question is:

- would you change the values at parsing (props.conf, SEGCMD) so correlation is easier for all the future incidents?

- would you change the values at searching time (props.conf) or even at SPL time (EVAL field to make all "high" look like "High").

I'm looking at future consequences of both approaches, efficient-wise and useful-wise.

Thanks in advance.

Labels (1)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @MLGSPLUNK,

I would change on search time in props.conf using EVAL IF. This will save further queries easier and prevents wrong results. SPL solution is more open to error, if somebody didn't now about problems on case sensitivity in stats etc.

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

scelikok
SplunkTrust
SplunkTrust

Hi @MLGSPLUNK,

I would change on search time in props.conf using EVAL IF. This will save further queries easier and prevents wrong results. SPL solution is more open to error, if somebody didn't now about problems on case sensitivity in stats etc.

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

MLGSPLUNK
Path Finder

@scelikok it makes perfect sense. Thanks!

0 Karma
Get Updates on the Splunk Community!

Index This | What did the zero say to the eight?

June 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

Splunk Observability Cloud's AI Assistant in Action Series: Onboarding New Hires & ...

This is the fifth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...