Splunk Search

subsearches

phoenix09
Loves-to-Learn
Spoiler
hello
0 Karma

phoenix09
Loves-to-Learn

As of now I do not have the log for a valid 500 Error

But for the 500 Error which I want to exclude has two events something like below

Spoiler
Date|LOG_LEVEL:INFO|THREAD_NAME:-|CORRELATION:-|MessID:<dynamicvalue>|MESSAGE:LOGTYPE, SERVER=ip, URL=-, URI=-, METHOD=POST, PARA={"MessID":["<dynamicvalue>"],,"Connection":["close"]}, CODE=500, RTIME=342
Spoiler
Date|LOG_LEVEL:ERROR|THREAD_NAME:-|CORRELATION:-|MessID:<dynamicvalue>|MESSAGE:<some message>

In the above "MessID"  value will be the same

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @phoenix09,

it's difficoult to help you without having something to analyze!

the only way is to identify something unique in the logs to discard or to take.

Ciao.

Giuseppe

0 Karma

phoenix09
Loves-to-Learn
Spoiler
The http 500 event which is caused due to an exception has the same fields like the valid http 500 error event. So there is no unique word in the event that I can say NOT "this"
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @phoenix09,

could you share some sample of your events? both correct and not correct.

Ciao.

Giuseppe

0 Karma

phoenix09
Loves-to-Learn
Spoiler

1. I need to create an alert for http 500 failures

2. But I there is this scenario where some http 500 events when triggered, triggers one more event with a message. So I do not want these type of 500 events to be included in the alert

Please help with a query.

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @phoenix09,

did you identified or extracted the message?

if yes, you can simply exclude it from the search: in other words, if the message contains always the word INFO or you extracted the message field, try something like this:

your_search http_response=500 NOT INFO
| ...

or

your_search http_response=500 NOT message=*
| ...

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...