Managing Reports on Web Console

Table of Contents

Configure Options

To set the various options for some reports that are available through Web Console, see the Settings page for each report. Not all reports that appear on Web Console have options that you can configure. You can configure options for the following reports:

Filter Table Information

Using the filter button, you can search for a specific piece of information in each column. Any entry that contains the search criteria that you enter appears in the table.

To filter the table information:

  1. Open a report.
  1. Click the Filter Columns button.
  2. In the boxes under the column headings, type your search criteria.
  3. Press the ENTER key.

    Only those entries that match the search criteria that you typed appear in the table.

Supported Filters

You can use the characters in this table to filter the data in reports:

Operator Description Support
= equal to alphabetic and numeric values
< less than numeric values only
> greater than numeric values only
<= less than or equal to numeric values only
>= greater than or equal to numeric values only
&& and alphabetic and numeric values
|| or alphabetic and numeric values
!= not equal to alphabetic and numeric values
NOTLIKE not like

The string value must be surrounded by single quotes. Otherwise, the filter fails.

alphabetic and numeric values

Sort by Column

You can sort the table information based on any column.

To sort by column:

  1. Open a report.
  1. Click a column header to arrange information based on that column.

    Information in the table is rearranged according to the column header that you clicked.

Include and Exclude Columns

You can use the Choose Columns button to include or exclude columns.

To select columns:

  1. Open a report.
  1. Click the Add or remove columns button.
  2. Select the columns that you want to include in the table, and clear the columns that you want to exclude from the table.

    The columns that you cleared are removed from the table, and the columns that you selected appear in the table.

Manage Data Sources

Associate or disassociate the available reports with data sources in the list. You can also add, edit, and delete reports that are associated with the data sources.

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. At the top of the page, click Settings .
  5. Click the Manage Data Sources tab.
  6. To associate a report with a data source, next to the data source name, click Associate or Disassociate Reports to this Data Source .
    1. In the Select Reports list, click a report, and then click the right arrow button [>].

      The report moves to the Selected list.

    2. Click OK.
  7. To disassociate a report with a data source, next to the data source name, click Associate or Disassociate Reports to this Data Source .
    1. In the Selected list, click a report, and then click the left arrow button [<].

      The report moves to the Select Reports list.

    2. Click OK.
  8. To delete a data source, click Delete this Data Source .

    A message appears that asks you to confirm that you want to delete this data source from all reports.

    1. Click Yes.
  9. To edit a data source, click Edit this Data Source .

    The Edit dialog box appears.

    1. Change any of the settings as needed.
    2. Click Save.

Schedule Reports

Use scheduling to send reports to users at a particular time each day, week, or month. Reports automatically generate and then e-mail to specified users in the format that you select.

Only users who either created the report schedule or who have ownership of the report schedule can view, edit, disable, or delete the report schedule.

  1. Open a report.
  2. Click File, and then click Schedule.

    The Schedules dialog box appears.

  3. In the Name box, type a name for the scheduled report.
  4. Next to Format, select an output format for the report.
  5. In the Email Recipients box, enter one or more e-mail addresses for the users who will receive the report.

    Separate multiple e-mail addresses with a semi-colon (;), a comma (,), or a blank space.

  6. To save reports to a location on your network, select Save to network path, and then configure the location settings:
    • In the Network Path box, type the location where you want to save reports.
    • In the Username and Password boxes, type a user name, and associated password, that can access the network path location that you specified.
  7. Next to How frequently, select the frequency for generating and sending reports.
    • Daily
    • Weekly
    • Monthly
  8. In the At what time box, type the time of day that you want reports to generate.

    Schedules run according to the time zone that is set for the CommServe computer that hosts the Reports. For example, if your computer is set to a different time zone than the CommServe computer, then the report schedule runs according to the CommServe computer's time zone.

  9. Click Save.

    The report appears in the Existing Schedules list.

  10. Click Close.

If you have multiple Web Consoles, you can set the Web Console used for scheduled reports. For instructions, see Can I choose the Web Console used for scheduled reports?

Disable Report Schedules

Disable scheduled reports to temporarily suspend report generation. You can enable reports again at any time.

  1. Open a report.
  2. Click File, and then click Schedule.

    The Schedules dialog box appears.

  3. In the Existing Schedules list, select a schedule.

    The schedule details appear in the Edit Schedule section.

    You can view schedules only for the current report. If you want to view all scheduled reports, see the instructions under Viewing Job Schedules.

  4. Clear Enabled.
  5. Click Save.

    The report appears disabled in the Existing Schedules list.

  6. Click Close.

Delete Report Schedules

Delete scheduled reports to permanently cancel report generation.

  1. Open a report.
  2. Click File, and then click Schedule.

    The Schedules dialog box appears.

  3. In the Existing Schedules list, select a schedule.

    You can view schedules only for the current report. If you want to view all scheduled reports, see the instructions under Viewing Job Schedules.

  4. Click Delete .

    The report is removed from the Existing Schedules list.

  5. Click Close.

Delete Reports

You can delete reports that you downloaded from the Software Store from the Web Console or from Software Store.

Deleting Reports from Web Console

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. Hover over the report icon, and then click the down arrow button .
  5. Click Delete.

    A message appears that asks to confirm that you want to delete the report.

  6. Click Yes.

    The report is removed from the Reports page.

Deleting Reports from Software Store

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. At the top of the page, click Download from Store .

    The Login to Software Store dialog box appears.

  5. Type your user name and password for the Cloud Services site, and then click Login.

    The Software Store page appears.

  6. Next to the report name, click Delete .

    The report is deleted from your Metrics Reporting Server

Share Reports

You can share reports with other users and user groups where the option is available. Most reports that you build or download from software store include this option, however not all reports on Web Console can be shared.

Prerequisites

Your user account must be:

  • Assigned to a user group that has the Report Management capability.
  • Associated with the CommCell computer that hosts the Web Console.

Sharing Reports with Other Users

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. Hover over the report icon, and then click the down arrow button .
  5. Click Share.

    The Share dialog box appears.

  6. In the Available Users/Groups list, select the groups and users that you want to be able to view the report, and then click the right arrow button [>].

    User groups appear in bold and individual users do not appear in bold.

    The groups and users that you selected move to the Selected Users/Groups list.

  7. Click OK.

    To see the icon for the report immediately, reload the Reports page.

Delete a CommCell Computer from Private Metrics Reporting

To completely delete a CommCell computer from Private Metrics Reporting so that reports are no longer available, you must both delete the CommCell computer from the Web Console, and then disable data collection in the CommCell Console on the CommCell computer.

Deleting CommCell Computer Data from Private Metrics Reporting Server

You can delete all data related to a particular CommCell computer from the Private Metrics Reporting Server. When report data collection runs again, new data from the CommCell computer is uploaded to the Private Metrics Reporting Server. If you want to permanently remove the CommCell computer from Web Console Reports, you must also disable report data collection in the CommCell Console.

  1. Log into the Web Console for the Private Metrics Reporting Server.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. Click CommCells.
  4. Hover over a CommCell computer next to Hours Since Last Update, and then click Delete .

    A message appears that asks you to confirm that you want to delete all data related to the CommCell computer.

  5. Type Confirm in the box, and then click Delete.

    All data associated with the CommCell computer is removed from the Private Metrics Reporting Server and the CommCell computer is removed from the list on the CommCell Details page. The CommCell computer will appear on the list again after the next report data collection, unless you disable report data collection in the CommCell computer. For instructions, see Disabling Report Data Collection in the CommCell Console.

Disabling Report Data Collection in the CommCell Console

You can disable report data collection for Private Metrics Reporting Server at any time. If you disable the CommCell Diagnostics and Usage option, then the report data will no longer be collected and logged in the CommServe computer.  After you disable report data collection, the CommCell computer is marked as disabled on the CommCell Details page in Web Console Reports. To completely remove the CommCell computer from Web Console Reports, you must delete the CommCell computer. Data will continue to appear on the CommCell Dashboard and in the CommCell related reports until the previously collected data is aged.

  1. Log into the CommCell Console where data is collected.
  2. On the CommCell Console ribbon, click the Control Panel button.
  3. Click Private Metrics Reporting.

    The Private Metrics Reporting dialog box appears.

  4. To disable all data collection, on the General tab, clear CommCell Diagnostics and Usage.
  5. To disable data collection for a particular report, clear any of the following:
    • Health Check
    • Activity
    • Audit
    • Charge Back
  6. To disable client group settings, from the Client Group for Diagnostics list, clear the client group.
  7. To disable the download/upload computer, clear Use Proxy Client for Download and Upload.
  8. Click OK.

    Data collection no longer runs and data is no longer uploaded to the Private Metrics Reporting Server. To delete the CommCell computer from Web Console Reports, see Deleting CommCell Computer Data from Private Metrics Reporting Server.

Tag Reports

