Change Reporting Configuration

NAVIGATION  System > Server Management > Configure > Change Reporting Config...

The Change Reporting Configuration dialog selects the type of reporting server used to run reports.

  • A built-in, proprietary report server is provided that requires no additional configuration.
  • If instead, a SQL Server Reporting Services (SSRS) is preferred, you can configure the VSA connection to the SSRS instance used to generate VSA reports. The SSRS may be installed locally or remotely from the Kaseya Server and locally or remotely from the SQL Server instance hosting the ksubscribers database.

Actions

  • Edit - Edits the reporting server configuration.
  • Test - Tests that reporting server configuration is working.
  • Run Registration - This button is used by developers to register newly created data sets for customizable reports, instead of running Reapply Schema for the entire VSA.

Options

  • Use Kaseya Reporting - If checked, a built-in, proprietary report server is used to run reports. Intended for smaller implementations of the VSA. This report server is used by default for new installs of the VSA. If blank, an SSRS report service is used to run reports. SSRS is intended for larger implementations. If blank, you must provide a Host Name URL to a SQL Server Reporting Services instance to run reports.
  • Reporting Timeout (Min) - Sets the time to wait for a report to complete publishing.
  • Host Name - The URL used by the VSA to connect to a SQL Server Reporting Services instance. Mandatory to run reports. The VSA typically uses one of the following URL patterns to connect to a SQL Server Reporting Services instance. Specifying the appropriate URL is mandatory to run reports.

    NOTE   - See the SSRS Configuration in the Kaseya Server Setup user guide for a visual walkthrough of the steps required to configure an SSRS reporting server.

    SQL on the same box as VSA

    http://localhost/ReportServer(most common)
    http://localhost/ReportServer$SQLExpress
    http://localhost/ReportServer_<SQLINSTANCENAME>
    http://localhost:<PORTNUMBER>/ReportServer_<SQLINSTANCENAME>

    SQL box separate from VSA

    http(s)://<SQLSERVERNAME>/ReportServer (most common)
    http(s)://<SQLSERVERNAME>/ReportServer$SQLExpress
    http(s)://<SQLSERVERNAME>/ReportServer_<SQLINSTANCENAME>
    http(s)://<SQLSERVERNAME>:<PORTNUMBER>/ReportServer_<SQLINSTANCENAME>

  • User Name - The user name used to access the Reporting Services instance when running reports. Applies to some configurations. See Adding Custom Credentials to a Remote Report Server in the Kaseya Server Setup user guide for a visual walkthrough of this configuration.
  • Logo - The URL of the image displayed in the header of reports. Applies to some configurations. By default, VSA report headers display the image specified by the System > Site Customization > Site Header. Changing the value in the System > Configure > Change Reporting Config... > Logo field overrides this default, changing the URL for report headers only. Changing the URL in the Change Reporting Config... > Logo field does not affect the display of the Site Header image. If a logo does not display in SSRS reports it may be due to either of the following conditions:
    • The SSRS is installed on the same machine as the Kaseya Server. SSRS is unable to retrieve the logo because of firewall issues. Change the URL to localhost from the externally available URL/IP address.
    • The VSA has been configured using a self-signed security certificate. Change the protocol from https to http.
  • Report URL Base - Overrides the URL used for CURL reports. For most reports the external VSA URL is used to generate reports but, an issue called "router loopback" can occur with CURL reports. Enter a different URL from the external VSA URL to avoid this issue. Defaults to http://localhost:80/
  • Concurrent Reports - Sets the number of reports that can be published simultaneously. Concurrent reports greater than this number are queued.
  • Keep All Reports - If No, Number of Days determines how long reports are kept. If Yes, all reports are kept and Number of Days setting is not applicable.
  • Keep Number of Days - Sets the number of days to keep a report after its creation date. Must be at least 30 days.

    NOTE   Only deletes reports created after the Number of Days value is enabled. Reports can be manually deleted from the <Kaseya_Installation_Directory>\WebPages\DataReports directory.