Description
Executes a SQL View
Usage
qoperation execscript -sn QS_ExecuteView [ViewName] [SelectClause] [WhereClause] [Top] [GroupBy] [OrderBy]
Example:
qoperation execscript -sn QS_ExecuteView -si @ViewName = 'CommCellClientVersion'
qoperation execscript -sn QS_ExecuteView -si @ViewName = 'CommCellClientVersion' -si @SelectClause='Name, MAX(Version) as MaxVersion' -si @WhereClause = 'Name LIKE ''%cv%''' -si @Top = '100' -si @GroupBy ='Name' -si @OrderBy ='Name'
In case of Unix, don't include @ViewName, @SelectClause, just specificy the values in the right order. Use double quotes for parameter values.
qoperation execscript -sn QS_ExecuteView -si "CommCellClientVersion" -si "Name" -si "Name='testclient'" -si -si -si "Name DESC"
Input Parameters: Except ViewName all are optional
-- ViewName - Name of the View.
-- SelectClause - Optional. Comma separated list of Columns and also any aggregate functions like MAX etc.
-- WhereClause - Optional. SQL Where clause condition.
-- Top - Optional. Top N rows to be returned from the result set.
-- GroupBy - Optional. Comma separated list of Columns.
-- OrderBy - Optional. Comma separated list of Columns, Sorts the result set by given columns.
Details
- Platform: CommServe (Database: CommServ)
- Release: 11.0.0
Disclaimer of Warranties
CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.