Loading...

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:

    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

Last modified: 8/16/2018 6:50:42 PM