Tag: SCOM

SCOM CPU Memory Disk Util SQL Scripts

Below are the scripts are to find SCOM CPU Memory Disk Utilization. Scripts need to be run on the Data warehouse DB. Adjust the date to suite your requirements. The rest of the script remains the same CPU UtilizationselectvManagedEntity.Path,Perf.vPerfdaily.DateTime,Perf.vPerfdaily.SampleCount,vPerformanceRule.ObjectName,vPerformanceRule.CounterName,vManagedEntity.Name,Perf.vPerfdaily.Averagevalue,Perf.vPerfdaily.MinValue,Perf.vPerfdaily.MaxValue,vRule.RuleDefaultNamefrom Perf.vPerfDailyjoin vPerformanceRuleInstance on vPerformanceRuleInstance.PerformanceRuleInstanceRowid=Perf.vPerfDaily.PerformanceRuleInstanceRowidjoin vPerformanceRule on vPerformanceRule.RuleRowId=vPerformanceRuleInstance.RuleRowIdjoin vManagedEntity on vManagedEntity.ManagedEntityRowid=Perf.vPerfDaily.ManagedEntityRowId join vRule on vRule.RuleRowId=vPerformanceRuleInstance.RuleRowIdwhere Perf.vPerfDaily.Datetime between … Continue reading SCOM CPU Memory Disk Util SQL Scripts