Receba nossa Newsletter Nome Email

Expressão regular para ler o log do APACHE com SED

# 201.1.179.65   - - [18/Jun/2010:12:59:49 -0300] "GET /materias2.php?cd_secao=109 HTTP/1.1" 200 1170 "-"                                                                                  "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
# 187.106.178.92 - - [01/Jul/2010:10:09:22 -0300] "GET /materias2.php?cd_secao=109 HTTP/1.1" 200 1051 "
http://200.250.225.131/WorldClient.dll?Session=YFZKKSG&View=BlankMessageBody"       "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"
# 187.57.119.214 - - [19/Jun/2010:17:48:54 -0300] "GET /materias2.php?cd_secao=109 HTTP/1.1" 200 1170 "
http://br.mc583.mail.yahoo.com/mc/welcome?.gx=1&.tm=1276980158&.rand=7jg46dm4q67uq" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6.4; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2)"

# {IP} - {usuario} - {[dia/mes/ano:hora:min:seg fusogmt]} {"METODO URLPARCIAL PROTOCOLO"} {STATUSRESHTTP} {BYTES} {"REFERER"} {"STRING DO BROWSER"}

##### interpreta linha a linha do arquivo separando os textos
#            IP          USUARIO         DATA         METODO     URLPARC    PROTO       STATUS     BYTES       REFERER      NAVEGAD
sed -n 's/^\([^ ]\+\) -\([^\-]\+\)- \[\([^\]\+\)\] "\([^ ]\+\) \([^ ]\+\) \([^"]\+\)" \([^ ]\+ [^ ]\+\) "\([^"]\+\)" "\([^"]\+\)"$/{IP:\1} - {USR:\2} - {DT:\3} - {MDT:\4 URLP:\5 PROT:\6 } - {STSBYT:\7} - {REF:\8} - {NAV:\9}/p' $ARQUIVO

Voltar Topo Enviar a um amigo Imprimir Home