I’ve been asked several times recently the same question about what we know about the layout of the OperationsManager and OperationsManagerDW databases. The links below summarize what I have been able to find (if you know of others please reply to this blog post with additional information!)
- OpsMgr 2007 R2 DW SQL Schema link from Microsoft: http://technet.microsoft.com/en-us/library/gg508713.aspx (NOTE: This does not include the Exchange MP Version Schema additions to the DW)
- HTML-based menu driven documentation of the OperationsManagerDW database for a base Operations Manager 2012: http://www.systemcentercentral.com/download/opsmgr-2012-database-schemas-operationsmanager-db/
- HTML-based menu driven documentation of the OperationsManager database for a base Operations Manager 2012:
Thank you to Pete Zerger for his two HTML-based menu driven documents above and the Paul Johnson for the additional MS link!