Can SCOM monitor the result of a SQL query? We can produce a result record-set which has a value 1 or 0 to indicate if a service has working data flow beneath.

Hi Stefan Stranger gives a run through here about running a SQL query as part of a monitor and changing state depending on the result returned. http://blogs.technet.com/b/stefan_stranger/archive/2009/02/02/opsmgr-sql-full-or-differential-backup-check.aspx You just need to change the query and healthy \ unhealthy state values. Cheers GrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/