Splunk Search

Remove host name in Account_Name field

Becherer
Explorer

When people RDP into a server, the results I am getting into splunk is Account_Name=Sever1$ Account_Name = jdoe.

When I try to display the data in a table it displays...
Account_Name:
Server1$
jdoe

I want to remove the "Server1$" from field.

One thing I will add, is this only happens sometime and not all of the time. Can there be a wildcard to remove anything before the "$".

Labels (3)
Tags (1)
0 Karma
1 Solution

bmunson_splunk
Splunk Employee
Splunk Employee

There are two ways to fix this. You could change the way the fields are extracted or you can filter them out at search time.
As these are representing machine accounts that may need to be traced at a later date, I would prefer not to stop splunk extracting them.
My preferred way of doing this is with an eval function in search.

   | eval Account_Name=mvfilter(match(Account_Name, ".+[^$]$") )

This is using mvfilter to remove fields that don't match a regex. The regex is looking for .* meaning anything followed by [^$]meaning anything that is not a $ symbol then $ as an anchor meaning that must be the end of the field value.

View solution in original post

bmunson_splunk
Splunk Employee
Splunk Employee

There are two ways to fix this. You could change the way the fields are extracted or you can filter them out at search time.
As these are representing machine accounts that may need to be traced at a later date, I would prefer not to stop splunk extracting them.
My preferred way of doing this is with an eval function in search.

   | eval Account_Name=mvfilter(match(Account_Name, ".+[^$]$") )

This is using mvfilter to remove fields that don't match a regex. The regex is looking for .* meaning anything followed by [^$]meaning anything that is not a $ symbol then $ as an anchor meaning that must be the end of the field value.

Get Updates on the Splunk Community!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...