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!

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

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...