input {
  jdbc {
    jdbc_driver_library
                          
                          =>
                          
                            "
                          
                          
                            E:\sqljdbc_6.2.2.1_enu\sqljdbc_6.2\enu/mssql-jdbc-6.2.2.jre8.jar
                          
                          
                            "
                          
                          
                            
    jdbc_driver_class 
                          
                          => 
                          
                            "
                          
                          
                            com.microsoft.sqlserver.jdbc.SQLServerDriver
                          
                          
                            "
                          
                          
                            
    jdbc_connection_string 
                          
                          => 
                          
                            "
                          
                          
                            jdbc:sqlserver://sqlserverIP:1433;databaseName=Reptile.NewsLetter
                          
                          
                            "
                          
                          
                            
    jdbc_user 
                          
                          => 
                          
                            "
                          
                          
                            sa
                          
                          
                            "
                          
                          
                            
    jdbc_password 
                          
                          => 
                          
                            "密码
                          
                          
                            "
                          
                          
                            
    #分页且最大5万次
    jdbc_paging_enabled 
                          
                          => 
                          
                            "
                          
                          
                            true
                          
                          
                            "
                          
                          
                            
    jdbc_page_size 
                          
                          => 
                          
                            "
                          
                          
                            50000
                          
                          
                            "
                          
                          
                            
    #时区按照东八
     jdbc_default_timezone 
                          
                          =>
                          
                            "
                          
                          
                            Asia/Shanghai
                          
                          
                            "
                          
                          
                            
     last_run_metadata_path 
                          
                          => 
                          
                            "
                          
                          
                            E:\logstash-7.0.0\config\last_value_meta.txt
                          
                          
                            "
                          
                          
                            
     #启用追踪，则需要指定tracking_column，默认是timestamp()
     use_column_value 
                          
                          => 
                          
                            true
                          
                          
                            
     # 如果 use_column_value 为真,需配置此参数. track 的数据库 column 名,该 column 必须是递增的. 一般是主键
     tracking_column 
                          
                          =>
                          
                             id
     #追踪字段的类型，目前只有数字(numeric)和时间类型(timestamp)，默认是数字类型()
     tracking_column_type 
                          
                          =>
                          
                             numeric    
     #是否记录上次执行结果, 如果为真,将会把上次执行到的 tracking_column 字段的值记录下来,保存到 last_run_metadata_path 指定的文件中
     record_last_run 
                          
                          => 
                          
                            true
                          
                          
                            
     #statement_filepath 
                          
                          => 
                          
                            "
                          
                          
                            E:\logstash-7.0.0\config\update.sql
                          
                          
                            "
                          
                          
                             sql可放到独立文件里面去
     #表里有时间也有时间戳 都可用
     statement 
                          
                          => 
                          
                            "
                          
                          
                            SELECT * FROM [Reptile.NewsLetter].[dbo].[LivesItems] where id > :sql_last_value 
                          
                          
                            "
                          
                          
                            
     schedule 
                          
                          => 
                          
                            "
                          
                          
                            * * * * *
                          
                          
                            "
                          
                          
                            
     #是否清除 last_run_metadata_path 的记录,如果为真那么每次都相当于从头开始查询所有的数据库记录
     clean_run 
                          
                          => 
                          
                            false
                          
                          
                             
     #是否将 column 名称转小写
     lowercase_column_names 
                          
                          => 
                          
                            false
                          
                          
                            
  }
}
output {
   elasticsearch {
        hosts 
                          
                          => [
                          
                            "
                          
                          
                            http://my.es.com:9200
                          
                          
                            "
                          
                          
                            ]   
        index 
                          
                          => 
                          
                            "
                          
                          
                            nl_livesitem
                          
                          
                            "
                          
                          
                            
         user 
                          
                          => 
                          
                            "
                          
                          
                            elastic
                          
                          
                            "
                          
                          
                            
         password 
                          
                          => 
                          
                            "
                          
                          
                            changeme
                          
                          
                            "
                          
                          
                            
       }
}
                          
                        

                          <?xml version=
                          
                            "
                          
                          
                            1.0
                          
                          
                            "
                          
                           encoding=
                          
                            "
                          
                          
                            utf-8
                          
                          
                            "
                          
                           ?>
<nlog xmlns=
                          
                            "
                          
                          
                            http://www.nlog-project.org/schemas/NLog.xsd
                          
                          
                            "
                          
                          
                            
      xmlns:xsi
                          
                          =
                          
                            "
                          
                          
                            http://www.w3.org/2001/XMLSchema-instance
                          
                          
                            "
                          
                          
                            
      autoReload
                          
                          =
                          
                            "
                          
                          
                            true
                          
                          
                            "
                          
                          
                            
      internalLogLevel
                          
                          =
                          
                            "
                          
                          
                            Warn
                          
                          
                            "
                          
                          
                            
      internalLogFile
                          
                          =
                          
                            "
                          
                          
                            internal-nlog.txt
                          
                          
                            "
                          
                          >

  <extensions>
    <add  assembly=
                          
                            "
                          
                          
                            NLog.Web.AspNetCore
                          
                          
                            "
                          
                          />
  </extensions >
  <variable name=
                          
                            "
                          
                          
                            logDirectory
                          
                          
                            "
                          
                           value=
                          
                            "
                          
                          
                            ${basedir}\logs\"/>
                          
                          
  <!--define various log targets-->
  <targets>
    <!--write logs to file-->
    <!--address 填写Logstash数据的接收通道-->
    <target xsi:type=
                          
                            "
                          
                          
                            Network
                          
                          
                            "
                          
                          
                            
            name
                          
                          =
                          
                            "
                          
                          
                            elastic
                          
                          
                            "
                          
                          
                            
            keepConnection
                          
                          =
                          
                            "
                          
                          
                            false
                          
                          
                            "
                          
                          
                            
            address 
                          
                          =
                          
                            "
                          
                          
                            tcp://my.es.com:50000
                          
                          
                            "
                          
                          
                            
            layout
                          
                          =
                          
                            "
                          
                          
                            ${longdate}|${logger}|${uppercase:${level}}|${message} ${exception}
                          
                          
                            "
                          
                           />
    />
    <target xsi:type=
                          
                            "
                          
                          
                            Null
                          
                          
                            "
                          
                           name=
                          
                            "
                          
                          
                            blackhole
                          
                          
                            "
                          
                           />
  </targets>
  <rules>
    <!--All logs, including 
                          
                            from
                          
                           Microsoft-->
    <!--<logger name=
                          
                            "
                          
                          
                            *
                          
                          
                            "
                          
                           minlevel=
                          
                            "
                          
                          
                            Trace
                          
                          
                            "
                          
                           writeTo=
                          
                            "
                          
                          
                            allfile
                          
                          
                            "
                          
                           />-->
    <!--Skip Microsoft logs and so log only own logs-->
    <logger name=
                          
                            "
                          
                          
                            Microsoft.*
                          
                          
                            "
                          
                           minlevel=
                          
                            "
                          
                          
                            Trace
                          
                          
                            "
                          
                           writeTo=
                          
                            "
                          
                          
                            blackhole
                          
                          
                            "
                          
                           final=
                          
                            "
                          
                          
                            true
                          
                          
                            "
                          
                           />
    <logger name=
                          
                            "
                          
                          
                            *
                          
                          
                            "
                          
                           minlevel=
                          
                            "
                          
                          
                            Trace
                          
                          
                            "
                          
                           writeTo=
                          
                            "
                          
                          
                            elastic
                          
                          
                            "
                          
                           />
  </rules>
</nlog>