Loading...

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:

    qoperation execscript -sn QS_Executqoperation execscript -sn QS_ExecuteView -si @ViewName = 'CommCellViewName' -file 'OutputLocationAndFileName'

    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_Executqoperation execscript -sn QS_ExecuteView -si @ViewName = 'CommCellClientVersion' -file 'c:\export.csv'

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_Executqoperation 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

Last modified: 8/26/2020 7:33:38 PM