--Perf Data
SELECT     PERF.ManagedEntityRowId
,PR.RuleRowId
,PERF.DateTime
,PERF.AverageValue
,PERF.MinValue
,PERF.MaxValue
,PERF.SampleCount
,PR.ObjectName
,PR.CounterName
,PRI.InstanceName
FROM Perf.vPerfHourly PERF
INNER JOIN vPerformanceRuleInstance PRI ON PRI.PerformanceRuleInstanceRowId = PERF.PerformanceRuleInstanceRowId 
INNER JOIN vPerformanceRule PR ON PR.RuleRowId = PRI.RuleRowId
WHERE PERF.DateTime > (GETUTCDATE() - 7)
--WHERE PERF.DateTime > (getutcdate() + 1) -- Dummy condition to return no rows


--Perf Entities and Types
select distinct
ME.ManagedEntityRowId
,ME.Name
,ME.DisplayName
,ME.Path
,MET.ManagedEntityTypeDefaultName
from Perf.vPerfHourly PERF
inner join vManagedEntity ME on ME.ManagedEntityRowId = PERF.ManagedEntityRowId
inner join vManagedEntityManagementGroup MEMG on MEMG.ManagedEntityRowId = ME.ManagedEntityRowId
inner join vManagedEntityType MET on MET.ManagedEntityTypeRowId = ME.ManagedEntityTypeRowId
where PERF.DateTime > (GETUTCDATE() - 7)
order by MET.ManagedEntityTypeDefaultName


--MPs and Rules
SELECT distinct RU.RuleRowId
 ,MP.ManagementPackDefaultName
 ,MP.ManagementPackSystemName
 ,RU.RuleDefaultName
FROM vManagementPack MP
inner join vRule RU on RU.ManagementPackRowId = MP.ManagementPackRowId
inner join vPerformanceRule PR on PR.RuleRowId = RU.RuleRowId
where PR.LastReceivedDateTime > (GETUTCDATE() - 7)