Configuring the Scheduled Reports Database List - On-Premise only

Updated by Cheryl Wallace

For On-Premise installations only where the ToolHound database is on a shared SQL Server, the databases polled for scheduled reports can be restricted if desired. The normal process for scheduled reports is to poll each database accessible by the SQL User in the connection string to validate whether it is a ToolHound database. If the user does not have access to other databases, this is not a concern.

If you updated from a version previous to 6.2022.10.27 using the Installer, the ScheduledReports block has already been added to the appsettings.json file with the default values. If you updated from a version previous to 6.2022.10.27 using the Patch, the ScheduledReports block must be added to the appsettings.json manually.

To configure the list of databases to be polled for scheduled reports, add the DatabaseList parameter to the ScheduledReports block in the appsettings.json file. The appsettings.json file is found on the application server in the installation path.

Example: single ToolHound database:

"ScheduledReports": {

"RunService": true,

"IntervalInMinutes": 120,

"Process": true,

"DatabaseList": "OleanderTH6" },

Example: multiple ToolHound databases:

"ScheduledReports": {

"RunService": true,

"IntervalInMinutes": 120,

"Process": true, 

"DatabaseList": "Production,Test" },

. ​​See also:

​Copyright © 2020-2022 ToolHound Inc. All Rights Reserved.

How did we do?