Restore Job Summary Report - Advanced Operations

Table of Contents

Generate Event Message for Restore Jobs

You can configure the CommCell Console to generate an event message for restore jobs using the EnableRestoreDataAgeTracking global parameter. This global parameter allows you to track the age of the data that you are trying to restore by comparing the backup time with the retention settings on the storage policy copy.

  1. On the CommServe computer, open the Command Line.
  2. Execute the following Qscript command.

    qoperation execscript -sn SetKeyIntoGlobalParamTbl.sql -si EnableRestoreDataAgeTracking -si 1

  3. In the CommCell Console, run the Restore Job Summary Report.

    For each restore job, an event message appears in the Event Viewer.  For each restore job in the Restore Job Summary Report, under the Associated Events section, the following details appear:

    • Backup Job ID
    • Storage Policy name
    • Storage Policy Copy name
    • Backup Time

Scheduling the Report

  1. In the CommCell Console, select the Reports tab, and then on the ribbon, click the button for the report that you want to schedule.

    The Report Selection dialog box appears.

  2. Configure the report as needed.
  3. In the Report Selection dialog box, click Schedule.
  4. On the Schedule Pattern tab, in the Schedule Name box, enter a name for the schedule.
  5. Select the interval at which you want the report to run: One Time, Daily, Weekly, Monthly, or Yearly.
  6. In the Start Time box, type the time of day when you want the report generation to begin.
  7. Under Repeat, specify the exact times and days that you want the report to run.
  8. Click Ok.

Saving the Report Output

You can save the report output to a specified location.

  1. In the CommCell Console, select the Reports tab, and then on the ribbon, click the button for the report that you want to save.

    The Report Selection dialog box appears.

  2. Configure the report as needed.
  3. Select the Output tab, and then from the Output Format section, select a file format.
  4. Select Output To, and then enter the location to which you want to save the report.
    • To save the report to your local computer, select Use Local Drive On, and then in the Report Copy Location box, enter a location.
    • To save the report to a shared network drive, select Use Network Share, and then in the Report Copy Location box, enter a location.
    • To upload the report to an FTP site, select FTP Upload, and then click Settings to enter the FTP location and your credentials.
  5. From the Choose Locale list, select the language in which you want the report to appear.
  6. At the bottom of the Report Selection dialog box, click Run.

    The report opens in the file format that you specified and a copy of the report is saved to the location that you entered.

Saving a Report as a Template

You can save the report settings as a template in the CommCell Console, and then run the report at any time.

  1. In the CommCell Console, select the Reports tab, and then on the ribbon, click the button for the report that you want to make into a template.

    The Report Selection dialog box appears.

  2. Configure the report as needed.
  3. At the bottom of the Report Selection dialog box, click Save As.

    The Save As dialog box appears.

  4. Select Save a Report, and then enter a name for the template in the box.
  5. Click OK.

    The report template appears in the CommCell Browser under Reports > My Reports.

Generating a Report from a Template

You can generate a report from a template at any time.

  1. From the CommCell Browser, expand Reports > My Reports, and then click General.

    The General tab appears in the CommCell Console.

  2. In the General tab, right-click the name of the report that you want to generate, and then select Run Immediately.

    The report opens in the format that is specified in the template.

Modifying a Report Template

  1. In the CommCell Browser, go to Reports | My Reports | General.

    The General tab appears in the CommCell Console.

  2. In the General tab, right-click the name of the report that you want to change, and then select Edit.

    The Saved Reports dialog box appears.

  3. Select the Report Details tab, and then make changes on any of the available tabs.
  4. Click OK to save your settings.

Cloning a Report Template

  1. In the CommCell Browser, go to Reports | My Reports | General.

    The General tab appears in the CommCell Console.

  2. In the General tab, right-click the name of the report that you want to clone, and then select Edit.

    The Saved Reports dialog box appears.

  3. Select the Job Initiation tab, and then select Saved Report.
  4. Select Clone this report as, and then enter a name in the box.
  5. Click OK.

    The cloned report appears in the General tab.

Deleting a Report Template

  1. In the CommCell Browser, go to Reports | My Reports | General.

    The General tab appears in the CommCell Console.

  2. In the General tab, right-click the name of the report that you want to delete, and then select Delete.

    A message appears that asks if you are sure that you want to delete the selected Report Template.

  3. Click Yes.

    The report is removed from the General tab.

Setting a Report Alert

This option allows users or user groups to get an automatic notification when a report is created. Follow the steps given below to set up the criteria to raise notifications/alerts:
  1. In the CommCell Console, select the Reports tab, and then on the ribbon, click the button for the report that you want to set alerts for.

    The Report Selection dialog box appears.

  2. Configure the report as needed
  3. At the bottom of the Report Selection dialog box, click Schedule.

    The Schedule Details dialog box appears.

  4. Configure the schedule as needed.
  5. Select the Notification tab, and then click Add Alert.
  6. From the Add Alert Wizard dialog box, select the types of notifications that you want to send, and then click Next.
  7. Add recipients to the selected list.
    • To add a recipient that is a user in the CommCell, from the Available list, select a user, and then click Add.
    • To add a recipient that is not a user in the CommCell, in the Email to Recipients box, type an e-mail address.
  8. Click Next, and then click Finish.
  9. Click OK.
For additional information, see Alerts.

Saving a Report as a Script

The Command Line Interface allows you to generate reports from the command line. The commands can be executed from the command line or can be integrated into scripts. You can generate command line scripts for specific operations in the CommCell Console by using the Save As Script option.

To create an XML script that generates a report:

  1. From the CommCell Browser, expand Reports > My Reports, and then click General.

    The General tab appears in the CommCell Console.

  2. In the General tab, right-click the name of the report that you want to save as a script, and then select Edit.

    The Saved Reports dialog box appears.

  3. Select the Job Initiation tab, and then click Save As Script

    The Save As Script dialog box appears.

  4. Enter the appropriate settings to generate a script file.
    1. From the Client list, select the name of the client where you want to save the script.
    2. In the Path box, enter the file path where you want to save the script, and then enter a name for the script file at the end of the path.

      Ensure that the name of the file contains the .xml extension

    3. Click OK to create the script.

      A message appears that says that the script saved successfully

    4. Click OK.

    The Save As Script and the Saved Reports dialog boxes close.

For additional information, see Command Line Interface.