Use tags to organize the Reports page into categories that make sense for you. You can group reports based on any categories that you choose to create. Reports that are not tagged appear under the Untagged category. Tags created with Service Pack 7b or earlier are deleted when you install Service Pack 8. You must create new tags after you install Service Pack 8.

  1. Hover over the report icon, and then click the down arrow button .
  2. Click Tag.

    The Tag List dialog box appears.

  3. To add the report to an existing category, in the Add Tag box, select or type the name of a category that already appears in the Reports page, and then click Add.

    A tag is added for the category that you specified.

  4. To create a new category, in the Add Tag box, type the name of a category, and then click Add.

    A tag is added for the category that you specified.

  5. To delete the report from an existing category, next to the category name, click the delete button .

    The category tag is removed from the list.

  6. If you want all users to see the report in the categories that you specified, select Apply Tag changes to all users.
  7. Click Save.

    The report appears in the categories that are specified in Tags dialog box.

E-Mail Reports

Use e-mail to send the current version of a report to users. Reports are attached to the e-mail in the format that you select.

  1. Open a report.
  2. Click Actions, and then click Email.

    The Email Report dialog box appears.

  3. Next to Format, select an output format for the report.
  4. In the Email Recipients box, enter one or more e-mail addresses for the users who will receive the report.

    Separate multiple e-mail addresses with a semi-colon (;), a comma (,), or a blank space.

  5. Click Submit.

    A copy of the report is sent to the e-mail addresses that you specified.

Alert Notifications

Use alerts to monitor important system information such as the SLA percentage or the amount of disk space available in your system. Alerts for reports on Web Console include some of the functionality available in alerts on the CommCell Console. For more information about CommCell Console alerts, see Alerts and Notifications - Overview.

Alert notifications are sent out at the time that you configure them, and then again on every following day at the same time. A link to manage the alert or unsubscribe from the alert appears in each email alert notification. Alerts are not available in all reports, including the Scale Statistics Report and the Audit Reports. Alert options vary based on the purpose of the report data. If you have multiple Private Metrics Reporting Servers associated with one host CommServe computer, then an alert created in one Private Metrics Reporting Server can be seen on the other Private Metrics Reporting Server.

Set Alerts

This task covers setting alerts for all reports except for the Health Report. In the Health Report, each condition is based on the information displayed for each parameter. For instructions on setting alerts in the Health Report, see Health Report - Set Alerts.

In most reports, each condition type represents a column that is visible in the table. Just like the columns in reports, the corresponding alert conditions vary per report. Likewise, the value types that you can set vary per condition.

  1. Open the report.
  2. Click the Configure an Alert button.
  3. To set an alert based on the information in a column, select the column name, select a condition, and then type a value in the box.

    Values are not case sensitive.

    For example:

    Select Strikes, select More Than, and then type 2.

  4. To add more alerts based on information in columns, click Add Condition, specify the column name and value, and then choose when to send notifications.
    • To send the notification when all column conditions are met, next to Send notification email when, select all.

      You can use all when you specify a range with Less than and More than on the same numeric type column. Otherwise, you cannot use all when you set multiple conditions on the same column.

      For example:

      Select all, select Strikes, select Less Than, and then type 5.

    • To send the notification when any of the column conditions are met, next to Send notification email when, select any.

      For example:

      Select any, select Subclients, select Equal To, and then type 1.

    For more information on condition types, see Condition Types.

  5. In the Alert Name box, type a name for the alert.
  6. Specify the methods for sending alerts.

    For more information on the alert types, see Alert Types.

  7. Click Save.

    When the item reaches the column condition that you specified, a notification is automatically sent using the method that you specified.

View, Enable, or Disable Alerts

View All Alerts

  1. Log into Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. Click Actions, and then click Settings.
  4. On the Manage Alerts tab, click the name of an alert.

    The View Alert dialog box appears.

  5. To close the View Alert dialog box, click Cancel.

View Alerts for One Report

  1. Open a Report.
  2. Open the Configure Alert dialog box.
    • In the Health Report, hover over an item, and then click Set Alert.
    • For all other reports, click the Configure an Alert button.
  3. Click Manage Alerts.
  4. Click the name of an alert.

    The View Alert dialog box appears.

  5. To close the View Alert dialog box, click Cancel.

Enable or Disable All Alerts

  1. Log into Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. Click Actions, and then click Settings.

    The Reports Settings page appears.

  4. Select the alerts that you want to edit.
    • To select one or more alerts, next to the alert name, click the check box.
    • To select all alerts, click All.
  5. To enable the selected alerts, click Enable .
  6. To disable the selected alerts, click Disable .
  7. To delete the selected alerts, click Delete , and then click OK.

