Sharing this list of random SQL queries I have found useful on different occasions. Refer to report dataset samples page for SQL queries you can use for custom reporting needs.
I do not moderate this blog anymore. If you have a question regarding this post, send me a message.
<p>Jonathan Almquist started a blog post about Operations Manager 2007 SQL Queries . “I’m starting a new</p>
<p>Jonathan Almquist a posté sur son blog un tableau des principales requêtes SQL. Cette initiative est...</p>
<p>Nice list, thanks. As the base I used a query from your list. Then I used that query as derative to count and calculate the average number of events per day. Easy/simple but effective.</p>
<p><a rel="nofollow" target="_new" href="http://michielw.blogspot.com/2010/09/scom-average-events-per-day-keeps.html">michielw.blogspot.com/.../scom-average-events-per-day-keeps.html</a></p>
<p>Very nice list. Is there a SQL query to determine what subscription an objects is tided to? </p>