I’ve got two Telegraf processes gathering data using the SQL Server Input.
I get a few hundred points every 15sec.
Sometimes, some of those points seem to be invalid, and I get the following error
2020-02-14T09:53:18Z E! [outputs.influxdb] When writing to [http://127.0.0.1:8186]: 400 Bad Request: http: bad request
2020-02-14T09:53:18Z E! [agent] Error writing to outputs.influxdb: could not write any address
Since I got invalid points for several hours, I would like to count the number of points for each series in InfluxDB (filtered by time), in order to see which one has no data points for that interval and then debug further.
Now I’m using queries like this:
SELECT count("read_bytes") AS COUNT FROM "monitor"."short"."sqlserver_database_io" WHERE time > :dashboardTime: AND time < :upperDashboardTime: GROUP BY *
Which must be created for each measurement, Is it possible to count the number of points by series in a different way?