News and blog
NXLog main page
  • Products
    NXLog Platform
    Log collection
    Log management and analytics
    Log storage
    NXLog Community Edition
    Integrations
    Professional Services
  • Solutions
    Use cases
    Specific OS support
    SCADA/ICS
    Windows event log
    DNS logging
    MacOS logging
    Solutions by industry
    Financial Services
    Government & Education
    Entertainment & Gambling
    Telecommunications
    Medical & Healthcare
    Military & Defense
    Law Firms & Legal Counsel
    Industrial & Manufacturing
  • Plans
  • Partners
    Find a Reseller
    Partner Program
  • Resources
    Documentation
    Blog
    White papers
    Videos
    Webinars
    Case Studies
    Community Program
    Community Forum
  • About
    Company
    Careers
  • Support
    Support portals
    Contact us

NXLog Platform
Log collection
Log management and analytics
Log storage
NXLog Community Edition
Integrations
Professional Services

Use Cases
Specific OS support
SCADA/ICS
Windows event log
DNS logging
MacOS logging
Solutions by industry
Financial Services
Government & Education
Entertainment & Gambling
Telecommunications
Medical & Healthcare
Military & Defense
Law Firms & Legal Counsel
Industrial & Manufacturing


Find a Reseller
Partner Program

Documentation
Blog
White papers
Videos
Webinars
Case Studies
Community Program
Community Forum

Company
Careers

Support portals
Contact us
Let's Talk Start free
NXLog search
  • Loading...
Let's Talk Start free
February 1, 2021 siem

Sending logs to Microsoft Sentinel with NXLog

By John Kirch

Share
ALL SIEM STRATEGY SECURITY ANNOUNCEMENT DEPLOYMENT COMPLIANCE COMPARISON RSS

What if you could selectively ingest only the high-quality events needed for metrics and reporting that come not only from Azure, but also from other cloud- based resources and on-site assets directly into Microsoft Sentinel?

In this post, the technology we will be examining is the Azure Monitor HTTP Data Collector API, which enables clients, such as the NXLog Enterprise Edition agent, to send events to a Log Analytics workspace, making them directly accessible using Microsoft Sentinel queries.

We will present two examples of sending logs to Microsoft Sentinel: in the first one, we send Windows DNS Server logs and in the second one, Linux kernel audit logs. Both of these log sources are of interest from a security perspective.

Proactive monitoring of DNS activity can help network administrators quickly detect and respond to attempted security breaches in DNS implementations that might otherwise lead to data theft, denial-of-service, or other service disruptions related to malicious activity.

In comparison, Linux Audit has a much wider scope and could arguably be called the most comprehensive tool for monitoring and reporting security events on Linux distributions.

About NXLog Enterprise Edition

If you aren’t familiar with the NXLog Enterprise Edition, it is a full-featured log processing agent with a small footprint. It can read and write all standard log formats and integrates with over 100 third-party products. It offers many additional features not found in the free Community Edition. To evaluate the configurations presented in this post, download the appropriate trial edition for your platform. For more information on supported platforms and how to install an agent, see the NXLog Deployment chapter of the NXLog EE User Guide.

Collecting DNS Server logs via Windows Event Tracing

Event Tracing for Windows (ETW) provides not only efficient logging of both kernel and user-mode applications but also access to the Debug and Analytical channels that are not available through Windows Event Log channels (which also contains some DNS Server logs).

Authentication

The pivotal part of sending secure HTTPS requests to Azure is the authentication process. Azure validates the values of two custom HTTP headers, Authorization and x-ms-date along with the length of the data payload to determine if the request is authentic. The value assigned to the Authorization header is dynamically generated using a cryptographic hash. For details, see the Azure Monitor Authorization section in the Microsoft documentation.

Capturing ETW events - The input side

NXLog can natively collect ETW logs without the need to capture the trace into an .etl file. Configuring an NXLog agent to capture Windows DNS Server events using the Event Tracing for Windows (im_etw) input module is fairly straightforward as illustrated here:

nxlog.conf (Section: DNS_Logs input instance)
<Extension _json>
    Module      xm_json
</Extension>

<Input DNS_Logs>
    Module      im_etw
    Provider    Microsoft-Windows-DNSServer
    <Exec>
                to_json();
                $Table = "DNS_Logs";
    </Exec>
</Input>

The Exec statement of the DNS_Logs input instance above invokes the to_json() procedure, which converts the Windows events to JSON records, as required by Azure’s HTTP Data Collector API.

Additionally, the Table variable is defined which allows for multiple inputs to be defined with their own table name while pointing towards a single output instance.

Sending ETW events - The output side

