Microsoft IAS (database compatible) log format and field mapping

Prev Next

Log format

The expected format for this device is:

"ComputerName"," ServiceName", Record-Date, Record-Time, Packet-Type," User-Name","
Fully-Qualified-Distinguished-Name"," Called-Station-ID"," Calling-Station-ID", Callback-Number,
Framed-IP-Address," NAS-Identifier"," NAS-IP-Address",NAS-Port, Client-Vendor,"Client-IP-Address","
Client-Friendly-Name", Event-Timestamp, Port-Limit, NAS-Port-Type,Connect-Info,Framed-Protocol,Service-Type,
Authentication-Type,"Policy-Name",Reason-Code,"Clas s",Session-Timeout,Idle-Timeout,Termination-Action,
EAP-Name,Acc-Status-Type,Acc-Delay-Time,Acc-Input-Octets ,Acc-Output-Octets,Acc-Session-ID,Acc-Authentic,
Acc-Input-Packet,Acc-Output-packet,acc-terminate-Cause,ac c-multi-ssn-ID,acc-link-Count,Acc-Interim-Interval,
tunnel-type,tunnel-medium-type,tunnel-client-endpoint,tu nnel-server-endpoint,Acc-tunnel-conn,tunnel-pvt-group-ID,
"tunnel-assignment-id",Tunnel-Preference,MS-acc-au th-type,MS-acc-EAP-Type,MS-RAS-Version,MS-RAS-Vendor,
MS-CHAP-Error,MS-CHAP-Error,MS-CHAP-Domain,MS-MPPE-Enc ryption-Types,MS-MPPE-Encryption-Policy,
"Proxy-Policy-Name:MSG",Provider-Type,Provider-Name,Remote-Server-IP,MS-RAS-CLient-Name,MS-RAS-Client-Version

Log sample

This is a sample log from a Microsoft IAS device:

"TestHost","IAS",01/01/2016,00:00:00,4,"EXAMPLE\Test.User",,"192.0.2.1","192.0.2.2",,"192.0.2.2",
"TestIdentifier","192.0.2.1",1,9,"192.0.2.1","TestClient",,,,,,,,,0,,,,,,1,,,,,1,,,,,,,,13,6,,,,
"110",,,,,,,,,,,"Use Windows authentication for all users",,,,,"TestHost","IAS",01/01/2016,00:00:001,
"EXAMPLE\Test.User","EXAMPLE \Test.User","0F-0F-0F-0F-0F-0F:EXAMPLE-Host","0A-0A-0A-0A-0A-0A",,,
"TestIdentifier","192.0.2.1",1,9,"192.0.2.1","TestClient",,,19,,,,11,,0,,,,,,,,,,,,,,,,,,13,6,,,,
"190",,,,,,,,,,,"NAP 802.1X (Wireless)",1,,,,

Field mapping

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

Log fields

Trellix ESM fields

Client

Domain

username

Source User

Record-Date+Record-Time

First Time, Last Time

IAS

Application

Hostname

Host

Policy-Name

Policy_Name

Packet-type

Event Subtype

Tunnel-client-endpoint address

Source IP

Reason-Code

Reason

Packet-Type+99+Reason-Code

Signature ID

ComputerName

Destination Host

ServiceName

Service_Name

Event-Timestamp

First Time, Last Time

Domain, FQ-Domain, MS-CHAP-DOMAIN

Domain

User-Name, FQ-Distinguished-Name

Source User

Called-Station-ID

Destination MAC

Class (IP Address)

Destination IP

NAS-Identifier

External_Device_ID

NAS-IP-Address, Client-IP-Address

Device_IP

Calling-Station-ID

Source MAC

Framed-IP-Address

Source IP

Calling-Station-ID (IP Address)

Source IP

Connect-Info

Message_Text

Acct-Session-Id

Session