Database Reference
In-Depth Information
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 real-time
information from the CMDB.
Tip
Accessing the Service Manager operational database
Note that accessing the operational database is not supported by Microsoft. It is possible
that the database schema might change between release cycles. Also, in order to prevent
locks from occurring when accessing the database, it is recommended that you always use
the
NOLOCK
query option.
