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:
  • HTML-based menu driven documentation of the OperationsManager database for a base Operations Manager 2012:

http://www.systemcentercentral.com/download/opsmgr-2012-database-schemas-operationsmanagerdw-db-2/

Thank you to Pete Zerger for his two HTML-based menu driven documents above and the Paul Johnson for the additional MS link!