SCOM 2007 R2 Console Refresh Rate

The SCOM console UI has a default refresh rate of 15 seconds. In a large environment this can create performance issues when many consoles are running.

To chnage the refresh rate for a console update the registry key

HKCU\Software\Microsoft\Microsoft Operations Manager\3.0\console\CacheParameters\ PollingInterval

Vaules are 0-10 0=No refresh only via F5

1-10 = Refresh intervals of 15 seconds.

Set Agent failover between management servers

get a list of Agents from current Primary Management Server

$agents = get-agent | where {$_.PrimaryManagementServerName -eq “”}

Set the Primary Management Server

$pri = get-managementserver | where-object {$_.PrincipalName -eq “”}

Set the secondary management Server

$sec = get-managementserver | where-object {$_.PrincipalName -eq “”}

Set up failover between the management servers

set-managementserver -agentmanagedcomputer $agents -primarymanagementserver $pri -failoverserver $sec

Word of caution: Make sure the primary of the secondary is currently the actual managing server so communication stays up. rerun again if you want to change to a new server.

SCOM Console UI Add Object List limited to 500

SCOm Console UI has by default been set to retrieve only 500 items when using ‘Add Object’ in larger environments this can be extremely limiting when defining reports etc.

So to resolve this there is a registry change that can be applied.

## Backup you registry first before changing any thing ##

Add a new DWORD called MaximumSearchLimit in

HKEY_CURRENT_USER\Software\Microsoft\Microsoft Operations Manager\3.0\Console

Set the decimal value to what is good for your environment I would advise between 3000 and 10000.

SQL for performance data for a report

Some SQL code I use all the time when I am writing an SSRS report for performance data.

(Database Operations DataWarehouse)


vPerf.DateTime, vPerf.SampleCount,(vPerf.AverageValue),(vPerf.MinValue), vPerf.MaxValue, vPerf.StandardDeviation, vPerformanceRuleInstance.InstanceName, vManagedEntity.Path, vPerformanceRule.ObjectName, vPerformanceRule.CounterName


Perf.vPerfDaily AS vPerf INNER JOIN
vPerformanceRuleInstance ON vPerformanceRuleInstance.PerformanceRuleInstanceRowId = vPerf.PerformanceRuleInstanceRowId INNER JOIN
vManagedEntity ON vPerf.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId INNER JOIN
vPerformanceRule ON vPerformanceRuleInstance.RuleRowId = vPerformanceRule.RuleRowId


(vPerf.DateTime >= ‘2012-09-01’ ) AND (vPerf.DateTime <= ‘2012-09-30’ ) AND — Just for testing purposes.
vPerformanceRuleInstance.InstanceName = ‘C:’ AND
vPerformanceRule.ObjectName in (‘Drive Statistics’,’LogicalDisk’) AND – Objects interested in
vPerformanceRule.CounterName in (‘FreeSpace’,’FreeSpacePercent’,’UsedSpace’,’VolumeSize’)
–- Counters I am interested in
–vManagedEntity.Path like ‘%The name of the server%’ – Remove leading – if required.
ORDER BY vPerformanceRule.ObjectName,vPerformanceRule.CounterName

SCOM 2007R2 Cross Platform Agent – Unknown

There are times when the deployment of the CPA works fine but the server never comes online in SCOM fully. This can be due to the pid and socket file being corrupted.

$ /opt/microsoft/scx/bin/scx/bin/tools >./scxadmin – start-all

Failed to start child process ‘/etc/init.d/dcx-cimd’ errno=13

OK this can normally be fixed by:-

$ cd /var/opt/microsoft/scx/tmp
$ rm cim.socket
$ rm

Note: This may require elevated privileges.