input {

    jdbc {
       type => "jdbc"
       jdbc_driver_library => "C:\Users\jesperni\Downloads\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar"
       jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
       jdbc_connection_string => "jdbc:sqlserver://HRMHOST003\INSTANCE01;databaseName=utv2998jepster"
       jdbc_user => "hrm"
       jdbc_password => "Helmet1234"
       schedule => "* * * * *"
       statement => "SELECT TOP 1 email,cellphone,personid FROM ORG_Person ORDER BY NEWID()"
       jdbc_paging_enabled => "true"
    }

    jdbc {
       type => "jdbc"
       jdbc_driver_library => "C:\Users\jesperni\Downloads\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar"
       jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
       jdbc_connection_string => "jdbc:sqlserver://HRMHOST003\INSTANCE01;databaseName=utv2998jepster"
       jdbc_user => "hrm"
       jdbc_password => "Helmet1234"
       schedule => "* * * * *"
       statement => "SELECT TOP 1 * FROM ORG_EmpAbsence ORDER BY NEWID()"
       jdbc_paging_enabled => "true"
    }
}

output {
    elasticsearch {
     hosts => "localhost:9200"
     index => "nocco-%{+YYYY.MM.dd}"
     document_id => "%{email}"
     document_type => "db"
     manage_template => true
     }

     elasticsearch {
      hosts => "localhost:9200"
      index => "nocco-%{+YYYY.MM.dd}"
      document_id => "%{personid}"
      document_type => "sick"
      manage_template => true
      }
      stdout { codec => rubydebug }
}