Not showing Data in Grafana

Grafana Dashboards
1

Using this script in grafana in doesn’t show any data

SELECT DISTINCT
vs.volume_mount_point AS DiskDrive,
vs.total_bytes / 1024 / 1024 / 1024 AS Total_Size_GB,
vs.available_bytes / 1024 / 1024 / 1024 AS Free_Space_GB,
(vs.available_bytes * 100.0 / vs.total_bytes) AS Free_Space_Percentage,
GETDATE() AS time
FROM sys.master_files mf
CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.file_id) vs;

2

Welcome @zedrix08

what do you see when you click Data View in grafana

What do you see when you run that SQL script outside of grafana

3

No Data showing in grafana using my script

But upon running my script in MS SQL there is a result

1 Like
4

Try

Dateadd(hh,-2,getutcdate()) instead of

GETDATE()

5

Still No Data Result in Grafana Dashboard

6

Click on data view, what do you see. Post a screen shot