Splunk Search

Filtering data using a second query

jacu86
Engager

I have data in two different applications. I need to get fields from one query to use as filters for another, like this:

```
app=app1 | rex field=environment_url "https:\/\/(?<app_name>.*)\.foo\.com" | where app_name in [ search app=app2 | table app_name ]
```

app2 has a field named app_name which I'm turning into a table. app1 doesn't have this field, but I'm creating and extracting it with a regex. 

I only want the app names from app1 if they exist in the table I'm creating from app2. This query isn't working for me, what can I do? Thank you for any help.

Labels (2)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @jacu86 ,

there's only one attention point: the field used for the filtering must be the same in main and sub search:

app=app1 
| rex field=environment_url "https:\/\/(?<app_name>.*)\.foo\.com" 
| search [ search app=app2 | fields app_name ]

if not, you have to rename it.

One additional hint: use always the index= filter to have faster searches.

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @jacu86 ,

there's only one attention point: the field used for the filtering must be the same in main and sub search:

app=app1 
| rex field=environment_url "https:\/\/(?<app_name>.*)\.foo\.com" 
| search [ search app=app2 | fields app_name ]

if not, you have to rename it.

One additional hint: use always the index= filter to have faster searches.

Ciao.

Giuseppe

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!

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...

Move CrowdStrike FDR ingestion to Data Inputs with a guided migration

CrowdStrike Falcon Data Replicator data is essential for security investigations, detections, and response. It ...

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...