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.

]]>https://scomthings.wordpress.com/2012/10/11/set-agent-failover-between-management-servers/feed/0phakesleySCOM Console UI Add Object List limited to 500https://scomthings.wordpress.com/2012/10/10/scom-console-ui-add-object-list-limited-to-500/
https://scomthings.wordpress.com/2012/10/10/scom-console-ui-add-object-list-limited-to-500/#respondWed, 10 Oct 2012 15:17:04 +0000http://scomthings.wordpress.com/?p=24]]>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.

]]>https://scomthings.wordpress.com/2012/10/10/ops-mgr-shell-agents-by-management-server-opr-gateway/feed/0phakesleySQL for performance data for a reporthttps://scomthings.wordpress.com/2012/10/10/sql-for-performance-data-for-a-report/
https://scomthings.wordpress.com/2012/10/10/sql-for-performance-data-for-a-report/#respondWed, 10 Oct 2012 13:16:20 +0000http://scomthings.wordpress.com/?p=16]]>Some SQL code I use all the time when I am writing an SSRS report for performance data.

(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

]]>https://scomthings.wordpress.com/2012/10/10/sql-for-performance-data-for-a-report/feed/0phakesleySCOM 2007R2 Cross Platform Agent – Unknownhttps://scomthings.wordpress.com/2012/10/10/scom-2007r2-cross-platform-agent-unknown/
https://scomthings.wordpress.com/2012/10/10/scom-2007r2-cross-platform-agent-unknown/#respondWed, 10 Oct 2012 12:28:11 +0000http://scomthings.wordpress.com/?p=3]]>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.