Splunk Search

Search WinEventLogs based on user as Variable

cam98
Engager

Hi,

I'm new to Splunk & just getting used to it. I'm trying to search for Windows event logs relative to the "TargetUserName" field in the logs. I'm trying to run a search that shows me user accounts that have had two different event logs associated with it in a 7 day period.

 

The search i'm looking to run is: if a user has had event code 4724 generated and then has event code 4740 occur within 7 days after code 4724 was seen. I was thinking i'd have to define the user name as variable that bring back the results if the event code conditions match (as described above.

 

Or could there be a better way of going about this?

 

Any help is appreciated. Thanks.

Labels (3)

inventsekar
SplunkTrust
SplunkTrust

Hi @cam98 ... all you need is a "Transaction" command (it will work on group of events, we can specify the start and end of the group)... 

the approximate query.. please edit the indexname, sourcetype name as per your design..

index=indexName sourcetype="WinEventLog:Security:VERIFY:this" EventCode=4740 OR EventCode=4771 
| transaction startswith=eval(EventCode=4771) endswith=eval(EventCode=4740) maxspan=7d maxevents=15

 

~Happy Splunking | Best Regards | Sekar | PS - Karma points appreciated!

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma
Get Updates on the Splunk Community!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...