There’s a series of useful SCOM database queries written by Kevin Holman (http://blogs.technet.com/b/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx). I got a bit tired of copy-pasting them over and over again. That’s why i created a small Reports Management Pack that you can import.
After you’ve imported it, you’ll find the new Report under the “Reporting” pane.
Run it and you will get your result. I’m planning to include some more useful queries later on.
You can download the Management Pack Here