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_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
- 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_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:
|
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