V11 SP8
Loading...

Cloud Metrics Reporting - Frequently Asked Questions (FAQ)

Table of Contents

Why doesn't the App Size in the Chargeback Report match all other reports?

The Chargeback Report includes pruned data in its App Size calculation. All other reports do not include pruned data.

Why don't the numbers match in the Chargeback and License Summary Reports?

Activity-disabled subclients are included in the calculation for the Chargeback Report, while activity-disabled subclients are excluded from the calculation for the License Summary Report. Also, the Capacity License calculation used in the License Summary Report counts the latest full backup jobs per subclient, while the Chargeback Report includes the largest full backup jobs.

Why don't the numbers match in the Capacity Growth and License Summary Reports?

The Capacity Growth Report displays the highest full backup size, while the License Summary Report displays the last successful full backup size.

How can I create the CommCell Computers Not Reachable Alert?

You can create an alert to send an email with a list of CommCell computers that do not report for more than a certain number of hours.

  1. Log into Web Console or the Cloud Services website, and then click Reports.
  2. From the navigation pane, click CommCells.
  3. Click the Configure an Alert button.

    The Configure Alert - Reports dialog box appears.

  4. Under Send notification email when, select Hours Since Last Update.
  5. Next to value, select More Than, and then in the box, type a number of hours.
  6. In the Alert Name box, type a name for the alert.

    For example, type CommCells Not Reachable.

  7. In the To the email id(s) box, type the email address where the notification should be sent.
  8. Click Save.

You will receive an email when one or more CommCell computers do not send data to the Reporting Server within the time period you specified.

Can I use regular expressions with masking?

Yes. You can use regular expressions to identify specific entities and file paths where data should be masked by using an additional setting. For instructions on how to add additional settings from the CommCell Console, see Add or Modify an Additional Setting.

  • On each CommServe computer where you want to configure masking for specific entities and file paths, add the appropriate additional setting:
    • To mask specific paths when forwarding data to a Private Metrics Reporting Server, on the CommServe computer, add the CommservSurveyPrivateScrubRegex additional setting and configure the following values:

      Property Value
      Name CommservSurveyPrivateScrubRegex
      Category CommServDB.GxGlobalParam
      Type String
      Value Type the regex that masks specific file paths. For example, (\B/[\w./$-]+(?: [\w./$-]+)*)|(((\\\\[a-zA-Z0-9-_.:\\$]+)(\\([a-zA-Z0-9_.-\\$]+ ?)+)?\\?))|(([a-zA-Z]:\\)+(([a-z-A-Z0-9_.-\\$]+ ?)+)*\\?).
    • To mask specific paths when forwarding data to the Cloud Metrics Reporting Server, on the CommServe computer, add the CommservSurveyScrubRegex additional setting and configure the following values:

      Property Value
      Name CommservSurveyScrubRegex
      Category CommServDB.GxGlobalParam
      Type String
      Value Type the regex that masks specific file paths. For example, (\B/[\w./$-]+(?: [\w./$-]+)*)|(((\\\\[a-zA-Z0-9-_.:\\$]+)(\\([a-zA-Z0-9_.-\\$]+ ?)+)?\\?))|(([a-zA-Z]:\\)+(([a-z-A-Z0-9_.-\\$]+ ?)+)*\\?).

    Note: Verify that your regex conforms to the proper format, and then add the proper regex in the Value box. If your regex is not properly formed, the regex causes a data processing failure in the Cloud Metrics Reporting server.

How can I control the data that appears in reports?

You can control the data that appears in reports by selecting which data collection scripts run on the CommServe computers. Use either an Include file or an Exclude file to specify the data collection scripts that you want to use. We recommend that you use only one file. When both the Include and Exclude files are used, the Exclude file takes precedence, and the Include file is ignored.

Include Data Collection Scripts

The Include file contains only the data collection scripts that you want to run. New scripts are not automatically added to this file. If you want to include newly created scripts, you must manually add them to the Include file.

  1. On each CommServe computer where data is collected for reports, under <Software>\Reports\CommservSurvey, create a text file named PublicMetricsInclude.txt.
  2. In PublicMetricsInclude.txt, type the name of each data collection script that you want to use. Each data collection script should appear on a single line.

    For example:

    CommservSurveyQuery_1.sql

    CommservSurveyQuery_3.sql

    CommservSurveyQuery_4.sql

    CommservSurveyQuery_5.sql

    CommservSurveyQuery_8.sql

  3. Save and close PublicMetricsInclude.txt.

