topic Re: Windows Security Logs: Regex Filtering Search time in Splunk Search

Windows Security Logs: Regex Filtering Search time

arrowsmith3 — Fri, 11 Nov 2011 23:22:25 GMT

I have a windows security event that I am trying to extract a custom field for failed logon events. The problem I have is there are two duplicate categories and the text I am after is in the second category:

Ex:
Subject:
Security ID: S-1-0-0
Account Name: -
Account Domain: -
Logon ID: 0x0
Logon Type: 3
Account For Which Logon Failed:
Security ID: S-1-0-0
Account Name: PCVS Operator
Account Domain: PCVSB681-2

Normally I would just put in rex "Account Name:(?.+)" to extract the content of this field but since there is two of them, is there a way to skip the first field and go directly to the second?

Thanks!

Re: Windows Security Logs: Regex Filtering Search time

_d_ — Sat, 12 Nov 2011 01:56:18 GMT

Try this:

| rex "(?ms)Account Name.*Account Name:(?<account>.+)"

Hope it helps.

> please upvote and accept answer if you find it useful - thanks!

Re: Windows Security Logs: Regex Filtering Search time

arrowsmith3 — Mon, 21 Nov 2011 22:07:06 GMT

Thank you but that didnt work, when I apply that to my search string it will list the entire content of the event.

Any other suggestions?

Re: Windows Security Logs: Regex Filtering Search time

arrowsmith3 — Mon, 21 Nov 2011 22:42:42 GMT

This resolved my question, thanks goes to ziegfried.

rex "(?ms)Account For Which Logon Failed.+?Account Name:\s+(?\V+)"