Enable or Disable Alerts for One Report

  1. Open a Report.
  2. Open the Configure Alert dialog box.
    • In the Health Report, hover over an item, and then click Set Alert.
    • For all other reports, click the Configure an Alert button.
  3. Click Manage Alerts.
  4. Select the alerts that you want to edit.
    • To select one or more alerts, next to the alert name, click the check box.
    • To select all alerts, click All.
  5. To enable the selected alerts, click Enable .
  6. To disable the selected alerts, click Disable .
  7. To delete the selected alerts, click Delete , and then click OK.

Condition Types

You can set the following types of conditions in alerts.

Type Description
String Use Equal To to create an alert based on a specific string of text or numbers. Use Contains to create an alert based on the inclusion of specified text or numbers. For example, to create an alert for the CommCell named "North America West," configure CommCell Name Equal To North America West, or CommCell Name Contains North America.
Integer Use Less Than, More Than, or Equal To to create an alert based on particular numeric values. For example, to create an alert for changes in Application Size, specify Application Size More Than 12 GB, or Application Size Less Than 1 TB.
Date and Time
  • Use In Last, Beyond Last, In Next, and Beyond Next to create an alert based on a particular time frame. For example, to create an alert for data collection during a date range, specify Collection Time In Last 30 days, or Collection Time Beyond Last 1 month.
  • Use Contains or Equal To to create a Date and Time alert based on a string of text. For example, to create an alert for the last job on a client ending in a particular month, specify Last Job End Time Contains Jul.
Value-based in Health Report Use values to create an alert based on a provided condition, such as "30 Day SLA is," and then enter an appropriate value. For example, to create an alert for a low SLA percentage, specify 30 Day SLA is Less Than 90%.
Status in Health Report Use Status Is to create an alert based on the configured status types, such as Critical, Warning or Good. For example, to create an alert for a critical SLA percentage, specify 30 day SLA's status is Critical.

Alert Types

The following alert notification types are available with Private Metrics Reporting. Reports on our Cloud Services Web site support only e-mail notifications. If you use this report on our Cloud Services Web Site, you cannot set alerts to display in the CommCell Console, display in Windows Event Viewer, or send e-mails using SNMP traps.

Type Description
Email IDs Sends the alert notification in an e-mail to the address that you specify. E-mail addresses can be separated by a semicolon (;), comma (,), or space.

You cannot use this method with the Windows Event Viewer and SNMP Traps methods.

Console Alerts Display the alert notification as a pop-up message in the CommCell Console.

You cannot use this method with the Windows Event Viewer and SNMP Traps methods.

Windows Event Viewer Displays the alert in the Windows Even Viewer application. The alert appears as Information from Galaxy.
SNMP Traps Sends alert notifications through SNMP Traps. Alert notifications are sent to the client computers that are configured to receive SNMP traps. There is a size restriction for SNMP Trap messages. Therefore, some SNMP Trap notifications might appear shortened.

You cannot use this method with the E-mail IDs and Console Alerts methods.

Advanced Settings

You can configure several settings that will affect all reports that you either built or downloaded from Software Store and some additional default reports, too. However, not all reports are affected by these settings. Using the settings on this tab, you can configure the data refresh interval, set the report timeout length, and hide the CommCell name from report output.

Set the Data Refresh Interval

Use the Data Refresh Interval setting to specify the amount of time that report data is cached on the Metrics Reporting Server. Once the Data Refresh Interval limit is reached, new report data is collected from the data sources. By default, the Metrics Reporting Server temporarily caches the report data for 15 minutes. If you want to collect the newest report data immediately, click the Refresh Now button.

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. At the top of the page, click Settings .
  5. Click the Advanced Settings tab.
  6. In the Data Refresh Interval box, type the number of minutes that you want the system to wait before checking for new report data.
  7. Click Save Settings.

Refresh the Report Data

Use the Refresh Now button to view the latest report data immediately, instead of waiting for the specified Data Refresh Interval. The Refresh Now operation forces the Metrics Reporting Server to delete all of its cached report data, and then collect new data from the data sources.

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. At the top of the page, click Settings .
  5. Click the Advanced Settings tab.
  6. Click Refresh Now.

    The local cache of report data is deleted and new report data is retrieved from the CommServe computer.

Set the Report Timeout

