Displaying Service Manager Reports in SharePoint

As most may be aware, the reporting in Service Manager is an in-console experience. Having reporting in the console has some very direct benefits: Users of Service Manager do not need to go to an external location to find that critical information that they need. Users can run “contextualized” reports. This means that if users… Read more

Data Warehouse – Anatomy of Extract, Transform, Load (ETL)

In my last post I went over the Deployment process that brings over MP’s from Service Manager and how those MP’s drive the structure, data, and reports for Data Warehouse and Reporting. Once the schema and reports are deployed, we need to populate the database with some actual data for reporting purposes. This is done… Read more

Data Warehouse – Anatomy of DW/Reporting Deployment

  In my last post I went over the management pack synchronization process that brings over MP’s from Service Manager and how those MP’s drive the structure, data, and reports for data warehouse and reporting. Once those MP’s are synchronized between Service Manager and the data warehouse, we need to get the data and/or reports… Read more

Data Warehouse – Anatomy of Management Pack Synchronization

In my last post I gave an overview of some of the components that make up Data Warehouse and Reporting. One of the components of the DW is the Management Pack Synchronization. Because the structure and data within the DW is driven by MP’s within Service Manager we need to be able to regularly synchronize… Read more

Service Manager Data Warehouse and Reporting

Hi, my name is Chad Rowe and I am a Program Manager for the System Center Service Manager team working on the data warehouse and reporting features. I’ve been with the team for about 8 months and prior to that I worked within Microsoft’s IT organization for 9+ years managing operations teams that supported our… Read more