The output module is the part that connects directly to Azure. The first step in configuring the output instance is retrieving the Workspace ID and either the Primary key or the Secondary key (also referred to as the shared key). These keys can be found by navigating in the Azure portal to Log Analytics workspace > Settings > Agents management. The same set of keys can be viewed under either the Windows servers or Linux servers tab.

Log analytics > Workspace > Agents management

The next step is to add this information to the nxlog.conf file as constants making them accessible to the output instance.

The SUBDOMAIN, RESOURCE, and APIVER are used to construct the complete URL. The value for SIZELIMIT can be tuned to your needs. It represents the maximum size in bytes of the data payload for each batch of events. 65000 is the upper limit. The higher values mean better network efficiency. Lower values mean events can be received faster because they are not waiting for a large buffer to be full before they can be sent.

nxlog.conf (Section: Defining Constants)
define WORKSPACE        18fb21ab-d8d4-4448-bdf6-3748c9c03135
define SHAREDKEY        VfIQqBoz6fxmnI/E4PKVPza2clH/YAdJ20RnCDwzHCqCMnobYdM1/dD1+KJ6cI6AkR4xPJlTIWI/jfwPU6QHmw==
define SUBDOMAIN        ods.opinsights.azure.com
define RESOURCE         api/logs
define APIVER           api-version=2016-04-01
define SIZELIMIT        65000

When looking at the entire output instance that uses the Microsoft Sentinel (om_azure) module, you can see how batches of events are buffered and then flushed:

nxlog.conf (Section: DNS_Logs output instance)
<Output Azure>
    Module                 om_azure
    URL                    https://%WORKSPACE%.%SUBDOMAIN%/%RESOURCE%?%APIVER%
    WorkspaceID            %WORKSPACE%
    SharedKey              %SHAREDKEY%
    TableName              $Table
    HTTPSCAFile            %INSTALLDIR%\cert\ca-certificates.crt
</Output>

<Route DNS_Logs_Route>
    Path                   DNS_Logs => Azure
</Route>

Since all REST API events are categorized by Azure Monitor as Custom Logs, Azure appends _CL to the value of TableName in order to prevent naming conflicts with other Azure tables thus the name we originally chose, DNS_Logs, appears in Microsoft Sentinel as DNS_Logs_CL.

Configuration checklist

To prepare for testing, let’s run through the steps needed to ensure success:

  1. Download/view the entire nxlog.conf configuration file and append its contents to your current C:\Program Files\nxlog\conf\nxlog.conf NXLog configuration file.

  2. Ensure that you have changed the values of WORKSPACE and SHAREDKEY to match those of your Log Analytics workspace as well as defining the Table variable in your Input section.

To test DNS Server logging of audit events, we added an A record for R04LRC13.example.com and reloaded the example.com zone. This logs an event with EventID 515 (Record Create) and another one with EventID 561 (Zone Reload).

Now it’s time to log into the Azure Log Analytics workspace that was defined in the DNS_Logs output instance and open Logs. After expanding Custom Logs the DNS_Logs_CL should be visible. With a simple query, the newly ingested events are visible.

DNS_Logs_CL events ingested

Expanding the first event’s details shows the complete set of fields and their values:

DNS_Logs_CL event details A
DNS_Logs_CL event details B

For testing purposes, you may want to add a temporary output instance for validating the integrity of your configuration. This lets you compare the events and their fields with what Microsoft Sentinel is ingesting. As you can see here, by adding a new output instance named TempFile as an additional destination to the route, this allows you to view the events in JSON format that will be stored in the file defined by the File directive.

nxlog.conf (Section: file output instance and modified route)
<Output TempFile>
    Module    om_file
    File      'C:\Program Files\nxlog\data\dnsetw.json'
</Output>

<Route DnsRoute1>
    Path      DNS_Logs => Azure, TempFile
