O'Reilly logo

Microsoft System Center Reporting Cookbook by Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating reports using the operational database

Service Manager transfers the data to the data mart using an ETL process as described in the introduction of this chapter. The individual steps of the ETL process are implemented as data warehouse jobs that are run by the Service Manager Data Warehouse management server.

The entire ETL process cycle to transfer new data or data changes from the operational database to the data mart can take up to 1 hour to complete.

While this is okay for most common reporting needs, it can be an issue when you would like to get real-time information from Service Manager, such as the number of currently open and unassigned incidents.

In this recipe, we will access the Service Manager operational database to retrieve ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required