Reporting

This section describes how to create different types of reports for managed Kaspersky Security Center virtual servers or Kaspersky Business Hub companies in ConnectWise Manage.

Service report

You can create a regular service report for a representative of a managed company. This report includes statistics on protection services provided to the client. You can view this report for the last 30 days and the last 7 days. Kaspersky Security Integration with ConnectWise Manage updates statistics daily.

A report can be built for a particular managed company linked to Kaspersky Security Center virtual server or Kaspersky Business Hub company, by using the standard ConnectWise Report Writer. The name of a service report configuration item in ConnectWise Manage contains the report period, the report starting date and ending date, and the name of the Kaspersky Security Center virtual server. (If you use Kaspersky Business Hub, the name of the Kaspersky Business Hub Company will not be included). If the name of a service report configuration item is more than 100 characters long, its length is reduced.

A generated report includes statistics on tickets processed during the report period and on the state of managed computers in the customer infrastructures.

A service report includes the following data:

• Report period—Either 7 days or 30 days.
• Report starting date
• Report ending date
• Managed computers—Number of computers of the managed company that are connected to the Kaspersky Business Hub company or Kaspersky Security Center virtual server.
• Protected computers—Number of computers on which a real-time protection application is installed.
• New critical tickets—Number of tickets based on critical events or computer statuses that were created by Kaspersky Security Integration with ConnectWise Manage during the report period (regardless of whether or not these tickets were closed during the report period). Tickets based on events are created according to the rules that you set as described in Ticketing for events. Tickets based on computer statuses are created according to the rules that you set as described in Ticketing for computer statuses.
• Closed critical tickets—Number of tickets based on critical events or computer statuses that were resolved and closed by Kaspersky Security Integration with ConnectWise Manage during the report period (regardless of whether or not these tickets were created during the report period).
• New warning tickets—Number of tickets based on warning events or computer statuses that were created by Kaspersky Security Integration with ConnectWise Manage during the report period (regardless of whether or not these tickets were closed during the report period).
• Closed warning tickets—Number of tickets based on warning events or computer statuses that were resolved and closed by Kaspersky Security Integration with ConnectWise Manage during the reporting period (regardless of whether or not these tickets were created during the report period).
• New functional failure tickets—Number of tickets based on functional failure events that were created by Kaspersky Security Integration with ConnectWise Manage during the reporting period (regardless of whether or not these tickets were closed during the report period).
• Closed functional failure tickets—Number of tickets for functional failure events that were resolved and closed by Kaspersky Security Integration with ConnectWise Manage during the report period (regardless of whether or not these tickets were created during the report period).
• Problem computers—Number of computers whose status is other than OK at the moment the configuration item is created.

License report

You can create a license report for a client company to provide information about keys for the Kaspersky Lab security applications, including key usage and availability.

The name of a license report configuration item in ConnectWise Manage contains the last update date of the configuration item and the name of the security application to which the license applies. If the name of a license report configuration item is longer than 100 characters, it is cut.

A license report includes the following data for each key:

• Report date—Last update date of the configuration item.
• License ID
• Security application name
• License period
• License expiration date
• License restriction—Number of computers to which the key can be assigned.
• Number of company's computers using the license—Number of computers to which the key is assigned. These computers belong to the selected client company.
• Total number of computers using the license—Number of computers to which the key is assigned. These computers belong to all client companies of the MSP or to the MSP itself.
• Key is more than 90% used—If the total number of computers that use the key divided by the license restriction is greater than 0.9, the value is Yes. Otherwise, the value is No.
• Key exceeded restriction—If the total number of computers that use the key divided by the license restriction is greater than 1, the value is Yes. Otherwise, the value is No.
• License information—Additional information about the key.
• Support information—Information about Technical Support contacts.

Generating a report in ConnectWise Manage

A service report is provided in ConnectWise Manage as configuration items of a special Kaspersky report type. A license report is represented as configuration items of the Kaspersky license report type.These items are also linked to managed company profiles according to the mapping to companies or virtual servers.

To generate a report for a managed company in ConnectWise Manage:

1. On the left navigation menu, point to System, and then click Report Writer.
2. Click the New button.
3. On the Data Sources tab that opens, select the v_rpt_Configuration check box.
4. Click the Fields tab, and then add the following fields:
   • Question
   • Answer

   These fields will be names of columns in the report.

5. Click the Filters tab, and then add the following filters:
   • Filter: Company_Name; Operator: Equals (Select); Value(s): in the drop-down list, select the managed company for which you want to view the report.
   • Filter: Config_Name; Operator: Equals (Select); Value(s): in the drop-down list, select the configuration item that corresponds to the required report type (Kaspersky report or Kaspersky license report) and—for a service report—period (start date and end date).
6. If you want the report to display additional information, add other fields and filters. For more details, refer to the ConnectWise Manage documentation at https://docs.connectwise.com/ConnectWise_Documentation/090/070.
7. Click the Preview button to preview the report.
8. Click the Save button to save the report.
9. Export the report, print it, or send it by email to your client.

   You can export the report to a CSV file, a Microsoft Excel spreadsheet, a Microsoft Word document, or an XML document. You can also save the SQL query that matches the specified report parameters to a text file.