</Route>
Pretty-printed JSON of the captured DNS Server audit event record
{
  "SourceName": "Microsoft-Windows-DNSServer",
  "ProviderGuid": "{EB79061A-A566-4698-9119-3ED2807060E7}",
  "Channel": "Microsoft-Windows-DNS-Server/Analytical ",
  "Category": "LOOK_UP ",
  "EventID": 257,
  "Version": 0,
  "ChannelID": 16,
  "OpcodeValue": 0,
  "TaskValue": 1,
  "Keywords": "9223372036854775810",
  "EventTime": "2022-02-16T12:03:08.244340-08:00",
  "ExecutionProcessID": 1432,
  "ExecutionThreadID": 2220,
  "EventType": "INFO",
  "SeverityValue": 2,
  "Severity": "INFO",
  "Hostname": "WIN-H1ICAKR5GAA",
  "Domain": "NT AUTHORITY",
  "AccountName": "SYSTEM",
  "UserID": "S-1-5-18",
  "AccountType": "User",
  "Flags": "33152",
  "TCP": "0",
  "InterfaceIP": "127.0.0.1",
  "Destination": "127.0.0.1",
  "AA": "0",
  "AD": "0",
  "QNAME": "cc6247e7-6230-44cd-84fb-819413026e8b.ods.opinsights.azure.com.",
  "QTYPE": "1",
  "XID": "11165",
  "DNSSEC": "0",
  "RCODE": "0",
  "Port": "49893",
  "Scope": "Default",
  "Zone": "..Cache",
  "BufferSize": "174",
  "PacketData": "0x2B9D818000010003000000002463633632343765372D363233302D343463642D383466622D383139343133303236653862036F64730A6F70696E73696768747305617A75726503636F6D0000010001C00C00050001000000B2001F0A7775732D6F692D6F64730E747261666669636D616E61676572036E657400C05B000500010000000700180C7775732D6F692D6F64732D6108636C6F7564617070C075C086000100010000000800040D56DAE3",
  "EventReceivedTime": "2022-02-16T12:03:10.213097-08:00",
  "SourceModuleName": "DNS_Logs",
  "SourceModuleType": "im_etw",
  "DNS_LogType": "Analytical"
}

Troubleshooting

If you are unable to see any events arriving in your Microsoft Sentinel table, try these troubleshooting steps:

  • Look at the NXLog internal log file for clues which is located in C:\Program Files\nxlog\data\nxlog.log on Windows. Success should look like this:

2022-02-15 13:33:32 INFO [CORE|main] nxlog-5.4.7313 started on Windows
2022-02-15 13:33:32 INFO [om_azure|azure] connecting to 18fb21ab-d8d4-4448-bdf6-3748c9c03135.ods.opinsights.azure.com(13.86.218.227):443
2022-02-15 13:33:32 INFO [om_azure|azure] successfully connected to 18fb21ab-d8d4-4448-bdf6-3748c9c03135.ods.opinsights.azure.com(13.86.218.227):443
2022-02-15 13:37:41 INFO [om_azure|azure] reconnecting to 18fb21ab-d8d4-4448-bdf6-3748c9c03135.ods.opinsights.azure.com(13.86.218.227):443 (last connection attempt was 248 sec ago)
2022-02-15 13:37:41 INFO [om_azure|azure] connecting to 18fb21ab-d8d4-4448-bdf6-3748c9c03135.ods.opinsights.azure.com(13.86.218.227):443
2022-02-15 13:37:41 INFO [om_azure|azure] successfully connected to 18fb21ab-d8d4-4448-bdf6-3748c9c03135.ods.opinsights.azure.com(13.86.218.227):443
  • For missing data or errors please refer to C:\Program Files\nxlog\data\nxlog.log and observe any conditions such as the WORKSPACE key being incorrect.

  • Make sure the input instance is correctly configured and that events are actually being captured by adding an additional output instance for logging them to a local temporary file as demonstrated above.

Including DNS Server analytical logs captured with ETW

If analytical event logging is enabled, you can capture and view DNS Sever analytical events having EventIDs ranging from 256 to 286. Technically, no further changes are needed for logging and viewing both audit and analytical events in Azure Sentinel. However, there is one enhancement you might want to implement:

Enrich the schema with a new attribute: DNS_LogType. If you need to frequently differentiate between audit and analytical DNS Server events, querying for a range of values on a regular basis is not only tedious and makes queries less readable, but it can also be slower on large data sets. This is as simple as replacing the original Exec to_json(); with an Exec block that sets the new $DNS_LogType field to either Audit or Analytical depending on the value of EventID before calling the to_json() which will then enrich the schema with this new field.

nxlog.conf (DNS_Logs input instance)
<Input DNS_Logs>
    Module      im_etw
    Provider    Microsoft-Windows-DNSServer
    <Exec>
        if $EventID >= 256 and $EventID <= 286 $DNS_LogType = 'Analytical';
        if $EventID >= 512 and $EventID <= 596 $DNS_LogType = 'Audit';
        to_json();
        $Table = "DNS_Logs";
    </Exec>
</Input>
DNS_Logs_CL Audit and Analytical Combined

Download/view the entire nxlog.conf configuration file.

Collecting Linux Audit logs

