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: