Telegraf Version: telegraf-1.13.0-1.x86_64.rpm
Influxdb version: influxdb-1.7.9.x86_64.rpm
Configuration in Telegraf:
[[inputs.sqlserver]]
servers = [“Server=server1;Port=1433;User Id=telegraf;Password=xxx;app name=telegraf;log=1”,
“Server=server2;Port=1433;User Id=xxx.net\sql_telegraf;Password=xxx;app name=telegraf;log=1”]
query_version = 2
We see following in the telegraf logs:
2020-01-30T19:15:55Z I! Loaded inputs: mem system influxdb apache apache apache apache apache apache apache apache apache apache diskio internal redis redis redis redis redis redis redis sqlserver cpu disk swap net
2020-01-30T19:15:55Z I! Loaded aggregators:
2020-01-30T19:15:55Z I! Loaded processors:
2020-01-30T19:15:55Z I! Loaded outputs: influxdb
2020-01-30T19:15:55Z I! Tags enabled: host=servertig1
2020-01-30T19:15:55Z I! [agent] Config: Interval:10s, Quiet:false, Hostname:“servertig1”, Flush Interval:10s
2020-01-30T19:16:00Z I! Invalid column name ‘total_cpu_usage_ms’.
2020-01-30T19:16:00Z I! Invalid column name ‘total_scheduler_delay_ms’.
2020-01-30T19:16:00Z E! [inputs.sqlserver] Error in plugin: mssql: Invalid column name ‘total_scheduler_delay_ms’.
2020-01-30T19:16:00Z I! Invalid column name ‘database_id’.
2020-01-30T19:16:00Z E! [inputs.sqlserver] Error in plugin: mssql: Invalid column name ‘database_id’.