Error in inputs.sqlserver Invalid column name

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’.

Which version of SQL server do you have?

--Run the following query
SELECT @@version

The input requires some views that are not available on old version of SQL Server.

If you have an old verison you should be able to run the query version 1.

We are using SQL 2008 R2.

Then you will have to use query version 1

[[inputs.sqlserver]]
{...}
  query_version = 1
{...}

Thank you that worked !!!