topic Re: How to remove field values in Splunk Search

How to remove field values

syed_star357 — Tue, 02 Aug 2016 07:34:21 GMT

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

Re: How to remove field values

sundareshr — Tue, 02 Aug 2016 12:23:31 GMT

Try this

index=linux* NOT (sourcetype=UNIX* OR source=UNIX*) | stats latest(_time) as last_time by host source sourcetype | ....

Re: How to remove field values

javiergn — Tue, 02 Aug 2016 12:26:13 GMT

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

Re: How to remove field values

richgalloway — Tue, 02 Aug 2016 12:31:09 GMT

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

Re: How to remove field values

syed_star357 — Tue, 02 Aug 2016 18:35:15 GMT

Thanks, I got the answer for the same query.