Splunk Search

Newb - Searching within account_name field of event log

bkeeley
Engager

Hi,

I am trying to search the windows security log for any logs where account_name field contains fire (case insensitive).

sourcetype="WinEventLog:Security" regex Account_Name="/(\w{1,20})?fire(\w{1,20})?/i"

I am using the above search, but it doesn't work. Yet there are accounts which have fire in the name such as Firetestadmin or bluefire123, and there are events for this search.

What am I doing wrong pls?

Thanks

Tags (1)
0 Karma
1 Solution

chris
Motivator

How about:

sourcetype="WinEventLog:Security"  | rex "(?i)Account Name:\s+(?<a_fire_account>.*fire.*)"

I recommend that you download the Splunk for Windows technology add-on:
http://splunk-base.splunk.com/apps/28933/splunk-for-windows-technology-add-on

It does field extractions in windows events for you (so you don't have to worry about rex to much)

Then you can search as follows:

sourcetype="WinEventLog:Security" Account_Name="*fire*"

View solution in original post

JSapienza
Contributor

Try this:

sourcetype="WinEventLog:Security" Account_Name="*fire*"
0 Karma

bkeeley
Engager

Thanks anyway 🙂

0 Karma

JSapienza
Contributor

Looks like chris beat me to it..

0 Karma

chris
Motivator

How about:

sourcetype="WinEventLog:Security"  | rex "(?i)Account Name:\s+(?<a_fire_account>.*fire.*)"

I recommend that you download the Splunk for Windows technology add-on:
http://splunk-base.splunk.com/apps/28933/splunk-for-windows-technology-add-on

It does field extractions in windows events for you (so you don't have to worry about rex to much)

Then you can search as follows:

sourcetype="WinEventLog:Security" Account_Name="*fire*"

bkeeley
Engager

Excellent - Thank you!

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

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

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...