Giter VIP home page Giter VIP logo

ta-windnsanalytical's Introduction

TA-windnsanalytical

Based on Jake Walter's Windows DNS Analytical Log App (https://splunkbase.splunk.com/app/2937/ - Version 1.0 Oct. 26, 2015 Initial release)

Subsequent modifications to the original:

  • additional tagging for compatibility with Splunk ES DNS data model
  • performance improvements in log collection (Do not use Get-WinEvent to avoid performance overhead of FormatDescription() method)
  • data reduction: ** no raw packet data returned ** local and low-risk (defined in the script) names/zones are ignored
  • limited performance metrics are returned

(ORIGINAL) ABOUT

The Technology Addon for Windows DNS Analytical logs is designed to be used with Windows DNS servers running on Windows Server 2012 R2 and later. Microsoft has documented a new and recommended method for logging DNS requests using "audit and analytical event logging" as described in this TechNet article:

https://technet.microsoft.com/en-us/library/dn800669.aspx

Analytical logs are written to an event trace log (ETL) and are not able to be read via Splunk's native Windows log monitor. A Powershell script is included that reads the ETL every minute

Lookup tables provide additional data on Windows Event IDs:

https://technet.microsoft.com/en-us/library/dn800669.aspx#analytic

And DNS Resource Record Types:

http://www.iana.org/assignments/dns-parameters/dns-parameters.xhtml#dns-parameters-4

INSTALLATION

Install the TA on the target Windows domain controllers, changing DISABLED = 1 to DISABLED = 0 in inputs.conf.

The TA will modify the log rotation settings and initially clear the existing whenever the Splunk UF starts.

Install the TA on search heads and indexers, as needed.

ta-windnsanalytical's People

Contributors

hkelley avatar

Stargazers

 avatar  avatar  avatar

Watchers

 avatar

ta-windnsanalytical's Issues

props.conf has an invalid regex

Unfortunately this add-on does not work. The error message I see in one of the log files from the UF says

07-14-2020 20:51:22.527 WARN btool-support - Bad regex value: 'Id\s+:\s+(?.*)\s+Message', of param: props.conf / [WinDNS:Analytical] / EXTRACT-win-dns-analytical-event_id; why: unrecognized character after (? or (?-

I tried to modify the regex in question to following
EXTRACT-win-dns-analytical-event_id = Id\s+:\s+?(.*)\s+Message

This stops the warning but I still do not see the logs in Splunk (index is empty with no events). When I run the script manually it executes just fine. I also tried to pass the flag -SplunkdLogging to see if there were any meaningful logs getting emitted from the manual script execution but it was not helpful.

The following is what I see in the splunkd log file but nothing regarding any script execution afterwards -

07-14-2020 23:40:20.774 +0000 INFO ExecProcessor - interval: 60000 ms
07-14-2020 23:40:20.775 +0000 INFO ExecProcessor - New scheduled exec process: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "& 'C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-WinDNSAnalytical\bin\get_dns_analytics.ps1' -SplunkdLogging"
07-14-2020 23:40:20.775 +0000 INFO ExecProcessor - interval: 60000 ms
07-14-2020 23:40:20.775 +0000 INFO ExecProcessor - New scheduled exec process: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "& 'C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-WinDNSAnalytical\bin\init_dns_analytics.ps1'"
07-14-2020 23:40:20.775 +0000 INFO ExecProcessor - interval: run once

Any help would be appreciated.

Only seeing the the following Powershell script related logs in Splunk

I have installed the (TA) add-on on the Domain Controller, where we have the DNS Analytical logs enabled, through Splunk UF using the deployment server, with a minor change in index name in inputs.conf and indexes.conf to use an existing index , instead of creating a new index dns.

But I am only seeing the following events coming into Splunk from that source. Do we need to do anything

INFO [:3240] Script exceeded maximum runtime of . Terminating PID 3240

Please see the image below (scrubbed host information) -

image

Thanks

Powershell script error in splunk logs

Hi hkelley,

Thanks for your work on the app. I have installed the app on splunk forwarder and search head side. When I restart the forwarder services, I am getting following powershell related errors.

Get-WinEvent : No events were found that match the specified selection
criteria.
At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-WindowsDNSAnalytical\b
in\get_dns_analytics.ps1:1 char:1

  • Get-WinEvent -Oldest -LogName "Microsoft-Windows-DNSServer/Analytical ...
  •   + CategoryInfo          : ObjectNotFound: (:) [Get-WinEvent], Exception
      + FullyQualifiedErrorId : NoMatchingEventsFound,Microsoft.PowerShell.Comma 
     nds.GetWinEventCommand
    
    

I am also getting same error when I run the script manually. Have you faced such kind of issue or am I missing any configurations?

Regards,
Vijay

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.