Splunk Search

Return values in CSV lookup not in index


My CSV has 98 rows and I want the search to return the rows from that csv if they are not in my index=gcp*

what i have here is the opposite, it matches if its in index=gcp* -- i need to flip it basically.

| rename data.jsonPayload.rule_details.reference as FW
| search FW = "network:prod*"
| rex field=FW "network:prod-a/firewall:(?<fw>.*)"
| rex field=FW "network:prod-b/firewall:(?<fw>.*)"
| rex field=FW "network:prod-c/firewall:(?<fw>.*)"
| rex field=FW "network:prod-d/firewall:(?<fw>.*)"
| rex field=FW "network:prod-e/firewall:(?<fw>.*)"
| lookup firewall-exception-prod-num.csv firewall_rule as fw OUTPUT firewall_rule as fw
| dedup fw
| table fw
0 Karma

Ultra Champion

use |inputlookup your_csv

Get Updates on the Splunk Community!

Splunk APM & RUM | Upcoming Planned Maintenance

There will be planned maintenance of the streaming infrastructure for Splunk APM and Splunk RUM in the coming ...

Part 2: Diving Deeper With AIOps

Getting the Most Out of Event Correlation and Alert Storm Detection in Splunk IT Service Intelligence   Watch ...

User Groups | Upcoming Events!

If by chance you weren't already aware, the Splunk Community is host to numerous User Groups, organized ...