Operations Manager 2007 SQL Queries
I’m starting a new post here, similar to my Command Shell reference. This will include some useful SQL queries that I happen to need and direct my customers to on a daily basis. If you don’t see something here, check Kevin Holman’s blog. He’s already got a library of useful queries posted, in which I will not duplicate here.
I will continue to update this table periodically. If you subscribe to my blog, you will receive each new example as I post it.
Note: The queries in each link are a direct paste from the SQL query editor. They do not look pretty. Simply copy the content into your query editor to see proper formatting.
Replace any text in red in each example with your specific parameters or criteria.