Technical guide of the OperationsManagerDW database?

[OperationsManagerDW,technical,guide,db]

Hi there

I'm look for a technical 'guide' to the OperationsManagerDW database, but
have been unable to locate one.

Is anyone aware of where such a guide can be located? I know other vendors
publish 'crib' sheets for their databses, so developers can understand where
everything is.

In order to create custom reports on our SCOM 2007 server, it is obviously
important to know where data is actually stored i.e. which table holds the
netbios names of the computer, the availablity record, heartbeat, that sort
of thing.

Advice appreciated

JHH

[Pete Zerger (MVP)]

You can look at the Opsmgr Report Authoring Guide or some of Daniel Savages
blog posts.

http://blogs.technet.com/momteam/archive/2008/04/11/using-the-data-warehouse-part-2-event-data.aspx


Regards,


Pete Zerger, MCSE(Messaging) | MCTS(SQL 2005) | MCTS(Opsmgr) | MVP - Opsmgr

MP Catalog: http://www.systemcenterforum.org/mps
Tools: http://www.systemcenterforum.org/tools
User Group: http://www.systemcenterusergroup.com

Post by OperationsManagerDW,technical,guide,db
Hi there
I'm look for a technical 'guide' to the OperationsManagerDW database,
but have been unable to locate one.
Is anyone aware of where such a guide can be located? I know other
vendors publish 'crib' sheets for their databses, so developers can
understand where everything is.
In order to create custom reports on our SCOM 2007 server, it is
obviously important to know where data is actually stored i.e. which
table holds the netbios names of the computer, the availablity record,
heartbeat, that sort of thing.
Advice appreciated
JHH