7.00.02 - Apache Log Parser Item-Name Mapping - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The following table shows the mapping between request characteristics in the format string (log items) and table column names, and gives output examples.

Apache Log Parser Item-Name Mapping
Log Item Column Name Output Example
%h remote_host 153.65.52.112
%a remote_IP 153.65.52.112
%A local_IP 153.65.52.112
%t request_time [22/Jun/2012:17:27:02 -0700]
%b bytes_sent_CLF 512
%B bytes_sent 455
%O bytes_sent_including_header 512
%I bytes_received_including_header 512
%p canonical_server_port 80
%{canonical}p canonical_server_port 80
%{local}p actual_server_port 80
%{remote}p actual_client_port 7777
%P process_ID 8311
%k live_connections 2
%D request_duration_microseconds 312
%T request_duration_seconds 0
%U requested_URL /index.html
%l remote_log_name  
%u remote_user  
%f requested_file  
%{VARNAME}i request:VARNAME  
%{Referer}i Referer  
%{VARNAME}o reply:VARNAME  
%{VARNAME}n note:VARNAME  
%{VARNAME}e env:VARNAME  
%{VARNAME}C cookie:VARNAME  
%V server_name  
%v canonical_server_name  
%L log_ID  
%H protocol HTTP/1.1
%m method GET
%q query  
%X connection_status X = Connection aborted before the response completed.

+ = Connection may be kept alive after the response is sent.

- = Connection closes after the response is sent.

%r request_line  
%>s final_status 404
%<s original_request_status  
%s original_request_status  
%R handler