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!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...