Solved: Re: How can i remove the particular user in table? - Splunk Community

Splunk Search

I have the below query:

| inputlookup test.csv
| eval epochtime=strptime(_time, "%a %b %d %H:%M:%S %Y")
| eval desired_time=strftime(epochtime, "%d/%m/%Y")
| rename desired_time as Date
| eval desired_time=strftime(epochtime, "%b%y'")
| rename desired_time as Month

am getting this output in user field.

user

Abcd101

sv23010

ns03621

here i want to remove the user sv48840,ns19075 row in this table.

1 Solution

Solution

| where user!="sv48840" AND user!="ns19075"

View solution in original post

Solution

| where user!="sv48840" AND user!="ns19075"

Get Updates on the Splunk Community!

Vibe-coding, AI, and Splunkcraft: Highlights from the .conf26 Builder Bar

If you stopped by the Builder Bar at .conf26, thank you! This year, we brought ...

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...