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
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

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