Microsoft Windows DHCP log format and field mapping

Prev Next

Log format

For platforms earlier than Windows Server 2008: the expected format for this device is:

ID,Date,Time,Description,IP Address,Host Name,MAC Address,

The expected format for this device is as follows for Windows Server 2008 and 2008 R2

ID,Date,Time,Description,IP Address,Host Name,MAC Address,User Name,TransactionID,QResult,Probationtime,
CorrelationID,

The expected format for this device is as follows for Windows Server 2012 and above:

ID,Date,Time,Description,IP Address,Host Name,MAC Address,User Name, TransactionID,QResult,Probationtime,
CorrelationID,Dhcid,VendorClass(Hex),VendorClass(ASCII),UserClass(Hex),UserClass(ASCII),RelayAgentInformati on,DnsRegError

Log sample

This is a sample log from a Windows Server 2003 DHCP device:

35,01/01/01,01:01:01,DNS update request failed,192.0.2.1,sampleHost,000000000000,

This is a sample log from a Windows Server 2008 DHCP device:

10,01/01/01,01:01:01,Assign,192.0.2.10,sampleHost1,000000000000,,17739,0,,,

This is a sample log from a Windows Server 2012 R2 DHCP device:

10,01/01/01,01:01:01,Assign,192.0.2.20,sampleHost2, 000000000000,,3096562285,0,,,,0x4D53465420352E30,MSFT5.0,,,,0

Field mapping

This table shows the mapping between the data source and Trellix ESM fields.

Log Fields

Trellix ESM Fields

ID

Sid

IP Address

Source IP

Host Name

Host

MAC Address

Source MAC

Date + Time

First Time, Last Time

TransactionID

Session ID

User Name

Source User

QResult

Return_Code

VendorClass(ASCII)

External_Device_Name

DnsRegError

DNS – Response_Code