/*************************************************************************************/ 
/*     Query of the SCOM Data warehouse that returns Logical Free Megabytes on Windows Server 2003  */ 
/*                                                                                   */ 
/*     Author: Stefan Stranger, Microsoft Services                                   */ 
/*                                                                                   */ 
/*************************************************************************************/ 
  
select 
vManagedEntity.Path 
,Perf.vPerfdaily.DateTime 
,Perf.vPerfdaily.SampleCount
,vPerformanceRule.ObjectName 
,vPerformanceRule.CounterName 
,vManagedEntity.Name 
,Perf.vPerfdaily.Averagevalue 
,Perf.vPerfdaily.MinValue 
,Perf.vPerfdaily.MaxValue 
,Perf.vPerfdaily.StandardDeviation
,vRule.RuleDefaultName 
from Perf.vPerfDaily 
join vPerformanceRuleInstance on vPerformanceRuleInstance.PerformanceRuleInstanceRowid=Perf.vPerfDaily.PerformanceRuleInstanceRowid
join vPerformanceRule on vPerformanceRule.RuleRowId=vPerformanceRuleInstance.RuleRowId 
join vManagedEntity on vManagedEntity.ManagedEntityRowid=Perf.vPerfDaily.ManagedEntityRowId 
join vRule on vRule.RuleRowId=vPerformanceRuleInstance.RuleRowId 
where Perf.vPerfDaily.Datetime between '2009-03-24' and '2009-03-25' 
and vPerformanceRule.ObjectName='LogicalDisk' 
and vPerformanceRule.CounterName='Free Megabytes' 
and (vRule.RuleDefaultName='Logical Disk Free Megabytes 2003' 
or vRule.RuleDefaultName='Logical Disk Free Megabytes 2000') 
and vManagedEntity.Name ='C:' 

Order by Path,DateTime