CPU 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 CPU utilization.

SELECT Device.nDeviceID, Device.sDisplayName, sDescription, dPollTime, nProcessorLoad_Avg, nProcessorLoad_Min, nProcessorLoad_Max
FROM dbo.StatisticalCpu
LEFT OUTER JOIN dbo.StatisticalCpuIdentification ON
StatisticalCpuIdentification.nStatisticalCpuIdentificationID = StatisticalCpu.nStatisticalCpuIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalCpuIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC

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

SELECT Device.nDeviceID, Device.sDisplayName, sDescription, dPollTime, nProcessorLoad_Avg, nProcessorLoad_Min, nProcessorLoad_Max
FROM dbo.StatisticalCpuCache
LEFT OUTER JOIN dbo.StatisticalCpuIdentification ON
StatisticalCpuIdentification.nStatisticalCpuIdentificationID = StatisticalCpuCache.nStatisticalCpuIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalCpuIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC