# Copyright (c) 2010 Flowerfire, Inc.  All Rights Reserved.
microsoft_proxy_dmyy = {

  # The name of the log format
  log.format.format_label = "Microsoft Proxy Log Format (d/m/yy dates)"
  log.miscellaneous.log_data_type = "firewall"  
  log.miscellaneous.log_format_type = "proxy_server"

  # The log is in this format if any of the first ten lines match this regular expression
  log.format.autodetect_regular_expression = "^[-0-9.]*, [^,]*, [^,]*, [^,]*, [0-9][0-9]*/[0-9][0-9]*/[0-9][0-9], [0-9][0-9]*:[0-9][0-9]:[0-9][0-9], [^,]*, [^,]*, [^,]*, [^,]*, [-0-9.]*, [0-9]*, [^,]*, [^,]*, [^,]*, [^,]*, [^,]*, [^,]*, [^ ]*, [^,]*, [^ ]*, [-0-9]*, [-0-9]*$"

  # Logs fields are separated by a comma
  log.format.field_separator = ", "

  # The format of dates and times in this log
  log.format.date_format = "d/m/yy"
  log.format.time_format = "h:mm:ss"

  # Log fields
  log.fields = {

    browsing_host = {
      label = "$lang_stats.field_labels.browsing_host"
      type = "flat"
      index = 1
      subindex = 0
    } # browsing_host

    authenticated_user = {
      label = "$lang_stats.field_labels.authenticated_user"
      type = "flat"
      index = 2
      subindex = 0
    } # authenticated_user

    agent = {
      label = "$lang_stats.field_labels.agent"
      type = "agent"
      index = 3
      subindex = 0
      hierarchy_dividers = ""
      left_to_right = false
      leading_divider = "false"
    } # agent

    date = {
      label = "$lang_stats.field_labels.date"
      type = "date"
      index = 5
      subindex = 0
      hierarchy_dividers = ""
      left_to_right = false
      leading_divider = "false"
    } # date

    time = {
      label = "$lang_stats.field_labels.time"
      type = "time"
      index = 6
      subindex = 0
      hierarchy_dividers = ""
      left_to_right = false
      leading_divider = "false"
    } # time

    remote_hostname = {
      label = "$lang_stats.field_labels.remote_hostname"
      type = "host"
      index = 10
      subindex = 0
      hierarchy_dividers = "."
      left_to_right = false
      leading_divider = "false"
    } # remote_hostname

    remote_ip = {
      label = "$lang_stats.field_labels.remote_ip"
      type = "flat"
      index = 11
      subindex = 0
    } # remote_ip

    remote_port = {
      label = "$lang_stats.field_labels.remote_port"
      type = "flat"
      index = 12
      subindex = 0
    } # remote_port

    bytes_sent = {
      label = "$lang_stats.field_labels.bytes_sent"
      type = "size"
      index = 14
      subindex = 0
      hierarchy_dividers = ""
      left_to_right = false
      leading_divider = "false"
    } # bytes_sent

    bytes_received = {
      label = "$lang_stats.field_labels.bytes_received"
      type = "flat"
      index = 15
      subindex = 0
    } # bytes_received

    protocol = {
      label = "$lang_stats.field_labels.protocol"
      type = "flat"
      index = 16
      subindex = 0
    } # protocol

    transport = {
      label = "$lang_stats.field_labels.transport"
      type = "flat"
      index = 17
      subindex = 0
    } # transport

    operation = {
      label = "$lang_stats.field_labels.operation"
      type = "flat"
      index = 18
      subindex = 0
    } # operation

    url = {
      label = "$lang_stats.field_labels.url"
      type = "page"
      index = 19
      subindex = 0
      hierarchy_dividers = "/?"
      left_to_right = false
      leading_divider = "false"
    } # url

    object_source = {
      label = "$lang_stats.field_labels.object_source"
      type = "flat"
      index = 21
      subindex = 0
    } # object_source

    server_response = {
      label = "$lang_stats.field_labels.server_response"
      type = "response"
      index = 22
      subindex = 0
      hierarchy_dividers = ""
      left_to_right = false
      leading_divider = "false"
    } # server_response

  } # log.fields


  # Database fields
  database.fields = {

    date_time = {
      label = "$lang_stats.field_labels.date_time"
      log_field = "date_time"
      type = "string"
      suppress_top = 0
      suppress_bottom = 3
      display_format_type = "date_time"
    } # date_time

    day_of_week = {
      label = "$lang_stats.field_labels.day_of_week"
      log_field = "day_of_week"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
      display_format_type = "day_of_week"
    } # day_of_week

    hour_of_day = {
      label = "$lang_stats.field_labels.hour_of_day"
      log_field = "hour_of_day"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
      display_format_type = "hour_of_day"
    } # hour_of_day

    browsing_host = {
      label = "$lang_stats.field_labels.browsing_host"
      log_field = "browsing_host"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # browsing_host

    url = {
      label = "$lang_stats.field_labels.url"
      log_field = "url"
      type = "string"
      suppress_top = 1
      suppress_bottom = 3
    } # url

    file_type = {
      label = "$lang_stats.field_labels.file_type"
      log_field = "file_type"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # file_type

    worm = {
      label = "$lang_stats.field_labels.worm"
      log_field = "worm"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # worm

    remote_hostname = {
      label = "$lang_stats.field_labels.remote_hostname"
      log_field = "remote_hostname"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # remote_hostname

    remote_ip = {
      label = "$lang_stats.field_labels.remote_ip"
      log_field = "remote_ip"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # remote_ip

    remote_port = {
      label = "$lang_stats.field_labels.remote_port"
      log_field = "remote_port"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # remote_port

    authenticated_user = {
      label = "$lang_stats.field_labels.authenticated_user"
      log_field = "authenticated_user"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # authenticated_user

    web_browser = {
      label = "$lang_stats.field_labels.web_browser"
      log_field = "web_browser"
      type = "string"
      suppress_top = 0
      suppress_bottom = 3
    } # web_browser

    operating_system = {
      label = "$lang_stats.field_labels.operating_system"
      log_field = "operating_system"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # operating_system

    spider = {
      label = "$lang_stats.field_labels.spider"
      log_field = "spider"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # spider

    server_response = {
      label = "$lang_stats.field_labels.server_response"
      log_field = "server_response"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # server_response

    object_source = {
      label = "$lang_stats.field_labels.object_source"
      log_field = "object_source"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # object_source

  } # database.fields


  # Get web browser, operating system, web browser, and spider information from the user-agent field.
  log.parsing_filters.derive_from_user_agent = `
get_user_agent_info(agent);
web_browser = volatile.web_browser;
operating_system = volatile.operating_system;
spider = volatile.spider;
`


  # Log Filters
  log.filters = {

    detect_page_views = {
      label = '$lang_admin.log_filters.detect_page_views_label'
      comment = '$lang_admin.log_filters.detect_page_views_comment'
      value = "if ((file_type eq 'JPEG') or (file_type eq 'JPG') or (file_type eq 'GIF') or (file_type eq 'ICO') or (file_type eq 'PNG') or (file_type eq 'CSS') or (file_type eq 'SWF') or (file_type eq 'JS')) then page_views = 0; else page_views = 1;"
    } # detect_page_views

    simplify_url = {
      label = "$lang_admin.log_filters.simplify_url_label"
      comment = "$lang_admin.log_filters.simplify_url_comment"
      value = "if (matches_regular_expression(url, '^([^:]+://[^/]+/)')) then url = $1 . '(omitted)'"
    } # simplify_url

    strip_non_page_views = {
      label = '$lang_admin.log_filters.strip_non_page_views_label'
      comment = '$lang_admin.log_filters.strip_non_page_views_comment'
      value = "if (page_views == 0) then url = substr(url, 0, last_index(url, '/') + 1) . '(nonpage)';"
    } # strip_non_page_views

    not_authenticated = {
      label = "$lang_admin.log_filters.not_authenticated_label"
      comment = "$lang_admin.log_filters.not_authenticated_comment"
      value = "if (authenticated_user eq '-') then authenticated_user = '(not authenticated)';"
    } # not_authenticated

    mark_entry = {
      label = '$lang_admin.log_filters.mark_entry_label'
      comment = '$lang_admin.log_filters.mark_entry_comment'
      value = 'hits = 1;'
    } # mark_entry

  } # log.filters

  log.field_options = {

    sessions_page_field = "url"
    sessions_visitor_id_field = "browsing_host"
    sessions_event_field = "page_views"

  } # log.field_options


  database.numerical_fields = {

    hits = {
      label = "$lang_stats.field_labels.hits"
      default = false
      requires_log_field = false
      type = "int"
      display_format_type = "integer"
      entries_field = true
    } # hits

    page_views = {
      label = "$lang_stats.field_labels.page_views"
      default = true
      requires_log_field = false
      type = "int"
      display_format_type = "integer"
    } # page_views

    visitors = {
      label = "$lang_stats.field_labels.visitors"
      default = false
      requires_log_field = true
      log_field = "browsing_host"
      type = "unique"
      display_format_type = "integer"
    } # visitors

    bytes_sent = {
      label = "$lang_stats.field_labels.bytes_sent"
      default = false
      requires_log_field = true
      log_field = "bytes_sent"
      type = "float"
      display_format_type = "bandwidth"
    } # bytes_sent

  } # database.numerical_fields


  create_profile_wizard_options = {
    date_time_tracking = true
    host_tracking = true

    # How the reports should be grouped in the report menu
    report_groups = {
      date_time_group = ""
      browsing_host = true
      url = true
      file_type = true
      worm = true
      remote_hostname = true
      remote_ip = true
      remote_port = true
      authenticated_user = true
      web_browser = true
      operating_system = true
      spider = true
      server_response = true
      object_source = true
    } # report_groups

  } # create_profile_wizard_options

  not_supported = {
  } # not_supported

} # microsoft_proxy_dmyy