Hi All,

I have been tasked with researching how to integrate SCOM with other 3rd party management tools.  Specifically extracting alerts and sample data from performance counters for reporting.  In other words, read-only extraction (i.e. not updating SCOM from an external application).  From what I can gather, the best method for accessing alerts and counters is to query the data warehouse (e.g. OperationsManagerDW) directly using SQL.  Is the schema published and if so, where?  Is there a better solution such as a REST API, WMI, or a Java SDK method that would be better suited for this integration task?

Thanks!

There are a bunch of dataset examples here that could be useful:

http://blogs.technet.com/b/jonathanalmquist/archive/tags/report+datasets/default.aspx

Data Warehouse Schema here:

https://technet.microsoft.com/en-us/library/gg508713.aspx

Although all SCOM data, alert and performance, is stored in OperationsManager and OperationsManagerDW, SQL Server. You can use SQL to retrieve these data. However, it is not advisbale to doing so because it is not support by Microsoft which means that will not guarantee that it is workable on next version of SCOM. I recommend that using Powershell to extract alert and performance data is better.
Retrieve Performance Data with Powershell
https://gallery.technet.microsoft.com/scriptcenter/Retrieve-Performance-Data-c4595e2a
Retrieve Alert information with PowerShell (Get-SCOMAlert)
https://technet.microsoft.com/en-us/library/hh918457%28v=sc.20%29.aspx?f=255&MSPPError=-2147217396
Roger

You can use SQL to retrieve these data. However, it is not advisbale to doing so because it is not support by Microsoft...

Roger - can you provide any Microsoft documentation advising that this is not supported? This would be shocking news to me.