You are browsing the archive for 2010 June.

Avatar of kurtvh

by kurtvh

System Center Service Manager 2010 International RTM!

8:58 pm in Uncategorized by kurtvh

Microsoft has announced that SCSM 2010 International RTM is available! This release contains the localized version of SCSM 2010 and supports the following languages:

  • Chinese (simplified)
  • Chinese (traditional)
  • English
  • French
  • German
  • Italian
  • Japanese
  • Korean
  • Portuguese (Brazilian)
  • Russian
  • Spanish

180-days evaluation version download link to Microsoft download site.

Important note:

A single installation of the international version of SCSM supports all the languages listed above.  SCSM Console uses the OS Display Language setting and SCSM Portal uses the Browser’s Encoding setting to render the contents in the appropriate language.

Important information about this release:

Frequently Asked Questions about the SCSM 2010 International.

Some highlights:

  • It is not possible to upgrade from English to the International version of SCSM.
  • Starting from SCSM 2010 Service Pack 1, Microsoft is going to ship English and International versions of SCSM as one version of the product (sim-shipping)
  • The language of the server OS (SKU & OS Display Language) doesn’t impact the language of the client (console/browser) UI on the separate client computer.
  • Windows Client can be in any language (SKU & Display Language) supported by Windows Client OS
  • Language SKUs should be the same for all SQL Servers used for SCSM SM Servers and Data Warehouse
  • All SCSM SQL Servers (SMDB and DW) must have the same collation setting from the list of supported SQL Collations.
  • Read more from Microsoft Team blog – URl above


Have Fun,


Avatar of kurtvh

by kurtvh

Reporting in System Center Service Manager 2010 (part 1)

11:10 am in Uncategorized by kurtvh

In the following blog posts I want to provide an overview of the reporting functionality in Service Manager. Extracting data out of the service management tool for analysis or performance measuring is an important functionality. System Center Service Manager includes strong reporting capabilities witch are based on SQL reporting services (and also takes advantage of it).

SCSM reporting is integrated into the management console in the same way as can be seen in Operations Manager 2007. Leveraging the capabilities of SQL Reporting Services, analysts are able to create favorite reports, schedule reports, and automatically generate reports that are sent by mail, uploaded to a Share Point site, or stored on a file share.

In this post I want to provide an overview of the building blocks of the reporting functionality in Service Manager. Subsequent post on this topic will cover:

  • Reporting functionality in the Service Manager console. Access reports, set permissions, export data, link reports…
  • SCSM reporting – Configure subscription and schedule reports through SQL SRSS.
  • SCSM reporting – Creation and deployment of a custom reports using SQL Server Report Builder.
  • SCSM reporting – SCSM report integration into SharePoint.


Basic SCSM reporting functionality overview

Service Manager Server is the component that is accessed for importing management packs, import CI’s via connectors or CSV or perform actions via management console by analysts. All these actions and information is stored in the Data Warehouse  database for reporting access or long term retention. The Data Warehouse DB (DWDataMart) and SQL reporting services are the additional SCSM components who enable the access to this data.

Data Warehouse

  • The Service Manager DataWarehouse is a collection of databases and scheduled processes which automatically ingest and optimize data for reporting & analysis from one or more Service Manager management groups.
  • It is designed to be self managing and highly extensible, automatically altering it’s schema and code based on the management packs which have been imported into the Service Manager management groups to which it is registered.
  • By default, the data warehouse refreshes it’s data for reporting purposes hourly and retains data for 3 years. Out of the box there are 5 automated processes, called jobs, which manage the data warehouse:
    • Management Pack Synchronization (“MPSync”)
      • The MPSync job is responsible for building out the data warehouse structure.
      • It looks for new and/or updated management packs from all of the registered Service Manager management groups, and based on what it finds it deploys new tables and/or code as needed to account for changes in classes, relationships and/or warehouse elements
    • Extract, Transform & Load (ETL): The ETL process refreshes the data in the warehouse. This is logically a sequential flow of data:
      • The Extract jobs acquire data from registered SM servers. There is one Extract job per management group.
      • The Transform job optimizes the data for reporting needs and shapes the data according to the defined business rules.
      • The Load job populates the data mart for long term retention and access.
    • DWMaintenance:
      • The maintenance job takes care of grooming out archived data as well as handling database optimization tasks like partitioning and index management.


  • Reporting in Service Manager is based on Microsoft SQL Server 2008 Reporting Services.
  • The Service Manager console connects to the Reporting Services server specified during installation and displays the folder structure and list of reports stored under the /SystemCenter/ServiceManager folder.
  • The Service Manager console can render any valid Reporting Services report, even if it connects to other databases. This enables consolidating all of your IT organizations’ reporting needs in one place for easy access.
  • The SCSM console is fully integrated with Reporting services security, such that users accessing the console will only see folders and/or reports to which they have access.
  • Analysts and developers can utilize the business intelligence products they are already familiar with such as Report Builder and SQL Server Business Intelligence Development Studio to easily create new reports or customize existing reports.


Bringing it all together




In next reporting post I will cover the reporting functionality that is provided in the Service Manage console.

Have fun,