microsoft_sqlprofiler = {

  # The name of the log format
  log.format.format_label = "Microsoft SQL Profiler Export"
  log.miscellaneous.log_data_type = "generic"  
  log.miscellaneous.log_format_type = "application"

  # 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]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^ ]* [^,]*,[^,]*,[^,]*,[^,]*$"

  # All log field parsing will be done using the parsing filters
  log.format.parse_only_with_filters = "true"

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

  # Log fields
  log.fields = {

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

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

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

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

    unknown1 = {
      label = "unknown1"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown1

    unknown2 = {
      label = "unknown2"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown2

    unknown3 = {
      label = "unknown3"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown3

    unknown4 = {
      label = "unknown4"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown4

    unknown5 = {
      label = "unknown5"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown5

    unknown6 = {
      label = "unknown6"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown6

    unknown7 = {
      label = "unknown7"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown7

    unknown8 = {
      label = "unknown8"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown8

    unknown9 = {
      label = "unknown9"
      type = "flat"
      index = 0
      subindex = 0
    } # unknown9

  } # log.fields


  #          
  # Log Parsing Filters
  log.parsing_filters = {


    # (1)Parse one entry on one line
    1 = {
      label = "1"
      comment = ""
      value = "collect_fields_using_regexp('^()[0-9]*,([0-9]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([0-9/]*) ([0-9:]*),([^,]*),([^,]*),([^,]*)$', '*KEY*,type,operation,unknown1,unknown2,unknown3,unknown4,unknown5,unknown6,date,time,unknown7,unknown8,unknown9')"
    } # 1


    # (2)Parse a line for type, operation on one line
    2 = {
      label = "2"
      comment = ""
      value = "collect_fields_using_regexp('^()[0-9]*,([0-9]*),\"([^\"]*)$', '*KEY*,type,operation')"
    } # 2


    # (3)Parse a line for unknowns and a date & time
    3 = {
      label = "3"
      comment = ""
      value = "collect_fields_using_regexp('()\",([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([0-9/]*) *([0-9:]*),([^,]*),([^,]*),([^,]*)$', '*KEY*,unknown1,unknown2,unknown3,unknown4,unknown5,unknown6,date,time,unknown7,unknown8,unknown9')"
    } # 3


    # (1) Accept this collected log entry, if entry is all on one line
    4 = {
      label = "4"
      comment = ""
      value = "accept_collected_entry_using_regexp('^[0-9]*,[0-9]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[0-9/]* *[0-9:]*,[^,]*,[^,]*,[^,]*$', false)"
    } # 4


    # (2) Accept this collected log entry, end of line type 1
    5 = {
      label = "5"
      comment = ""
      value = "accept_collected_entry_using_regexp('^\",[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,$', false)"
    } # 5


    # (3)Accept this collected log entry, end of line type 2
    6 = {
      label = "6"
      comment = ""
      value = "accept_collected_entry_using_regexp('\",[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[0-9/]* *[0-9:]*,[^,]*,[^,]*,[^,]$', false)"
    } # 6


  } # log.parsing_filters


  # 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

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

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

    unknown1 = {
      label = "unknown1"
      log_field = "unknown1"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown1

    unknown2 = {
      label = "unknown2"
      log_field = "unknown2"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown2

    unknown3 = {
      label = "unknown3"
      log_field = "unknown3"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown3

    unknown4 = {
      label = "unknown4"
      log_field = "unknown4"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown4

    unknown5 = {
      label = "unknown5"
      log_field = "unknown5"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown5

    unknown6 = {
      label = "unknown6"
      log_field = "unknown6"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown6

    unknown7 = {
      label = "unknown7"
      log_field = "unknown7"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown7

    unknown8 = {
      label = "unknown8"
      log_field = "unknown8"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown8

    unknown9 = {
      label = "unknown9"
      log_field = "unknown9"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # unknown9

  } # database.fields

  database.numerical_fields = {

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

  } # database.numerical_fields


  log.filters = {

    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

  create_profile_wizard_options = {
    date_time_tracking = true

    # How the reports should be grouped in the report menu
    report_groups = {
      date_time_group = ""
      day_of_week = true
      hour_of_day = true
      type = true
      operation = true
      unknown1 = true
      unknown2 = true
      unknown3 = true
      unknown4 = true
      unknown5 = true
      unknown6 = true
      unknown7 = true
      unknown8 = true
      unknown9 = true
    } # report_groups

  } # create_profile_wizard_options

  not_supported = {
    visitors = true
    individualhosts = true
    bandwidth = true
    sessions = true
    pageviews = true
  } # not_supported

} # microsoft_sqlprofiler