Exclude Data Collection Scripts

The Exclude file contains only the data collection scripts that you do not want to run. New scripts are not automatically added to this list. If you want to exclude newly created scripts, you must manually add them to the Exclude list.

  1. On each CommServe computer where data is collected for reports, under <Software>\Reports\CommservSurvey, create a text file named PublicMetricsExclude.txt.
  2. In PublicMetricsExclude.txt, type the name of each data collection script that you want to exclude. Each data collection script should appear on a single line.

    For example:

    CommservSurveyQuery_3.sql

    CommservSurveyQuery_4.sql

    CommservSurveyQuery_5.sql

  3. Save and close PublicMetricsExclude.txt.

What types of information are collected?

Information That Is Collected

Default data collection includes CommCell operational information related to:

  • Features that are used
  • Type and number of snapshot engines
  • Languages used, based on user log-ins

Also, the service can be set to collect additional information related to:

  • Overall health of the CommCell, including SLA performance over the last month and disaster recovery backup statistics, which helps to identify the clients and policies that need to be tuned
  • Job statistics including strikes over the last week, largest clients over the last month, and top errors over the last day

Optionally, you can associate your organization with the collected data by entering contact information, such as the phone number and physical address for your organization.

Information That Is Not Collected

To protect your organization's privacy, we collect data only to gather statistics and graph data trends. For this reason, the following types of information are not collected:

  • Host names and IP addresses
  • File names and file paths

Where is the data sent?

The data that is collected for reports is sent to our secure, central Cloud Metrics Reporting Server. The information is used to help users analyze the performance of their CommCell computers.

Are the data upload and results secure?

Yes, the data collection process is secure. The XML upload file is transmitted using SSL to the Cloud Services site. Data is encrypted during the transmission using port 443.

How does the CommCell computer send and receive data?

To download and upload data, the CommCell computer must be able to connect to the following website: https://edc.commvault.com/downloads/SQLScripts/. If the CommCell computer is not connected to the Internet, then you can use any client computer in the CommCell that has Internet access. Configure the Internet Gateway settings in the E-mail & Web Server Configuration dialog box to do so. For instructions, see Using an Internet Gateway for Metrics Reporting.

Can I see the information that is collected?

Yes. You can see the information that is being collected from the CommCell computer. The information is stored in the "rptSurveyLog" table in the CommServe Database.

Who can see information for my CommCell environment?

Any administrator in your organization who has a Cloud Services Account can see the dashboard and reports for your CommCell environment. All CommServe computers that are licensed to the same company are visible to all administrative users associated with that company. Any user who is registered to a single CommServe computer in your organization can see information for all CommServe computers in your organization.

Where are the data collection scripts saved?

The CommCell computers in your organization automatically download a set of data collection SQL scripts from the Cloud Metrics Reporting Server. The data collection SQL scripts are automatically saved on the CommCell computer's installation directory in the location: Installation Path/Reports/CommservSurvey/public.

Where can I see a log of the script activity?

Information about which scripts ran and when the information is uploaded appears in the CVD.log file.

To see a log of script activity:

  1. On the CommServe, open the CVD.log file.
  2. Perform a search for Survey.

What happens if the upload fails?

If the data upload fails, then the service will try to upload again after 60 minutes. Upload failures are reported in the CVD.log file. Make sure your CommServe computer can connect to the URLs listed on External URLs for Commvault Features.

Can I use Cloud Metrics Reporting with an offline CommCell?

Yes. To participate in Cloud Metrics Reporting with an offline CommCell, you must select a proxy client for download/upload in the control panel. For instructions, see Using an Internet Gateway Computer for Metrics Reporting.

How much data is collected?

The XML files are small, usually less than a few megabytes (MB).

How much memory is used?

The amount of memory that is used is subject to other environmental variables, but generally it is less than the amount used to run reports on a CommCell Console.

How can I view reports for more than one CommCell?

When you create a user account for the secure cloud site by entering your e-mail address in the Register Product dialog box, that CommCell computer is associated with your user credentials. If you use the same e-mail address for multiple CommCells, then you will be able to view information for those CommCells with the same user account on the secure Cloud site.