tag:blogger.com,1999:blog-5444303490086809720.post7715556957805181748..comments2009-06-28T11:30:38.565+02:00Comments on electric bunnies: SCOM 2007: Health state queryVanessahttp://www.blogger.com/profile/07973754120854307377noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5444303490086809720.post-81031451906763934912009-06-28T11:30:38.565+02:002009-06-28T11:30:38.565+02:00Even if the opsDB is not documented, it is pretty ...Even if the opsDB is not documented, it is pretty straightforward with a bit of exercise to figure out where things are stored AND pull data out of it.<br />But remember it is not supported to build applications/solutions on top of it.<br />The database should really be exclusively read/written by the Management Servers... not by you.<br />If you really feel you MUST query the db directly, use at least the "WITH (NOLOCK)" clause to avoid deadlocking the db (dirty reads - <a href="http://www.codinghorror.com/blog/archives/001166.html" rel="nofollow">http://www.codinghorror.com/blog/archives/001166.html</a> ) - or you might cause errors to SCOM's normal processing.Daniele Muscettahttp://www.blogger.com/profile/07013119983651255203noreply@blogger.com