Getting Data In

Windows DNS Logs


Using splunk 6.0.1 - trying to do some testing with Windows DNS logs to see if can get the data formatted and dropping events we dont want to keep. I found some answers on the splunk site, but either I have something misconfigured, I am missing something or some other issue is cropping up, I an unable to get the SDECMD and the TRANSFORM to both work. We have a TRANSFORM that will drop certain events - this is working. We also want to add in the SEDCMD which will change the output from (3)www(3)ibm(3)com type output to be output. The SEDCMD part is not working. Is this because of a misconfiguration on my part, is it due to already having data that is indexed or something else? This is my first foray into using splunk. Was able to set up Windows DHCP logs pretty quickly. I created a basic app for the windows dns logs to do some testing. I have tried different options with getting the SEDCMD working. Can anyone help?

Tags (1)
0 Karma


This should probably be titled "DNS transformations and filtering". "Windows DNS Logs" gives the implication that there will be discussion of the meanings and interpretations of the logs themselves.

0 Karma


Thanks for the responses.

I finally got mine to work. I had to modify my transforms to use the modified output after my SEDCMD.

Now I have the other issue with the dns logs not being recreated. Do you have that same issue? Are you using the Windows app for your logs?

0 Karma


Here's what I've got in mine and it's working:

These files are to be installed on the indexers...


SEDCMD-win_dns = s/\(\d+\)/./g
EXTRACT-src_ip-fqdn = Rcv\s(?P[^\s]+)\s+.+]\s(?P[^\s]+)\s+\.(?P[^\s]+)\.$
TRANSFORMS-windns = windnsnull


REGEX = (^[^\d]|IN-ADDR|in-addr|\sSnd\s|\sR\sQ\s|\.ip6\.arpa|NXDOMAIN|windowsupdate\.com)
DEST_KEY = queue
FORMAT = nullQueue

0 Karma

New Member

I followed and copied exactly the props.conf and transforms.conf

but I am still not able to extract and remove the (3)www(3)ibm(3)com

Not sure what I am missing; I am on a clustered index.

My index are dns and also created win_dns just to follow the examples.

Am I doing something wrong?

0 Karma

Path Finder

Kormot, try this for the SEDCMD in your props:

SEDCMD-win_dns = s/\(\d+\)/./g

Note the escaped parenthesis and the \ before the d as well. These look to be missing from wbfoxii's props.conf due to formatting.

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...