topic Re: Newb - Searching within account_name field of event log in Splunk Search

Newb - Searching within account_name field of event log

bkeeley — Tue, 18 Jun 2013 15:11:58 GMT

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

Re: Newb - Searching within account_name field of event log

chris — Tue, 18 Jun 2013 15:57:56 GMT

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*"

Re: Newb - Searching within account_name field of event log

JSapienza — Tue, 18 Jun 2013 15:58:06 GMT

Try this:

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

Re: Newb - Searching within account_name field of event log

JSapienza — Tue, 18 Jun 2013 15:59:06 GMT

Looks like chris beat me to it..

Re: Newb - Searching within account_name field of event log

bkeeley — Tue, 18 Jun 2013 16:05:34 GMT

Excellent - Thank you!

Re: Newb - Searching within account_name field of event log

bkeeley — Tue, 18 Jun 2013 16:05:54 GMT

Thanks anyway 🙂