按windows logicaldisk筛选XDB sql

e37o9pze  于 2021-08-09  发布在  Java
关注(0)|答案(0)|浏览(138)

我试图了解如何获得chronograf Jmeter 板设置,以便显示特定的windows磁盘(sqlserver)。给出整个磁盘系统的基本查询:

SELECT mean("Percent_Free_Space") AS "mean_Percent_Free_Space" FROM "flajacksdb"."autogen"."win_disk" WHERE time > :dashboardTime: AND "host"='wafflehousesqlserver' GROUP BY time(:interval:) FILL(null)

我想我可以这样做来过滤z驱动器:

SELECT mean("Percent_Free_Space") AS "mean_Percent_Free_Space" FROM "flajacksdb"."autogen"."win_disk"."Instances"."Z" WHERE time > :dashboardTime: AND "host"='wafflehousesqlserver' GROUP BY time(:interval:) FILL(null)

但这并不返回数据。有人知道如何过滤较低的物体吗?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题