/*************************************************************************************/
/*     Query of the SCOM Data warehouse that returns % Logical Disk Free Space 2003 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
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-01-01' and '2009-02-28'
and vPerformanceRule.ObjectName='LogicalDisk'
and vPerformanceRule.CounterName='% Free Space'
and vRule.RuleDefaultName='% Logical Disk Free Space 2003'
Order by Path,DateTime