Getting Data In

How to filter Windows Security Event Logs Output?

L06141
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
LogName=Security
SourceName=Microsoft Windows security auditing.
EventCode=4625
EventType=0
Type=Information
ComputerName=pedrt2012-PC
TaskCategory=Logon
OpCode=Info
RecordNumber=43158
Keywords=Audit Failure
Message=An account failed to log on

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: 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: 192.167.1.192
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.
Collapse
host = pedro2012-PC source = WinEventLog:Security sourcetype = WinEventLog:Security

Tags (1)
0 Karma

koshyk
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

alemarzu
Motivator

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.

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

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

[yoursourctype]
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!

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...