zcat /home/cPanelUser/logs/DOMAIN-ssl_log-DATE.gz| awk ‘{ print $1″,”$4″,”$6″,”$7″,”$9″,”$10″,”$11 }’ > access-log-ssl.csv
CSV Fields:
IP, DATE, Request Method, Requested Resource, Response Code, Response Size (bytes), Referrer
This is useful when wanting to analyze in Excel for example. Some fields need cleaning up afterwards for stray extra characters.
