Splunk Search

How to filter out the account name ending with "$"?

samlinsongguo
Communicator

I have data looks like below

    AccountName
    account1-abc$
    account2-abc$
    account3-xyz$
    account4

I want to filter out the account name end with $ with following query

AccountName!=*$

I expect it only return account4 however it does not return anything. if I do following query

AccountName!=*adc$

it does only return me
account3-xyz$ and account4
Any suggestion why the first search does not do what expected but the second query did what expect? is that because $ is special character?

Thanks in advance

Tags (2)
0 Karma
1 Solution

harishalipaka
Motivator

hi @samlinsongguo

try like this

|makeresults |eval AccountName="account1-abc$" |append [|makeresults |eval AccountName="account2-abc$" ]|append [|makeresults |eval AccountName="account3-xyz$" ]|append [|makeresults |eval AccountName="account4" ] |table AccountName |where NOT  AccountName like ("%$")
*********All the Best***********

View solution in original post

0 Karma

harishalipaka
Motivator

hi @samlinsongguo

try like this

|makeresults |eval AccountName="account1-abc$" |append [|makeresults |eval AccountName="account2-abc$" ]|append [|makeresults |eval AccountName="account3-xyz$" ]|append [|makeresults |eval AccountName="account4" ] |table AccountName |where NOT  AccountName like ("%$")
*********All the Best***********
0 Karma

samlinsongguo
Communicator

tried my log it looks like working thank you for your help

0 Karma
Get Updates on the Splunk Community!

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

How I Instrumented a Rust Application Without Knowing Rust

As a technical writer, I often have to edit or create code snippets for Splunk's distributions of ...