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

  plugin_version = "1.0.1"

  # Initial creation - 1.0
  # 2011-07-21 - 1.0.1 - MSG - Edited info lines.

  info.1.manufacturer = "IBM"
  info.1.device = "Tivoli Storage Manager TDP for SQL Server"
  info.1.version.1 = ""

  # The name of the log format
  log.format.format_label = "Tivoli Storage Manager TDP for SQL Server Format"
  log.miscellaneous.log_data_type = "firewall"  
  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]/[0-9][0-9]/[0-9][0-9][0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9],Backed up - [^,]+, type: [^,]+, size: [0-9]+,"

  # The log is in this format if any of the first ten lines match this regular expression
  log.format.parsing_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]),Backed up - ([^,]+), type: ([^,]+), size: ([0-9]+), actual bytes: ([0-9,]+), secs: ([0-9.]+), Kb/Sec: ([0-9.]+), SQL server: ([^,]+), ADSM server: ([^,]+), SQL status: ([^,]+), ADSM status: (.*)$"

  # A log entry is called an "backup"
  statistics.miscellaneous.entry_name = "backup"

  # Set the date and time format
  log.format.date_format = "mm/dd/yyyy"
  log.format.time_format = "hh:mm:ss"

  # Log fields
  log.fields = {

    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 = "flat"
      index = 0
      subindex = 0
    } # time

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

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

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

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

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

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

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

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

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

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

  } # 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

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

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

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

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

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

  } # database.fields

  database.numerical_fields = {

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

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

  } # database.numerical_fields


  log.filters = {

    mark_entry = {
      label = '$lang_admin.log_filters.mark_entry_label'
      comment = '$lang_admin.log_filters.mark_entry_comment'
      value = 'backup = 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 = ""
      backup = true
      type = true
      sql_server = true
      adsm_server = true
      sql_status = true
    } # report_groups

  } # create_profile_wizard_options

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

} # tivoli_storage_manager_sql