In this section we examine Linux Audit logs and how they can be sent to Microsoft Sentinel. Since the prerequisites of data format (JSON), transport (HTTPS REST API with some special headers), and authentication (single-use cryptographic hash) are the same for sending Linux log sources to Azure Sentinel, we are now free to focus on the log source itself and the minor differences between a Windows deployment and a Linux deployment.

The Linux Audit system provides fine-grained logging of security related events. These logs can also provide a wealth of security information: changes to DNS zone files, system shutdowns, attempts to access unauthorized files, and other suspicious activity. The NXLog Enterprise Edition includes the im_linuxaudit module for directly accessing the kernel component of the Audit System. With this module, NXLog can be configured to build Audit rules and collect logs without requiring auditd or any other user-space software.

Capturing Linux Audit events - The input side

Let’s take a look at the configuration file to see how the input module is configured and how the rules are defined.

nxlog.conf (Section: LinuxAudit input instance)
<Extension _resolver>
    Module           xm_resolver
</Extension>

<Input LinuxAudit>
    Module           im_linuxaudit
    FlowControl      FALSE
    LoadRule         %INSTALLDIR%/etc/im_linuxaudit.rules
    ResolveValues    TRUE
    <Exec>
                     to_json();
                     $Table = "LinuxAudit";
    </Exec>
</Input>

Instead of defining a small set of audit rules within a Rules block directly in the LinuxAudit input instance, we use the LoadRule directive to load a more comprehensive collection of rules in an audit rule file which is based on the ruleset maintained by the Best Practice Auditd Configuration project.

The xm_resolver module is needed for the ResolveValues directive in the audit input instance, where it is used for resolving some of the numeric values to more human-readable string values.

Sending Linux Audit events - The output side

As with the Windows example, ensure that the required values are properly configured and proceed to name the Table accordingly, in our case we are using LinuxAudit as the name.

nxlog.conf (Section: LinuxAudit output instance)
<Output Azure>
    Module              om_azure
    URL                 https://%WORKSPACE%.%SUBDOMAIN%/%RESOURCE%?%APIVER%
    WorkspaceID         %WORKSPACE%
    SharedKey           %SHAREDKEY%
    TableName           $Table
    HTTPSCAFile         /etc/ssl/certs/ca-certificates.crt
</Output>

Download/view the nxlog.conf configuration file.

Once these changes have been implemented and the NXLog service has been restarted, events should be sent to the LinuxAudit_CL Microsoft Sentinel table. The following JSON event was triggered and captured according to the very last line in the im_linuxaudit.rules file.

Pretty-printed JSON of the captured Linux Audit event record
{
  "type": "PATH",
  "time": "2022-02-16T14:37:59.760000-08:00",
  "seq": 347,
  "item": 0,
  "name": "/usr/sbin/ifconfig",
  "inode": 925926,
  "dev": "08:01",
  "mode": "file,755",
  "ouid": "root",
  "ogid": "root",
  "rdev": 0,
  "nametype": "NORMAL",
  "cap_fp": 0,
  "cap_fi": 0,
  "cap_fe": 0,
  "cap_fver": 0,
  "Hostname": "debian-10-main",
  "EventReceivedTime": "2022-02-16T14:37:59.764419-08:00",
  "SourceModuleName": "LinuxAudit",
  "SourceModuleType": "im_linuxaudit"
}

Upon successful receipt in the Log Analytics workspace by Azure Monitor, events are further processed and finally ingested by Microsoft Sentinel where they can be viewed via user-defined queries.

LinuxAudit_CL events ingested

After expanding the following event to reveal its columns and their values, it can be verified against the JSON formatted event above that was sent via the REST API.

LinuxAudit_CL event ingested A
LinuxAudit_CL event ingested B

Summary

Given the configuration samples and use cases presented here, you should now possess the basic information needed to benefit from these additional security monitoring opportunities in your own enterprise. To recap, the main advantages are:

  • Event Tracing for Windows (ETW) offers better performance because it doesn’t need to capture the trace into an .etl file and provides access to Debug and Analytical channels

  • The native NXLog Linux Audit input module that works out of the box without the need to install auditd and when coupled with the NXLog Resolver extension module can resolve IP addresses as well as group/user IDs to their respective names, making Linux audit logs more intelligible to security analysts

  • A general-purpose output configuration enabling Microsoft Sentinel to ingest events from multiple, diverse log sources simultaneously, from any host in your enterprise having outbound access to Azure

GET STARTED TODAY:
CONTACT US Our experts are happy to help REQUEST A FREE TRIAL Give NXLog Enterprise Edition a try GET PRICING Request a quote
  • siem
  • microsoft sentinel
  • log forwarding
Share

Facebook Twitter LinkedIn Reddit Mail
Related Posts

