# Copyright (c) 2013 Flowerfire, Inc.  All Rights Reserved.
microsoft_server_nps_sql = {

  plugin_version = "1.0.1"

  # 2013-09-25 - 1.0 - GMF - Initial creation

  info.1.manufacturer = "Microsoft"
  info.1.device = "Server NPS SQL (ODBC Log Source)"
  info.1.version.1 = "2008 R2"

  # The name of the log format
  log.format.format_label = "Microsoft Server NPS SQL (ODBC Log Source)"
  log.miscellaneous.log_data_type = "other"
  log.miscellaneous.log_format_type = "other"

  # The log is in this format if any of the first ten lines match this regular expression
  log.format.autodetect_expression = `
if (matches_regular_expression(volatile.log_data_line, '^#Software: Sawmill ODBC Query Exporter')) then
  v.odbc_header_detected = true;
else if (matches_regular_expression(volatile.log_data_line, '^#Fields.*NP_Policy_Name')) then
  v.matching_fields_header_detected = true;

?'v.odbc_header_detected' and ?'v.matching_fields_header_detected'
`

  # The format of dates and times in this log
  log.format.date_format = "seconds_since_jan1_1970"
  log.format.time_format = "seconds_since_jan1_1970"

  log.fields = {
    date_time = ""
    date = ""
    time = ""
  }

  database.fields = {
    date_time = ""
    day_of_week = ""
    hour_of_day = ""
  }

#  log.parsing_filters.parse = `
#if (matches_regular_expression(date_time, '^([0-9]+-[0-9]+-[0-9]+) ([0-9][0-9]:[0-9][0-9]:[0-9][0-9])')) then (
#  date = $1;
#  time = $2;
#);
#`

  # Log Filters
  log.filters = {

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

  } # log.filters

  database.numerical_fields = {

    events = {
      requires_log_field = false
      entries_field = true
    } # events

  } # database.numerical_fields

  create_profile_wizard_options = {

    # How the reports should be grouped in the report menu
    report_groups = {
      date_time_group = ""
    } # report_groups

  } # create_profile_wizard_options


} # microsoft_server_nps_sql