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 Orchestrator runbook reports

Unlike most of the products in the System Center family, System Center Orchestrator does not include reporting out of the box. In this recipe, we will show you how you can access the Orchestrator database to create reports about your runbooks and the runbook instances.

Getting ready

Before we can access the Orchestrator database, we need to grant read permissions to a service account used for reporting. Perform the following steps:

  1. Identify or create a service account you will use for reporting.
  2. Start SQL Server Management Studio and connect to the SQL server that hosts the Orchestrator database.
  3. Expand Security and Logins, and add the reporting service account.
  4. Under User Mapping, select the Orchestrator database ...

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