Hi Dom, 1. You can create a collection rule from this query and then use this rule to show the data in a performance view. 2. You can use some dashboard solution: http://blogs.catapultsystems.com/cfuller/archive/2010/12/11/using-the-service-manager-2010-dashboard-for-operations-manager.aspx http://www.dundas.com/dashboard/http://OpsMgr.ru/

Another option: http://www.scom2k7.com/how-to-create-a-custom-scom-dashboard-to-show-key-management-group-information/ Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Thanks Alexey & Graham, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hello, From this query (thanks to JAMAOO) Select alertstringname,count(*)as Number_of_alerts, DATEDIFF(MI,TimeRaised,TimeResolved) from AlertView where ResolutionState = 255 and ResolvedBy ='system' and (alertstringname = 'Health Service HeartBeat Failure' or alertstringname = 'Failed to Connect to Computer') group by AlertStringNAme, DATEDIFF(MI,TimeRaised,TimeResolved) order by 3 DESC I would like to have a view showing in X the time and in Y the number of alerts... how do I do this? Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hi Dom, 1. You can create a collection rule from this query and then use this rule to show the data in a performance view. 2. You can use some dashboard solution: http://blogs.catapultsystems.com/cfuller/archive/2010/12/11/using-the-service-manager-2010-dashboard-for-operations-manager.aspx http://www.dundas.com/dashboard/http://OpsMgr.ru/

Another option: http://www.scom2k7.com/how-to-create-a-custom-scom-dashboard-to-show-key-management-group-information/ Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/