Use the Report Timeout setting to specify the amount of time reports are allowed to generate before timing out. For example, if a report contains a lot of data, then it might take a few minutes to generate. If reports take a long time to generate, you might want to increase the timeout length to allow the report generation more time to complete.

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. At the top of the page, click Settings .
  5. Click the Advanced Settings tab.
  6. In the Report Timeout box, type the maximum number of minutes that you want the system to wait before timing out during the report generation.
  7. Click Save Settings.

Hide the Data Source Column

You can use this setting to remove the Data Source, or CommCell Name, column from reports.

  1. Log on to Web Console.
  2. Click Reports.

    The Worldwide Dashboard appears.

  3. At the top of the page, click Worldwide Reports.
  4. At the top of the page, click Settings .
  5. Click the Advanced Settings tab.
  6. Select Hide Data Source Column, and then click Save Settings.

Export and Save

You can export reports from Web Console and open or save them in CSV, MHTML, and PDF formats.  You can share the individual URL for a report, but other users can see data only for the clients that they have access to. Also, report data is refreshed every 15 minutes, so if you want to share the point-in-time data, you must export and save the report to an available format.

Not all reports can be exported to all available file formats. See the Export Options page for each report to see the available export formats for that report.

Export to CSV

  1. Open a report.
  2. Click Export, and then click CSV.

    A copy of the report is downloaded to your computer. The download process might take some time, depending on the size of data in your report.

  3. When the download is complete, save or open the file.

Export to MHTML

  1. Open a report.
  2. Click Export, and then click MHTML.

    A copy of the report is downloaded to your computer. The download process might take some time, depending on the size of data in your report.

  3. When the download is complete, save or open the file.

Export to PDF

You can export reports to the PDF file format. PDF exports are limited to 12,000 rows of data.

  1. Open a report.
  2. Click Export, and then Click PDF.

    A copy of the report is downloaded to your computer. The download process might take some time, depending on the size of data in your report.

  3. When the download is complete, save or open the file.

Opening a CommCell Console

You can open a CommCell Console for any CommCell in the list.

  1. Log on to Web Console, and then click Reports.

    The Worldwide Dashboard appears.

  2. At the top of the page, click CommCells.
  3. In the CommCell row, under Hours Since Last Update, click the down arrow , and then click Console.

    The CommCell Console associated with the CommCell appears.

Opening a Web Console

You can open a Web Console for any CommCell in the list.

  1. Log on to Web Console, and then click Reports.

    The Worldwide Dashboard appears.

  2. At the top of the page, click CommCells.
  3. In the CommCell row, under Hours Since Last Update, click the down arrow , and then click Web Console.

    The Web Console associated with the CommCell appears.

Setting the Port Number for Uploads to Private Metrics Reporting Server

By default, Port 80 is used to upload collected data to the Private Metrics Reporting Server.

Configure Data Collection Settings for v9 CommCell Computers

If you have configured your v9 CommCell Computer to collect data for the Private Metrics Reporting Server, then you can also configure the upload and download URLs and set the upload frequency. By default in v9, data collection for the Cloud Services Web site is enabled. This procedure activates your Private Metrics Reporting Server, which takes priority over the Cloud Services Web site.

  1. On the CommServe computer, open Microsoft® SQL Server Management Studio.
    1. From the desktop, click Start.
    2. Click All Programs.
    3. Click the Microsoft SQL Server folder.
    4. Click SQL Server Management Studio.
  2. In the Connect to Server dialog box, enter the information to connect to the CommServe computer.
  3. Click Connect.
  4. In the Object Explorer panel, click the NetApp instance under the Databases folder.
  5. To set the download/upload URL, copy the following script into the code pane:

    update GXGlobalParam set value = '1' where name = 'CommservSurveyPrivateEnabled'
    update GXGlobalParam set value = '<Private Metrics Reporting Server URL>:<port>/downloads/sqlscripts/' where name = 'CommservSurveyPrivateDownloadsite'
    update GXGlobalParam set value = '<Private Metrics Reporting Server URL>:<port>/webconsole/' where name = 'CommservSurveyPrivateUploadsite'

    In the script, replace <Private Metrics Reporting Server URL> and <port> with the URL and port number of your Private Metrics Reporting Server.

    For example:

    • 'http://privatereportingserver.domain.com:80/downloads/sqlscripts/'
    • 'http://privatereportingserver.domain.com:80/webconsole/'

    You must include the forward slash (/) at the end of the URL, otherwise the upload/download does not work.

  6. In the toolbar, click Execute to run the script.