SELECT
Perf.vPerfHourly.DateTime, Perf.vPerfHourly.AverageValue, vManagedEntity.DisplayName, vPerformanceRule.ObjectName, vPerformanceRule.CounterName
FROM
Perf.vPerfHourly INNER JOIN
vPerformanceRuleInstance ON Perf.vPerfHourly.PerformanceRuleInstanceRowId = vPerformanceRuleInstance.PerformanceRuleInstanceRowId INNER JOIN
vPerformanceRule ON vPerformanceRuleInstance.RuleRowId = vPerformanceRule.RuleRowId INNER JOIN
vRelationship ON Perf.vPerfHourly.ManagedEntityRowId = vRelationship.TargetManagedEntityRowId INNER JOIN
vManagedEntity ON vRelationship.SourceManagedEntityRowId = vManagedEntity.ManagedEntityRowId
WHERE vManagedEntity.DisplayName = 'FQDN_SERVER'
AND vPerformanceRule.ObjectName like '%Process%'
AND vPerformanceRule.CounterName = '% Processor Time'
ORDER BY Perf.vPerfHourly.DateTime DESC