Microsoft IIS log format and field mapping

Prev Next

Log format

The expected formats for this device are:

WC3

date time s-sitename s-computername s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username 
c-ip cs-version cs(User-Agent) cs(Cookie) cs(Referer) cs-host sc-status sc-substatus sc-win32-status 
sc-bytes cs-bytes time-taken

NCSA

Remote_host_address Remote_log_name User_name [Date/time Greenwich mean time (GMT) offset] 
"Request and protocol version" Service_status_code Bytes_sent

IIS

Client_IP_address, User_name, Date, Time, Service_and_instance, Server_name, Server_IP, Time_taken, 
Client_bytes_sent, Server_bytes_sent, Service_status_code, Windows_status_code, Request_type, Target_of_operation, Parameters,

Advanced Logging

date time cs-uri-stem cs-uri-query s-contentpath sc-status s-computername cs(Referer) sc-win32-status 
sc-bytes cs-bytes W3WP-PrivateBytes cs-username cs(User-Agent) time-local TimeTakenMS sc-substatus 
s-sitename s-ip s-port RequestsPerSecond s-proxy cs-version c-protocol cs-method cs(Host) EndRequest-UTC 
date-local CPU-Utilization cs(Cookie) c-ip BeginRequest-UTC

Log sample

The following are samples of possible logs from the Microsoft IIS device:

WC3

2011-04-14 14:58:36 MS_ISS_1 name 127.0.0.1 GET /exampletest - 80 - 127.0.0.1 HTTP/1.1 Mozilla/4.0+ 
(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR
+3.5.30729;+.NET+CLR+3.0.30729) - - 127.0.0.1 404 4 2 109 398 2

NCSA

172.21.13.45 - Microsoft\fred [08/Apr/2001:17:39:04 -0800] "GET /scripts/iisadmin/ism.dll?http/serv HTTP/1.0" 200 3401

IIS

172.16.255.255, anonymous, 03/20/01, 23:58:11, MSFTPSVC, SALES1, 172.16.255.255, 60, 275, 0, 0, 0, PASS, /Intro.htm, -,

Advanced Logging

2014-11-16 22:56:55.379 /index.html - "C:\inetpub\wwwroot\index.html" 200 "WIN2008R2-1" - 0 339 39 - - -
15:56:55.379 4 0 "DEFAULT WEB SITE" 10.50.14.9 80 - - "HTTP/1.0" "http" GET "10.50.14.9" 2014-11-16
22:56:55.379 2014-11-16 - - 10.50.14.8 2014-11-16 22:56:55.375

Field mapping

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

WC3 Log fields

Trellix ESM fields

Date Time (two fields)

FirstTime,LastTime

s-ip

Destination IP

cs-method

Command

cs-uri-stem

Object

s-port

Destination Port

cs-username (domain section)

Domain

cs-username

Source User

c-ip

Source IP

cs(User-Agent)

Application

cs-host

Hostname

sc-status

sid

sc-status(first number)

Action

IIS log fields

Trellix ESM fields

Client IP

Source IP

User name

Source User

Date Time (two fields)

FirstTime, LastTime

Server Name

Hostname

Server IP

Destination IP

Clients bytes sent

Bytes_from_Client

Server bytes sent

Bytes_from_Server

Service Status Code

sid

Service Status Code (first number)

action

Request Type

Command

Target of Operation

Object

NCSA Log fields

Trellix ESM fields

Remote Host Address

Source IP

User name

Source User

Date Time (two fields)

FirstTime, LastTime

Request and protocol version (first part)

Command

Request and protocol version (second part)

Object

Request and protocol version (third part)

Protocol

Service Status Code

sid

Service Status Code (first number)

action

Bytes Sent

Bytes_Sent

Advanced logging

Trellix ESM fields

Date Time (two fields)

FirstTime,LastTime

s-ip

Destination IP

Advanced logging

Trellix ESM fields

cs-method

Command

cs-uri-stem

Object

s-port

Destination Port

cs-username (domain section)

Domain

cs-username

Source User

c-ip

Source IP

cs(User-Agent)

User_Agent

cs-host

Hostname

sc-status

sid

sc-status(first number)

Action

sc-bytes

Bytes_from_Server

cs-bytes

Bytes_from_Client

protocol

Application_Protocol