Disk Performance using SQL Query

Sometimes you need to use the SQL queries to get the performance data instead of using WUG Reports. You can use the following queries to get the required data for Disk utilization.

SELECT Device.nDeviceID, Device.sDisplayName, sDescription, dPollTime, nSize, nUsed_Avg, nUsed_Min, nUsed_Max 
FROM dbo.StatisticalDisk
LEFT OUTER JOIN dbo.StatisticalDiskIdentification ON 
StatisticalDiskIdentification.nStatisticalDiskIdentificationID = StatisticalDisk.nStatisticalDiskIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON 
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalDiskIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON 
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC

Disk Cache data, the latest Disk utilization data (i.e. exactly one record per monitored Disk)

SELECT Device.nDeviceID, Device.sDisplayName, sDescription, dPollTime, nSize, nUsed_Avg, nUsed_Min, nUsed_Max 
FROM dbo.StatisticalDiskCache
LEFT OUTER JOIN dbo.StatisticalDiskIdentification ON 
StatisticalDiskIdentification.nStatisticalDiskIdentificationID = StatisticalDiskCache.nStatisticalDiskIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON 
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalDiskIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC