Using Command Line Reports

Table of Contents

Overview

Command Line Reports provide a way to collect information on CommCell components directly from the command line. You can use the scripts that appear in the following sections to create or customize reports to reflect the data in your organization.

Consecutive Job Failure Report

The Consecutive Job Failure Report lists the following:

  • Number of failed backup jobs (strikes) since the last failed backup job for each backup type on each subclient
  • Number of days that the backup job failed
  • Job ID from the last failed backup job

Multiple failed backup jobs for the same client on the same day count as one failure. A successful full backup job resets the strike count to zero. A day with at least one successful backup job is not counted as a strike.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved in the location that you specified.

Example

To see a list of backup jobs that failed since the last full backup on each subclient, including synthetic full backup jobs, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Parameters

The report script includes several parameters that you can set, according to your information needs. Parameters for the Consecutive Job Failure Report include the following:

Parameter Description Default Setting
BackupWindowFrom Time format: HH:MM. Specifies the backup window for the report.

The backup window is 24 hours. Therefore, the count begins at the time that you specify on the previous day and ends at the same time on the current day. If you want to see all backup jobs that occurred between 9:00 p.m. yesterday and 9:00 p.m. today, enter 21:00.

18:00
countSynthFull This switch includes or excludes Synthetic Full backup jobs in the count. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Consecutive Job Failure Recovery Report

The Consecutive Job Failure Recovery Report lists the first successful backup job since the last failed backup for each Subclient/Backup Type combination and the last successful backup job after the last failed backup during the specified number of days. The number of days that the backup failed, the job ID from the last failed job, the recovered backup job id and its start and end times are included in this report.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved in the location that you specified.

Example

To see a list of backup jobs that recovered from failure since the last failed backup on each subclient, including synthetic full backup jobs, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Parameters

The report script includes several parameters that you can set, according to your information needs. Parameters for the Consecutive Job Failure Recovery Report include the following:

Parameter Description Default Setting
BackupWindowFrom Time format: HH:MM. Specifies the backup window for the report.

The backup window is 24 hours. Therefore, the count begins at the time that you specify on the previous day and ends at the same time on the current day. If you want to see all backup jobs that occurred between 9:00 p.m. yesterday and 9:00 p.m. today, enter 21:00.

18:00
countSynthFull This switch includes or excludes Synthetic Full backup jobs in the count. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Long Running Jobs Report

The Long Running Jobs Report provides a list of the longest running jobs based on the jobs that ran for more than the specified amount of time on each client over the specified time period. Aged jobs and active jobs can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved in the location that you specified.

Example

To see the longest running jobs in the CommServe, based on the 20 largest full backup jobs that ran for at least 12 hours, over the last 31 days, with active and aged jobs excluded, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your information needs. Parameters for the Long Running Jobs Report include the following:

Parameter Description Default Setting
LastDays Numeric value. Specifies the number of days over which the report gathers information. 1
LongRunHours Numeric value. Specifies the number of hours a job must run before it is included in the report. 8
TopN Numeric value. Specifies the maximum number of jobs from each client to include in the report information. 10
BackupType Text only. Specifies the types of backups that appear in the report information. Options include the following:
  • Full
  • Synthetic Full
  • Incremental (includes Differential and Log backup types)
blank
ActiveJobsOnly This switch includes or excludes active jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
CountAgedJobs This switch includes or excludes aged jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Large Clients Report

The Large Clients Report provides a list of the largest clients based on the number of jobs that ran on each client. Aged jobs and active jobs can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved in the location that you specified.

Example

To see the largest clients in the CommServe over the last 31 days, with aged jobs excluded, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your information needs. Parameters for the Large Clients Report include the following:

Parameter Description Default Setting
LastDays Numeric value. Specifies the number of days over which the report gathers information. 1
TopN Numeric value. Specifies the maximum number of jobs from each client to include in the report information. 10
CountAgedJobs This switch includes or excludes aged jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Slow Clients Report

The Slow Clients Report provides a list of the slowest clients, based on the backup jobs with the lowest throughput rates over the specified period of time. Aged jobs can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the top 100 clients with the slowest throughput rate for full backup jobs over the last 31 days, with aged jobs excluded, run the following command.

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    qoperation execscript –sn QS_SlowestClients -help

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Slow Clients Report include the following:

Parameter Description Default Setting
LastDays Numeric value. Specifies the number of days over which the report gathers information. 1
TopN Numeric value. Specifies the maximum number of jobs from each client to include in the report information. 10
BackupType Text only. Specifies the types of backups that appear in the report information. Options include the following:
  • Full
  • Synthetic Full
  • Incremental (includes Differential and Log backup types)
blank
CountAgedJobs This switch includes or excludes aged jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Low DeDuplication Jobs Report

The Low DeDuplication Jobs Report provides a list of full backup jobs with the lowest percentages of deduplication on the CommServe over the specified period of time. The report can include or exclude aged jobs.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see a list of full backup jobs with the 10 lowest deduplication percentages of 40% or lower, over the last 24 hours, including aged jobs, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Low Deduplication Jobs Report include the following:

Parameter Description Default Setting
LastDays Numeric value. Specifies the number of days over which the report gathers information. 1
TopN Numeric value. Specifies the maximum number of jobs from each client to include in the report information. 10
LowDedupePct Numeric value. Specifies the percentage of deduplication in backup jobs. 40
BackupType Text only. Specifies the types of backups that appear in the report information. Options include the following:
  • Full
  • Synthetic Full
  • Incremental (includes Differential and Log backup types)
blank
CountAgedJobs This switch includes or excludes aged jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Subclient Storage Utilization and Prediction Report

The Subclient Storage Utilization and Prediction Report provides information about the storage consumed by subclients over the specified number of days, weeks, months, or years and calculates the current and future cost of storing data for each subclient. The current activity period can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the amount of storage consumed by subclients on a daily basis, over the last 4 days, and predict the storage needed for the next 4 days, including the cost of storage for the ccg_window client group, starting at 4:00 p.m. yesterday and  including the current period, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Subclient Storage Utilization and Prediction Report include the following:

Parameter Description Default Setting
Frequency Text only. Specifies the frequency with which the report gathers information. Applies to both the NumberOfPoints and PredictionPoints parameters. Options include the following:
  • Daily
  • Weekly
  • Monthly
  • Yearly
Weekly
NumberOfPoints Numeric value. Specifies the number of Frequency points, such as days, weeks, months, or years. 4
PredictionPoints Numeric value. Specifies the number of Frequency points, such as days, weeks, months, or years, over which to predict information. 1
CostPerGB Numeric value. Cost of 1 gigabyte of data. 1
AddlCostPerGB Numeric value. Additional cost of 1 gigabyte of data. 0
ClientGroupName Optional. When specified, only clients that belong to this client group appear in the report. blank
BackupFrom Time format: HH:MM. Specifies the backup window for the report.

The report begins at the time that you specify on the previous day, week, month, or year that you selected and ends at the same time on the current day. If you want to see all backup jobs that occurred between 9:00 p.m. 4 days ago and 9:00 p.m. today, enter 4 for NumberOfPoints, and then enter 21:00 for BackupFrom.

18:00
IncludeCurrentPeriod This switch includes or excludes the current activity. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Front End Capacity Usage Report

The Front End Capacity Usage Report provides information about the amount of storage space on a CommServe that is used by each organization, or entity, over the specified number of days, weeks, months, or years and calculates the current and future cost of storing data. The current activity period can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the amount of storage space consumed by each entity in a CommServe on a weekly basis, over the past 4 weeks, and also predict the size and cost of the storage for the next 2 weeks, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Front End Capacity Usage Report include the following:

Parameter Description Default Setting
Frequency Text only. Specifies the frequency with which the report gathers information. Applies to both the NumberOfPoints and PredictionPoints parameters. Options include the following:
  • Daily
  • Weekly
  • Monthly
  • Yearly
Weekly
NumberOfPoints Numeric value. Specifies the number of Frequency points, such as days, weeks, months, or years. 4
PredictionPoints Numeric value. Specifies the number of Frequency points, such as days, weeks, months, or years, over which to predict information. 1
CostPerGB Numeric value. Cost of 1 gigabyte of data. 1
AddlCostPerGB Numeric value. Additional cost of 1 gigabyte of data. 0
IncludeCurrentPeriod This switch includes or excludes the current activity. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Weekly Backup Summary Report

The Weekly Backup Summary Report provides a list of all backup jobs that ran over a week, beginning on the specified date. Deduplication and aged jobs can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the backup jobs that run on a CommServe over a week, starting at the specified date, excluding deduplicated and aged jobs, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Weekly Backup Summary Report include the following:

Parameter Description Default Setting
StartDate Date format: YYYY-MM-DD. Specifies the date on which to begin the report. yyyy-mm-dd
DedupOnly This switch includes only or excludes all deduplicated backup jobs. Options include the following:
  • Include: 1
  • Exclude: 0
1
CountAgedJobs This switch includes or excludes aged jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Execute View Reports

The Execute View Reports allow you to create a CSV file of any of the CommCell SQL views. In addition, you can further configure the output with the optional parameters.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the CommCell Client Version view, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes parameters that you can set, according to your needs. Parameters for the Execute View Reports include the following:

Parameter Description Default Setting
ViewName Required. Text only. Name of the view. Options include the following:
  • CommCellAdminSchedule
  • CommCellAuxCopyInfo
  • CommCellBackupInfo
  • CommCellBkSchedule
  • CommCellBkupSizeInfo
  • CommCellBkScheduleInfo
  • CommCellClientConfig
  • CommCellClientFSFilters
  • CommCellClientLevelBkpJobSummary
  • CommcellClientVersion
  • CommCellCompletedBkpJobsInfo
  • CommCellDriveInfo
  • CommCellJobController
  • CommCellJobControllerCount
  • CommCellLibraryInfo
  • CommCellLibraryReservInfo
  • CommCellLicense
  • CommcellMAVersion
  • CommCellMediaAgentInfo
  • CommCellMediaInDrives
  • CommCellMediaInfo
  • CommCellPrePostCmdInfo
  • CommCellRestoreInfo
  • CommCellRetentionInfo
  • CommCellStoragePolicy
  • CommCellSubClientConfig
  • CommCellUpdateInfo
N/A
SelectClause Optional. Comma separated list of column names and any aggregate functions, such as MAX, etc. N/A
WhereClause Optional. SQL Where clause condition. N/A
Top Optional. Numeric value. Specifies the top number of rows that are returned for the result set. N/A
GroupBy Optional. Comma separated list of columns. N/A
OrderBy Optional. Comma separated list of columns. Sorts the result set by the columns that you specify in this parameter. N/A

Data Growth Prediction Per Storage Policy Report

The Data Growth Prediction per Storage Policy Report predicts the number of days that each library can be used, based on the amount of data growth over the specified time period and the current amount of free space for each storage policy. Displays additional information including the duration of the backup job, data throughput rate, associated MediaAgent, and Library name.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the amount of backup data stored on disk for a specific storage policy over the last 3 months, and how much data is predicted to store over the next 5 months, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Data Growth Report include the following:

Parameter Description Default Setting
Frequency Text only. Specifies the unit of time over which to gather information. Options include the following:
  • Day
  • Week
  • Month
Week
Periods Numeric value. Specifies the number days, weeks, or months over which to gather information. This parameter is ignored if the StartDate parameter is set. 8
StartDate Date format: MM/DD/YYYY. Specifies the date on which to begin the report. N/A
EndDate Date format: MM/DD/YYYY. Specifies the date on which to stop the report. current date
Predictions Numeric value. Specifies the number of days, weeks, or months over which to predict information. 0
MediaType Text only. Specifies the type of media on which to collect information. Options include the following:
  • Disk
  • Tape
Disk and Tape
CopyType Text only. Specifies the type of copy on which to collect information. Options include the following:
  • Backup
  • Replication
Backup and Replication
LibraryName Text only. Specifies the name of the library for which information is included in the report. The report displays all storage policy copies that use the specified library. N/A
PolicyName Text only. Specifies the name of the storage policy that is included in the report. The report displays all copies for the specified storage policy. N/A
CopyName Text only. Specifies the storage policy copy that is included in the report. The report displays information for only the specified storage policy copy. N/A
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Data Growth Summary and Prediction Report

The Data Growth Summary and Prediction Report predicts the number of days that each library can be used, based on the amount of data growth over the specified time period and the current amount of free space for each library.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see a summary of data growth that happened for storage libraries on the CommServe over 3 months, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Data Growth Summary Report include the following:

Parameter Description Default Setting
Frequency Text only. Specifies the unit of time over which to gather information. Options include the following:
  • Day
  • Week
  • Month
Week
Periods Numeric value. Specifies the number days, weeks, or months over which to gather information. This parameter is ignored if the StartDate parameter is set. 8
StartDate Date format: MM/DD/YYYY. Specifies the date on which to begin the report. N/A
EndDate Date format: MM/DD/YYYY. Specifies the date on which to stop the report. current date
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Largest Client Data On Media Report

The Largest Client Data on Media Report identifies the clients with the largest amount of data on media for a CommCell. Aged jobs can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the top 15 clients with the largest amount of data on media for the CommServe, including data from aged jobs, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Largest Client Data on Media Report include the following:

