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!

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Get Agentic with Splunk Lantern: Connect to Cisco Cloud Control, Transform ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

July Community Events: Master ITSI 5.0 & Automate Splunk

Struggling with alert fatigue or feeling like you're spending more time on infrastructure maintenance than ...

New Release of Federated Search: Bringing Splunk Analytics to More of Your Data

Organizations today are generating more data than ever and storing it across cloud object stores, data lakes, ...