Service Manager Data Warehouse Troubleshooting

There are some great articles out there which talk about troubleshooting the Data Warehouse. In this article I will be going into explaining the internals of the Data Warehouse along with troubleshooting information. It is important to first of all understand how the DW Jobs work. There are some Jobs that are only visible by…

14

Update Rollup 4 for System Center 2012 R2 – important update for the Service Manager Data Warehouse

So, Update Rollup 4 for System Center 2012 R2 is out as you might know 😀 http://support.microsoft.com/kb/2992012 I encourage you to install UR4 for Service Manager because next to other fixes, there's a very important fix included here for the Data Warehouse. This is part of the fixes and improvements we are trying to bring to the…

2

Fixing Service Manager Data Warehouse Registration Information

There are quite a few situations where we end up having "corrupt" – actually orphaned or missing – information about the DW Registration. I have created a tool which you can use to fix *mostly* all such issues automatically. Using this tool you can delete all basic information about the DW Registration or if you…

5

How object GUIDs are created in Operations Manager and Service Manager

There are some questions on how the object GUIDs are calculated in Operations Manager and Service Manager when thinking about moving MPs to different Management Groups and/or side-by-side migration scenarios. Would the Groups created have the same GUIDs? When I talk about the GUID of an object, I am talking about the BaseManagedEntityId value of…

1

Data Warehouse issues after upgrading OM 2012 SP1 to R2

After upgrading SC Operations Manager 2012 SP1 to R2 you might notice general problems related to the Data Warehouse component, including Reporting of course. This may happen in situations where on upgrade there is more than one AlertDetail_GUID table in the DW database and not all will get upgraded to get the 2 new columns –…

0