Time series from sql server

Hi, I have a single-result mssql query that I’d like to create a time-series chart from by querying every minute.

What combination of tools would i need to make this happen? I was thinking sqlserver->telegraf->influx->grafana but I can’t find any way to query the db in telegraf - I only see a way to get sql server statistics.

Thanks in advance - Joe

i use node-red rather than telegraf for such things.

Why not simply MSSQL -> Grafana?


I assumed that the full time series was not available, hence the question, but perhaps @jpresto was not aware that you can go direct from mssql (assuming there is, in fact, and mssql data source, I haven’t checked).