Getting Data In

How to filter Windows Security Event Logs Output?

New Member

Hello, I understand this question had been ask before in varies variations, but I am a newbie and I’m trying to filter out the following information below. I would like to keep everything after Logon Type 3 and before Detail Authentication and if possible filter everything else out. I am using Windows 7 and I don’t have an AD (Active Directory) and Windows Infrastructure won’t work since I don’t have an AD. I’m just using Splunk with add-ons. From the research I’ve done and been unsuccessful with, there is the regex expression or just entering in a better query. If it’s not possible to filter the areas I want out, I would settle for just getting rid of the paragraph at the button starting with: “This event is generated when a logon request fails”
Thank you

03/13/2016 10:57:20 AM
SourceName=Microsoft Windows security auditing.
Keywords=Audit Failure
Message=An account failed to log on

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: pedro 2012
Account Domain:

Failure Information:
Failure Reason: Unknown user name or bad password.
Status: 0xc000006d
Sub Status: 0xc000006a

Process Information:
Caller Process ID: 0x0
Caller Process Name: -

Network Information:
Workstation Name:
Source Network Address: -
Source Port: -

Detailed Authentication Information:
Logon Process: NtLmSsp
Authentication Package: NTLM
Transited Services: -
Package Name (NTLM only): -
Key Length: 0

This event is generated when a logon request fails. It is generated on the computer where access was attempted.

The Subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.

The Logon Type field indicates the kind of logon that was requested. The most common types are 2 (interactive) and 3 (network).

The Process Information fields indicate which account and process on the system requested the logon.

The Network Information fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.

The authentication information fields provide detailed information about this specific logon request.
- Transited services indicate which intermediate services have participated in this logon request.
- Package name indicates which sub-protocol was used among the NTLM protocols.
- Key length indicates the length of the generated session key. This will be 0 if no session key was requested.
host = pedro2012-PC source = WinEventLog:Security sourcetype = WinEventLog:Security

Tags (1)
0 Karma

Super Champion

if its Standard Windows Eventlogs, please use Windows Addon (TA)
This will extract all the fields and is Common Information Model (CIM) compatible for future proof

0 Karma


Hi there mate,

Take a look at this, and you will probably understand how to strip the event as you wish.

This example will remove event description. Add this to your props.conf and restart Splunk.

SEDCMD-del_desc = s/(?mis)This event is generated.*$//g

Or like this, to remove distinct types of event descriptions in the same regex.

SEDCMD-del_desc = s/(?mis)(This event is generated|other_type_of desc_1|other_type_of_desc_2).*$//g

Oh, and remember, events already indexed wont change after this but the new ones does.

Hope it helps and let me know if it works.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...