How a centralized log collection tool can help your SIEM solutions
5 minutes | April 1, 2020
Sending ETW Logs to Splunk with NXLog
5 minutes | March 3, 2020
DNS Log Collection on Windows
8 minutes | May 28, 2020

Stay connected:

Sign up

Keep up to date with our monthly digest of articles.

By clicking singing up, I agree to the use of my personal data in accordance with NXLog Privacy Policy.

Featured posts

Announcing NXLog Platform 1.6
April 22, 2025
Announcing NXLog Platform 1.5
February 27, 2025
Announcing NXLog Platform 1.4
December 20, 2024
NXLog redefines log management for the digital age
December 19, 2024
2024 and NXLog - a review
December 19, 2024
Announcing NXLog Platform 1.3
October 25, 2024
NXLog redefines the market with the launch of NXLog Platform: a new centralized log management solution
September 24, 2024
Welcome to the future of log management with NXLog Platform
August 28, 2024
Announcing NXLog Enterprise Edition 5.11
June 20, 2024
Raijin announces release of version 2.1
May 31, 2024
Ingesting log data from Debian UFW to Loki and Grafana
May 21, 2024
Announcing NXLog Enterprise Edition 6.3
May 13, 2024
Raijin announces release of version 2.0
March 14, 2024
NXLog Enterprise Edition on Submarines
March 11, 2024
The evolution of event logging: from clay tablets to Taylor Swift
February 6, 2024
Migrate to NXLog Enterprise Edition 6 for our best ever log collection experience
February 2, 2024
Raijin announces release of version 1.5
January 26, 2024
2023 and NXLog - a review
December 22, 2023
Announcing NXLog Enterprise Edition 5.10
December 21, 2023
Raijin announces release of version 1.4
December 12, 2023
Announcing NXLog Enterprise Edition 6.2
December 4, 2023
Announcing NXLog Manager 5.7
November 3, 2023
Announcing NXLog Enterprise Edition 6.1
October 20, 2023
Raijin announces release of version 1.3
October 6, 2023
Upgrading from NXLog Enterprise Edition 5 to NXLog Enterprise Edition 6
September 11, 2023
Announcing NXLog Enterprise Edition 6.0
September 11, 2023
The cybersecurity challenges of modern aviation systems
September 8, 2023
Raijin announces release of version 1.2
August 11, 2023
The Sarbanes-Oxley (SOX) Act and security observability
August 9, 2023
Log Management and PCI DSS 4.0 compliance
August 2, 2023
Detect threats using NXLog and Sigma
July 27, 2023
HIPAA compliance logging requirements
July 19, 2023
Announcing NXLog Enterprise Edition 5.9
June 20, 2023
Industrial cybersecurity - The facts
June 8, 2023
Raijin announces release of version 1.1
May 30, 2023
CISO starter pack - Security Policy
May 2, 2023
Announcing NXLog Enterprise Edition 5.8
April 24, 2023
CISO starter pack - Log collection fundamentals
April 3, 2023
Raijin announces release of version 1.0
March 9, 2023
Avoid vendor lock-in and declare SIEM independence
February 13, 2023
Announcing NXLog Enterprise Edition 5.7
January 20, 2023
NXLog - 2022 in review
December 22, 2022
Need to replace syslog-ng? Changing to NXLog is easier than you think
November 23, 2022
The EU's response to cyberwarfare
November 22, 2022
Looking beyond Cybersecurity Awareness Month
November 8, 2022
GDPR compliance and log data
September 23, 2022
NXLog in an industrial control security context
August 10, 2022
Raijin vs Elasticsearch
August 9, 2022
NXLog provides native support for Google Chronicle
May 11, 2022
Aggregating macOS logs for SIEM systems
February 17, 2022
How a centralized log collection tool can help your SIEM solutions
April 1, 2020

Categories

  • SIEM
  • STRATEGY
  • SECURITY
  • ANNOUNCEMENT
  • DEPLOYMENT
  • COMPLIANCE
  • COMPARISON
logo

Subscribe to our newsletter to get the latest updates, news, and products releases. 

© Copyright 2024 NXLog FZE.

Privacy Policy. General Terms of Use

Follow us

  • Product
  • NXLog Platform 
  • Log collection
  • Log management and analysis
  • Log storage
  • Integration
  • Professional Services
  • Plans
  • Resources
  • Documentation
  • Blog
  • White papers
  • Videos
  • Webinars
  • Case studies
  • Community Program
  • Community forum
  • Support
  • Getting started guide
  • Support portals
  • About NXLog
  • About us
  • Careers
  • Find a reseller
  • Partner program
  • Contact us