Friday, February 01, 2013 10:24 AM
I need to find out the following information in SCOM database Like.
Owner of Alert
Can any One Let me Know the Tables of SCOM databse Where this information Exist.
Friday, February 01, 2013 12:51 PMModerator
take a look at Kevin Holman's blog about useful SQL queries:
The first section is about alert related data. This should help you identify the tables and views you need to query to get your information.
Stefan Koell | http://www.code4ward.net
Sunday, February 03, 2013 1:07 AMModerator
You also might find this spreadsheet interesting - which links the details in an alert to the alert table, alert view, and SDK.http://blogs.technet.com/b/kevinholman/archive/2009/09/23/alert-notification-subscription-variables-and-linking-that-to-the-console-database-and-sdk.aspx
Kevin Holman http://blogs.technet.com/b/kevinholman