Monitoring Splunk

How do I remove multiple relevant URLs from column field of splunk query output

sivashanmugam
Engager

FYI -- Red marked URLs from the attached image should be remove from the output of splunk query which I shared below ..Please someone help for the same.

Query used  in environment
=====================
index=claims_pd env=pd_cloud_e sourcetype=claims:cif:ibuapps "https://" NOT "*.gco.net" NOT "*.gcoddc.net" NOT "*gco.net"
| rex field=_raw "(?<externalURL>https:\/\/.[^\s]+)"
| stats values(externalURL) as externalURL,list(ResponseMessage) as ResponseMessage, count by ServiceName
| sort 0 - count
| dedup externalURL
|append
[search sourcetype=claims:cif:ibuapps "javax.net.ssl.SSLException" OR "javax.net.ssl.SSLHandshakeException" OR "Unable to tunnel through proxy" OR "HTTP response '400: Bad Request'" OR "(504)Gateway Timeout" OR "Access is denied" AND (ServiceName OR (doFinally AND "method:handleErrorResponse"))
| stats list(ResponseMessage) as ResponseMessage, count by ServiceName
| sort - count
| return ResponseMessage]

Labels (1)
0 Karma
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...