SCOM Console Data Concepts
I'm curious about some theory surrounding how the SDK service pulls data into the SCOM console. Is there any documentation available on this? What I would like to know: While working in the Monitoring pane of the admin console, what databases does the SDK service pull from? (ex. alert data pulled from OpsMgrDB or OpsMgrDW). If it depends on the type of data I would like to know what from where.
July 20th, 2011 12:01pm

Hi The data coming into the SCOM console is from the OperationsManager database. The OperationsManagerDW database stores long term reporting data. It won't be documented exactly which tables so you'll probably need to go through this yourself, section by section but it should be fairly obvious for the most part - there will be alert tables for alert data, performance tables for performance data etc - these tables will have a variety of links to tables where computer \ agent information is stored to translate the BaseManagedEntityID (guid) into a user friendly display name. If you want to see some of the queries, you can use SQL Profiler --> so start a profile, open the console, go to a specific view and "watch" the profile but I'm not sure if there is much to be gained. Are you looking for something in particular? There is a DW schema but I don't know of a schema for the OpsMgr database: http://technet.microsoft.com/en-us/library/gg508713.aspx In general I would suggest that "studying" the DW is more useful as that is what you will need to query for reporting data. Cheers GrahamNew SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 12:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics