Home / server / Questions / 13157
Accepted
SQLRockstar
Asked: 2009-05-28 09:43:29 +0800 CST

Operations Manager 2007

  • 772

i am looking for some custom scripts to pull information on perfomance data counters being collected by OpsMgr. Does anyone have any scripts they are currently using?

scom

1 Answers

  1. Best Answer

    Here's some sql to get you started:

    use operationsmanagerdw
SELECT TOP 100 pr.ObjectName, pr.CounterName, pri.InstanceName,
p.SampleValue
FROM Perf.vPerfRaw p
INNER JOIN vManagedEntity me ON me.ManagedEntityRowID =
p.ManagedEntityRowID
INNER JOIN vPerformanceRuleInstance pri ON pri.PerformanceRuleInstanceRowId
= p.PerformanceRuleInstanceRowId
INNER JOIN vPerformanceRule pr ON pr.RuleRowId = pri.RuleRowId
WHERE me.[Path] = 'server FQDN'

    Works with SCOM 2007 SP1, SQL 2005 backend. Other performance tables in the data warehouse are Perf.vPerfHourly , and Perf.vPerfDaily

    • 1