Splunk Search

How to filter out one field events base on other field with two events?

Rithekakan
Path Finder

Hi All,
I have this report 

Rithekakan_2-1657294246159.png

 

My requirement is only show in table those event that do not have the Plugin Name = "TLS Version 1.1 Protocol Deprecated"  with the Port= 8443 OR =8444 as I have fill color with yellow. But, still keep show the event  that have Plugin Name = "TLS Version 1.1 Protocol Deprecated " with other Port exclude Port 8443 OR 8444.
I am using below search

Rithekakan_3-1657294973102.png

and the result show only Plugin Name = "TLS Version 1.1 Protocol Deprecated " with other port exclude Port 8443 OR 8444.
I want a result show all Plugin Name...... exclude Plugin Name = "TLS Version 1.1 Protocol Deprecated"  that have  Port= 8443 OR =8444
Any suggestions?

Labels (3)
Tags (2)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

The logic regarding the Port field is incorrect.  (Port!=8443 OR Port!=8444) will not exclude anything because every port number is either not 8443 or not 8444.  Perhaps (Port!=8443 AND Port!=8444) is what was intended?  Another way to write it is NOT (Port=8443 OR Port=8444)

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

The logic regarding the Port field is incorrect.  (Port!=8443 OR Port!=8444) will not exclude anything because every port number is either not 8443 or not 8444.  Perhaps (Port!=8443 AND Port!=8444) is what was intended?  Another way to write it is NOT (Port=8443 OR Port=8444)

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...