How can you summarize ProxySG log files when a Blue Coat Reporter is not available?
You can use the awk command on a Linux machine or Cygwin on a Microsoft Windows machine.
#Preparation1 If the work machine is a Linux, gawk must be installed. If it is a Windows machine, Cygwin software should be installed. https://www.cygwin.com/ Instead of Cygwin, GNU Awk for Windows could be used, but another Linux general command(sort, uniq, etc..) will be used during the work, so recommendation is Cygwin.
#Preparation2 Download attached simple-csv.awk file. This awk script file is a converter from original SG's .log file to TAB separated CSV file. Original SG's .log file is separated by " "(space) as CSV separator, but this is not a quite good separator, because CSV file generally has some space characters in its own field. It had better convert from original .log files to the CSV file with different separator for gawk so that the gawk would not take this spaces for separator,
gawk -f simple-csv.awk 730515131405.log > 730515131405.csv *For example, 3GB of 730515131405.log file takes 20 min to convert to *.csv file.
Once *.csv file is created, it will be able to easily get summary of Accesslog.