Hi, SQL SCOM - Disk space in MB OR gb, just looking for a simple query which could just list TOTAL space and FREE disk space in GB or MB. I found nearest query online Disk space in MB select vManagedEntity.Path ,Perf.vPerfdaily.DateTime ,Perf.vPerfdaily.SampleCount ,vPerformanceRule.ObjectName ,vPerformanceRule.CounterName ,vManagedEntity.Name ,Perf.vPerfdaily.Averagevalue ,Perf.vPerfdaily.MinValue ,Perf.vPerfdaily.MaxValue ,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 '2012-03-06' and '2012-03-12' and vPerformanceRule.ObjectName='LogicalDisk' and vPerformanceRule.CounterName='Free Megabytes' and (vRule.RuleDefaultName='Logical Disk Free Megabytes 2000' or vRule.RuleDefaultName='Logical Disk Free Megabytes 2003' or vRule.RuleDefaultName='Logical Disk Free Megabytes 2008') Order by Path,Name Free disk space in Percentage select vManagedEntity.Path ,Perf.vPerfdaily.DateTime ,Perf.vPerfdaily.SampleCount ,vPerformanceRule.ObjectName ,vPerformanceRule.CounterName ,vManagedEntity.Name ,Perf.vPerfdaily.Averagevalue ,Perf.vPerfdaily.MinValue ,Perf.vPerfdaily.MaxValue ,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 '2012-03-06' and '2012-03-12' and vPerformanceRule.ObjectName='LogicalDisk' and vPerformanceRule.CounterName='% Free Space' and (vRule.RuleDefaultName='% Logical Disk Free space 2000' or vRule.RuleDefaultName='% Logical Disk Free Space 2003' or vRule.RuleDefaultName='% Logical Disk Free Space 2008') Order by Path,Name PMP Project Manager

Operations Manager forums are at http://social.technet.microsoft.com/Forums/en-US/category/systemcenteroperationsmanagerJason | http://blog.configmgrftw.com

What is your question?Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/ If my response was helpful, please mark it as so, if it answered your question, then please also mark it accordingly. Thank you.