Parameter Description Default Setting
TopN Numeric value. Specifies the maximum number of clients to include in the report information. 10
CountAgedJobs This switch includes or excludes aged jobs. Options include the following:
  • Include: 1
  • Exclude: 0
0
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Deduplication Database Size and Growth Report

The Deduplication Database Size and Growth Report displays the current amount of space and data growth size on disk for the deduplication database associated with the specified storage policy, and predicts the amount of data growth on disk over the specified period of time.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

To see the growth of data on disk for the deduplication database that is associated with storagepolicy1 over the last six months and predict the amount of data growth on disk over the next four months, run the following command:

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Deduplication Database Size and Growth Report include the following:

Parameter Description Default Setting
Frequency Text only. Specifies the unit of time over which to gather information. Options include the following:
  • Day
  • Week
  • Month
Week
Periods Numeric value. Specifies the number days, weeks, or months over which to gather information. This parameter is ignored if the StartDate parameter is set. 8
StartDate Date format: MM/DD/YYYY. Specifies the date on which to begin the report. N/A
EndDate Date format: MM/DD/YYYY. Specifies the date on which to stop the report. current date
Predictions Numeric value. Specifies the number of days, weeks, or months over which to predict information. 0
PolicyName Specifies the name of the storage policy that is included in the report. The report displays all copies for the specified storage policy. N/A
CopyName Specifies the storage policy copy that is included in the report. The report displays information for only the specified storage policy copy. N/A
format Text only. Specifies the file format in which the report saves. Options include the following:
  • CSV
N/A
file Text only. Specifies the location and name of the saved report. N/A

Jobs in Storage Policy Copies

The Jobs in Storage Policy Copies report displays all jobs that ran for the specified storage policy and the specified storage policy copy.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The report is saved to the location that you specified.

Example

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

Parameters

The report script includes several parameters that you can set, according to your needs. Parameters for the Jobs in Storage Policy Copies report include the following:

Parameter Description Default Setting
i_fromTime Date format: MM/DD/YYYY. Specifies the date on which to begin the report. All
i_toTime Date format: MM/DD/YYYY. Specifies the date on which to stop the report. All
i_isAged Numeric value. Indicates whether to include aged jobs. Options include the following:
  • Do not include aged jobs: 0
  • Include only aged jobs: 1
  • Include aged jobs: 2
0
i_backupType Text only. Specifies the types of backups that appear in the report information. Options include the following:
  • Full
  • Incr (Incremental)
  • If not specified, all backup types appear in the report
All
i_orderBy Text only. Specifies the type of information that determines the order of the rows. Options include the following:
  • JobID
  • Client
  • Agent
JobID
i_policyName Specifies the name of the storage policy that is included in the report. The report displays all copies for the specified storage policy. All storage policies on the CommCell computer.
i_copyName Specifies the storage policy copy that appears in the report. The report displays information for only the specified storage policy copy. If you specify the copyName parameter, you must also specify the policyName parameter. All storage policy copies for the specified storage policy.
i_retention Numeric value. Indicates the types of retention jobs that appear in the report. Options include the following:
  • All jobs: 0
  • Include only basic retention jobs: 1
  • Include only extended retention jobs: 2
  • Include only manually pinned jobs: 4
0

Reassociate Report Schedules

The Reassociate Report Schedules script transfers the control of report schedules from a deleted user to a new user.

Running the Script

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    The control of report schedules is transferred to the specified user.

Example

Frequently Asked Questions (FAQ)

What Types of Jobs Count as Failed in the Consecutive Job Failure Report?

The types of jobs that count as failed (strikes) include the following:

  • Failed jobs. The reason for the job's failure is included in the report output.
  • Killed jobs.
  • Partially completed backup jobs for NAS, DB, and Exchange.
  • Jobs with a "No Run" status. No Run status is applied to jobs that were assigned a Job ID, but could not run because another job was running at the same time.

What is Excluded from the Consecutive Job Failure Report?

The following are excluded from the Consecutive Job Failure Report:

  • Subclients with backup disabled.
  • By default, Synthetic Full backup jobs. However, you can set the report to include Synthetic Full backup jobs when you set the countSynthFull parameter to 1.

How Are Failed Backups Calculated in the Consecutive Job Failure Report?

The backup window spans a 24-hour period. The report begins at the time that you specify on the previous day and ends at the same time today. The number of backup failures is counted according to the number of days since the first job failure that occurred after the last completed job.