Database Reference
In-Depth Information
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 and assign the
db_datareader role (you can leave the public role enabled).
5. Click on OK .
Next, we have to create a data source for the Orchestrator database in SQL Server Re-
porting Services. Perform the following steps:
1. Identify an instance of SQL Server Reporting Services that you will use for
Orchestrator reporting.
2. Open your web browser and navigate to http://[SSRS]/Reports . Replace
[SSRS] with the fully qualified domain name of the SQL Server Reporting Ser-
vices server. If SQL Server Reporting Service is running as a named instance, the
syntax of the URL will be http://[SSRS]/Reports_[InstanceName] .
3. Navigate to a folder of your choice or create a custom folder structure.
4. Click on New Data Source and complete the form as follows:
◦ Name: Orchestrator
◦ Data source type: Microsoft SQL Server
◦ Connection string: data source=[SCOSQL];initial cata-
log=Orchestrator (replace [SCOSQL] with the fully qualified do-
main name of the SQL Server which hosts the Orchestrator database)
5. Select Credentials stored securely in the report server .
6. Enter the username and password of the service account used for reporting.
7. Select Use as Windows credentials when connecting to the data source .
8. Click on Test Connection to validate the connection.
9. Click on OK to save the new data source.
The following table lists the views that you can use in your reports to display information
about the runbooks and the jobs in Orchestrator:
Search WWH ::




Custom Search