Kovair DevOps and CustomCommand Integration Plugin

CustomCommand Plugin Details

Overview

CustomCommand Information:

Version Supported:

Plugin Operation:

1. ExecuteCMDCommand / ExecuteInPowershell / ExecuteShellCommand
This operation allows to execute custom commands;.
Input parameter(s):

Parameter	Is Mandatory	Help Text
Command	true	Put the command to execute Note: Must have administrator access

Output Parameter(s):

Parameter	Help Text
CommandOutput	Output of the command.
CommandStatus	Final command job status.

Pass/Fail Condition:

Status	Required string in outputlog
Passed	If the output log is empty or does not contains any string mentioned in failed section.
Failed	If the output log is not empty and contains any of the following: 1) ‘is not recognized as an internal or external command’ 2) ‘ERROR’ 3) ‘FullyQualifiedErrorId’ 4) ‘command not found’ 5) ‘No such file or directory’

2. ExecuteSQLCommand
This operation allows to execute SQL commands;.
Input parameter(s):

Parameter	Is Mandatory	Help Text
Server Name	true	give the server name
Authentication	true	metion the authentication type WINDOWS/SQL
User Name	false	If windows type authentication, no need to provide this field value
Password	false	If windows type authentication, no need to provide this field value
DB Name	true	DB to be connected
Execution File Path	false	Mention the full path of the file to be executed.Ex: C:\Scripts\Script1.sql
Execution Command	false	Split the multiple command with ‘;’ to be executed. Ex: Select * from tusers

Output Parameter(s):

Parameter	Help Text
CommandOutput	Output of the command
CommandStatus	Final command job status.

Pass/Fail Condition:

Status	Required string in outputlog
Passed	If the output log is empty or does not contains any string mentioned in failed section.
Failed	If the output log is not empty and contains any of the following: 1) ‘Cannot open database’ 2) ‘Login failed for user’ 3) ‘Server is not found or not accessible’ 4) ‘Invalid object name’ 5) ‘Could not find stored procedure’ 6) ‘Incorrect syntax near’ 7) ‘syntax error’ 8) ‘Invalid column’ 9) ‘Invalid filename’ 10) ‘Could not find’ 11) ‘Invalid column’

3. ExecuteMariaDBCommand
This operation allows to execute MariaDB commands;.
Input parameter(s):

Parameter	Is Mandatory	Help Text
Server Name	true	give the server name
User Name	true	Provide user name to log into MariaDB server
Password	true	Provide password to log into MariaDB server
DB Name	true	DB to be connected
Execution File Path	false	Mention the full path of the file to be executed.Ex: C:\Scripts\Script1.sql
Execution Command	false	Split the multiple command with ‘;’ to be executed. Ex: Select * from tusers

Output Parameter(s):

Parameter	Help Text
CommandOutput	Output of the command
CommandStatus	Final command job status.

Pass/Fail Condition:

Status	Required string in outputlog
Passed	Output of the command
Failed	If the output log is not empty and contains any of the following: 1) ‘Cannot open database’ 2) ‘Unknown database’ 3) ‘Login failed for user’ 4) ‘Access denied for user’ 5) ‘Server is not found or not accessible’ 6) ‘Unknown MYSQL server host’ 7) ‘Invalid object name’ 8) ‘Could not find stored procedure’ 9) ‘Incorrect syntax near’ 10) ‘syntax error’ 11) ‘Invalid column’ 12) ‘Invalid filename’ 13) ‘Could not find’ 14) ‘mysql.exe is not recognized as an internal or external command’ 15) ‘The system cannot find the file specified’

4. ExecuteOracleDBCommand
This operation allows to execute Oracle DB commands;.
Input parameter(s):

Parameter	IsMandatory	Help Text
Server Name	true	give the server name
Port	true	give the port number
User Name	true	Provide user name to log into Oracle DB server
Password	true	Provide password to log into Oracle DB server
DB Name	true	Database SID
Execution File Path	false	Mention the full path of the file to be executed..Every statement must end with a semi-colon (;).Ex: C:\Scripts\Script1.sql
Execution Command	false	Only a single command to be executed.Statement must end with a semi-colon (;) For multple commands, put the command in .sql and use the ‘Execution File Path’ parameter.. Ex: Select * from tusers;

Output parameter(s):

Parameter	Help Text
CommandOutput	Output of the command
CommandStatus	Final command job status.

Pass/Fail Condition:

Status	Required string in outputlog
Passed	Output of the command
Failed	If the output log is not empty and contains any of the following: 1) ‘Cannot open database’ 2) ‘The listener does not currently know of SID given in context’ 3) ‘invalid username/password’ 4) ‘command not properly ended’ 5) ‘no such protocol adapter’ 6) ‘Access denied for user’ 7) ‘Server is not found or not accessible’ 8) ‘Connect failed because target host or object does not exist’ 9) ‘Invalid object name’ 10) ‘Could not find stored procedure’ 11) ‘Incorrect syntax near’ 12) ‘syntax error’ 13) ‘Invalid column’ 14) ‘Invalid filename’ 15) ‘table or view does not exist’ 16) ‘invalid identifier’ 17) ‘sqlplus is not recognized as an internal or external command’ 18) ‘doesn’t exist’ 19) ‘The system cannot find the file specified’

Disclaimers:

Release Details:

Contact us: