Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Times New Roman";}
I need to write one query to parse NCSA log format. My Logs
are like this
172.21.201.112 - - [08/Apr/2001:21:01:19 -0800] "GET
/style.css HTTP/1.0" 200 3401
In examples I got the way to check the Values but it is
meaningless to store them without the IP and time stamp details. I need to view all details like
ip date time uri-stem sc-status sc-bytes
I think we can use these fields only for such log format.
Please write down query for same.