--- title: "Microsoft IAS (database compatible) log format and field mapping" slug: "microsoft-ias-database-compatible-log-format-and-field-mapping" tags: ["ESM", "Reference"] updated: 2026-10-27T15:50:49Z published: 2026-10-27T15:50:49Z canonical: "docs.trellix.com/microsoft-ias-database-compatible-log-format-and-field-mapping" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Microsoft IAS (database compatible) log format and field mapping **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 | :