Sawmill stores the following non-numerical fields in its database for Bluecoat Squid Log / SGOS Format, generates reports for each field, and allows dynamic filtering on any combination of these fields:

Field

Internal Name

date/time

date_time

day of week

day_of_week

hour of day

hour_of_day

source IP

source_ip

URL

url

file type

file_type

worm

worm

server response

server_response

action

action

operation

operation

hierarchy

hierarchy

server

server

authenticated user

authenticated_user

mime type

mime_type

Sawmill stores the following numerical fields in its database for Bluecoat Squid Log / SGOS Format, aggregating them and including them as columns in most reports:

Numerical Field

Internal Name

requests

requests

page views

page_views

visitors

visitors

size

size

See Sawmill Features to learn more about Sawmill's options for viewing, customizing, filtering, exporting and scheduling Bluecoat Squid Log / SGOS Format reports.