Active Alerts views are empty. If you scope the view for selected groups then alerts will appear but as soon as you change it back to All groups the alerts disappear

Hi Have you recently deployed a SCOM cumulative update? I have seen this before when a cumulative update was applied but the required SQL Scripts that are part of all cumulative updates weren't run against the correct databases: http://systemcentersolutions.wordpress.com/2011/01/24/active-alerts-views-are-empty/ http://blogs.technet.com/b/kevinholman/archive/2012/05/18/opsmgr-2007-r2-cu6-rollup-hotfix-ships-and-my-experience-installing-it.aspx Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

We did SQL Upgradation and Start Facing this issue. We tried Couple of Following tricks to resolve but no luck. 1> Restart SCOM Server services. 2> Flushed the Cache and Restarted Service.

Can you perhaps elaborate on exactly what was done. It sounds like part of the upgrade process hasn't been completed. http://technet.microsoft.com/en-us/library/dd789004.aspx http://thoughtsonopsmgr.blogspot.co.uk/2009/07/r2-upgrading-from-sql-2005-to-sql-2008.html http://thoughtsonopsmgr.blogspot.co.uk/2011/02/upgrading-from-sql-server-2008-to-r2.html What cumulative update with SCOM are you using? Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/