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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_BackupStrikes -si @BackupWindowFrom = '<time at which count begins>' -si @countSynthFull = '<include or exclude Synthetic Full backup jobs>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_BackupStrikes -si @BackupWindowFrom = '20:00' -si @countSynthFull = '1' -format 'csv' –file 'C:\Reports\sample.csv'

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_StrikeRecovery -si @BackupWindowFrom = '<time at which count begins>' -si @countSynthFull = '<include or exclude Synthetic Full backup jobs>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_StrikeRecovery -si @BackupWindowFrom = '20:00' -si @countSynthFull = '1' -format 'csv' –file 'C:\Reports\sample.csv'

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LongRunJobs -si @LastDays='<number of days>' -si @LongRunHours='<number of hours>' -si @TopN='<number of jobs>' –si @BackupType= '<type of backup jobs>' –si @ActiveJobsOnly=’<include or exclude active jobs>’ –si @CountAgedJobs=’<include or excluded aged jobs>’ -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_LongRunJobs -si @LastDays='31' -si @LongRunHours='12' -si @TopN='20' –si @BackupType=’Full’ –si @ActiveJobsOnly=’0’ –si @CountAgedJobs=’0’ -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LongRunJobs -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LargestClients -si @LastDays='<number of days>' -si @TopN='<number of jobs>' –si @CountAgedJobs=’<include or excluded aged jobs>’ -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_LargestClients -si @LastDays='31' -si @TopN='20' –si @CountAgedJobs=’0’ -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LargestClients -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript –sn QS_SlowestClients –si @LastDays=’<number of days>’ –si @TopN=’<number of jobs>’ –si @BackupType=’<type of backup jobs>’ –si @CountAgedJobs=’<include or exclude aged jobs>’ -format 'csv' –file '<output location and filename>'

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.

qoperation execscript –sn QS_SlowestClients –si @LastDays=’31’ –si @TopN=’100’ –si @BackupType=’Full’ –si @CountAgedJobs=’0’ -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LeastDedupedJobs -si @LastDays = '<number of days>' -si @TopN = '<number of jobs>' -si @LowDedupePct = '<percentage of deduplication>' -si @BackupType = '<type of backup jobs>' -si @CountAgedJobs = '<include or exclude aged jobs>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_LeastDedupedJobs -si @LastDays = '1' -si @TopN = '10' -si @LowDedupePct = '40' -si @BackupType = 'Full' -si @CountAgedJobs = '1' -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript –sn QS_LeastDedupedJobs -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_BackendSubclientStorage -si @Frequency='<the frequency with which jobs run>' -si @NumberOfPoints='<number of days, weeks, months, or years>' -si @PredictionPoints='<number of days, weeks, months or years over which to predict>' -si @CostPerGB='<cost of 1 GB of data>' -si @AddlCostPerGB='<additional cost per 1 GB of data>' -si @ClientGroupName='<name of client group>' -si @BackupFrom='<time at which report begins>' -si @IncludeCurrentPeriod='<include or exclude the current period>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_BackendSubclientStorage -si @Frequency='Daily' -si @NumberOfPoints='4' -si @PredictionPoints='4' -si @CostPerGB='1' -si @AddlCostPerGB='2' -si @ClientGroupName='ccg_window' -si @BackupFrom='16:00' -si @IncludeCurrentPeriod='1' -format 'csv' –file 'C:\Reports\sample.csv'

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_FrontendCapacityUsage -si @Frequency='<the frequency with which jobs run>' -si @NumberOfPoints='<number of days, weeks, months, or years>' -si @PredictionPoints='<number of days, weeks, months or years over which to predict>' -si @CostPerGB='<cost of 1 GB of data>' -si @AddlCostPerGB='<additional cost per 1 GB of data>' -si @IncludeCurrentPeriod='<include or exclude the current period>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_FrontendCapacityUsage -si @Frequency = 'Weekly' -si @NumberOfPoints ='4' -si @PredictionPoints='2' -format .csv –file 'C:\Reports\sample.csv'

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_WeeklyBackupSummary -si @StartDate='<date on which to start the report>' -si @DedupOnly='<include only or exclude all deduplication backup jobs>' –si @CountAgedJobs=’<include or exclude aged jobs>’ -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_WeeklyBackupSummary -si @StartDate='2012-06-20' -si @DedupOnly='0' –si @CountAgedJobs=’0’ -format csv –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_WeeklyBackupSummary -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_ExecuteView -si @ViewName='<CommCell view type>' -format .csv –file '<output location and filename>'

The report is saved to the location that you specified.

Example

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

qoperation execscript -sn QS_ExecuteView -si @ViewName='CommCellClientVersion'-format .csv –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_ExecuteView -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_DataGrowthPerCopy -si @Frequency = '<unit of time over which to gather information>' -si @Periods='<number of days, weeks, or months>' –si @StartDate=’<date on which to begin the report>’ –si @EndDate=’<date on which to end the report>’ –si @Predictions=’<number of days, weeks, or months over which to predict data>’ -si @MediaType = '<disk, tape, or both>' -si @CopyType = '<backup, replication, or both>' -si @LibraryName = '<name of storage library>' -si @PolicyName = '<name of storage policy>' -si @CopyName = '<name of storage policy copy>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_DataGrowthPerCopy -si @Frequency = 'month' -si @Periods='3' –si @Predictions= '5' -si @MediaType = 'disk' -si @CopyType = 'backup' -si @PolicyName = 'Main Storage Policy' -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_DataGrowthPerCopy -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_DataGrowthSummary -si @Frequency = '<unit of time over which to gather information>' -si @Periods='<number of days, weeks, or months>' –si @StartDate=’<date on which to begin the report>’ –si @EndDate=’<date on which to end the report>’ -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_DataGrowthSummary -si @Frequency = 'Month' -si @Periods='3' -si @StartDate='04012012' -si @EndDate='07012012' -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_DataGrowthSummary -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LargestClientDataOnMedia -si @TopN= '<number of clients>' -si @CountAgedJobs='<include or exclude data from aged jobs>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_LargestClientDataOnMedia -si @TopN= '15' -si @CountAgedJobs='1' -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_LargestClientDataOnMedia -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_DDBGrowthPerCopy -si @Frequency='<the frequency with which jobs run>' -si @Periods='<number of days, weeks, or months>' @StartDate=’<date on which to begin the report>’ –si @EndDate=’<date on which to end the report>’ –si @Predictions=’<number of days, weeks, or months over which to predict data>’ -si @PolicyName = '<name of storage policy>' -si @CopyName = '<name of storage policy copy>' -format 'csv' –file '<output location and filename>'

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:

qoperation execscript -sn QS_DDBGrowthPerCopy -si @Frequency='Month' -si @Periods='6' @StartDate=’’ –si @EndDate=’’ –si @Predictions=’4’ -si @PolicyName = 'storagepolicy1' -si @CopyName = '' -format 'csv' –file 'C:\Reports\sample.csv'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_DDBGrowthPerCopy -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_JobsinSPCopy -si @i_fromTime='<start time for the report in the format yyyy/mm/dd>' -si @i_toTime='<end time for the report in the format yyyy/mm/dd>' -si @i_isAged='<include or exclude aged jobs>' -si @i_backupType='<include full, incremental, or both backup types>' -si @i_orderBy='<how to arrange report information>' -si @i_policyName='<name of the storage policy>' -si @i_copyName='<name of the storage policy copy>' -si @i_retention='<include jobs based on the type of retention policy>'

The report is saved to the location that you specified.

Example

qoperation execscript -sn QS_JobsinSPCopy -si @i_fromTime='2013/09/01' -si @i_toTime='2013/10/15' -si @i_isAged='0' -si @i_backupType='Full' -si @i_orderBy='JobID' -si @i_policyName='Stor_Pol_1' -si @i_copyName='Stor_Pol_Copy_1' -si @i_retention='0'

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

Usage and Help

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn QS_JobsinSPCopy -help

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

Open the command prompt and navigate to the <software installation path>\Base> folder.
Enter qlogin, and then enter your user name and password.
Run the following command:
qoperation execscript -sn reassociateReportSchedules -si "<new user name>"

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

Example

qoperation execscript -sn reassociateReportSchedules -si "jdoe"

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.