Information about SCOM Database Tables
-
Friday, February 01, 2013 10:24 AM
Hello All,
I need to find out the following information in SCOM database Like.
TICKET ID
Ticket Description
Tycket Type
Domain
Priroty
Catagory
Efforts
AlertRaisedDate
AlertClosedDate
Owner of Alert
Alert Assigned.
Can any One Let me Know the Tables of SCOM databse Where this information Exist.
All Replies
-
Friday, February 01, 2013 12:51 PMModerator
Hi,
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.
cheers,
StefanStefan Koell | http://www.code4ward.net
- Proposed As Answer by Graham DaviesMVP, Moderator Friday, February 01, 2013 5:08 PM
- Marked As Answer by Alex ZhaozxMicrosoft Contingent Staff, Moderator Thursday, February 21, 2013 8:23 AM
-
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.aspxKevin Holman http://blogs.technet.com/b/kevinholman

