Splunk Search

How to remove field values

syed_star357
New Member

Hi,

I want to remove source and source type field value of

Unix:Service
Unix:Uptime
Unix:Version
package
ps

Please help me, how to remove the mentioned field.
Screenshot is attached![alt text][1]

Tags (1)
0 Karma
1 Solution

javiergn
Super Champion
index=linux* 
NOT (sourcetype = "Unix:Service" OR sourcetype = "Unix:Uptime" OR sourcetype = "Unix:Version" OR sourcetype = "package" OR sourcetype = "ps") 
NOT (source = "Unix:Service" OR source = "Unix:Uptime" OR source = "Unix:Version" OR source = "package" OR source = "ps")
| stats max(_time) .... REST OF QUERY HERE

Let me know if that's what you need

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

If by "remove" you intend to delete the data from the Splunk index, then it can't be done. Data in Splunk cannot be modified.
On the other hand, you may be wanting to not show certain fields. That is done with the fields command.

... | field - Unix:Service Unix:Uptime Unix:Version package ps
---
If this reply helps you, Karma would be appreciated.

javiergn
Super Champion
index=linux* 
NOT (sourcetype = "Unix:Service" OR sourcetype = "Unix:Uptime" OR sourcetype = "Unix:Version" OR sourcetype = "package" OR sourcetype = "ps") 
NOT (source = "Unix:Service" OR source = "Unix:Uptime" OR source = "Unix:Version" OR source = "package" OR source = "ps")
| stats max(_time) .... REST OF QUERY HERE

Let me know if that's what you need

0 Karma

syed_star357
New Member

Thanks, I got the answer for the same query.

0 Karma

sundareshr
Legend

Try this

index=linux* NOT (sourcetype=UNIX* OR source=UNIX*) | stats latest(_time) as last_time by host source sourcetype | ....
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...