piyushm
September 8 2009, 10:27 PM
Traverse supports tests that will execute a SQL query or a stored procedure.
The query or stored procedure must return an integer value that is considered the 'test result'. Traverse then compares this result against the thresholds for the test to determine the test status.
You set one up by creating a 'sql_value' test. Log on to the Traverse Web application (with privileges such that the user is able to provision new tests). Navigate to Administration --> Devices --> click on the Tests link (at the right) for the SQL device where you want to run a query (or stored procedure).
This will bring up the 'Manage Tests' page. Click on 'Create New Standard Tests', pick the third radio button 'Create new tests manually', check the box next to sql_value. Make sure all other boxes are unchecked. Click the 'Add Tests' button.
At the following page, 'Create New Tests: Step 2 - Filter Tests To Create', pick from the available tests. For the purpose of this example, pick 'SQL Query Result (MYSQL DB)' so that it is the only one highlighted. (The query in my example is being performed against a MySQL database). Click 'Continue'.
You will be presented the 'Create New Tests: Step 3 - Configure test parameters' where you enter pertinent information for Traverse to be able to execute the query (or stored procedure). Provide a test name, interval and the test thresholds. Ensure that the check box before the test name is checked.
Fill out the SQL specific information. For the field Query: - specify a SQL query or specify a stored procedure.
A SQL query may be specified as in:
select count(*) from db;
A SQL Stored Procedure must use the @ prefix - as in:
@CALL TESTSP()
NOTE: Currently, when specifying a stored procedure, do not include a trailing semi-colon.
Once the fields have been filled to your satisfaction, you may provision the test by clicking the 'Provision Selected Tests' button.
To view results, please navigate to Status --> Devices --> click the device in question and you should see the test that you just provisioned. It may be a few minutes before the test executes and data is collected.
You are welcome to post your experiences and questions here.
The query or stored procedure must return an integer value that is considered the 'test result'. Traverse then compares this result against the thresholds for the test to determine the test status.
You set one up by creating a 'sql_value' test. Log on to the Traverse Web application (with privileges such that the user is able to provision new tests). Navigate to Administration --> Devices --> click on the Tests link (at the right) for the SQL device where you want to run a query (or stored procedure).
This will bring up the 'Manage Tests' page. Click on 'Create New Standard Tests', pick the third radio button 'Create new tests manually', check the box next to sql_value. Make sure all other boxes are unchecked. Click the 'Add Tests' button.
At the following page, 'Create New Tests: Step 2 - Filter Tests To Create', pick from the available tests. For the purpose of this example, pick 'SQL Query Result (MYSQL DB)' so that it is the only one highlighted. (The query in my example is being performed against a MySQL database). Click 'Continue'.
You will be presented the 'Create New Tests: Step 3 - Configure test parameters' where you enter pertinent information for Traverse to be able to execute the query (or stored procedure). Provide a test name, interval and the test thresholds. Ensure that the check box before the test name is checked.
Fill out the SQL specific information. For the field Query: - specify a SQL query or specify a stored procedure.
A SQL query may be specified as in:
select count(*) from db;
A SQL Stored Procedure must use the @ prefix - as in:
@CALL TESTSP()
NOTE: Currently, when specifying a stored procedure, do not include a trailing semi-colon.
Once the fields have been filled to your satisfaction, you may provision the test by clicking the 'Provision Selected Tests' button.
To view results, please navigate to Status --> Devices --> click the device in question and you should see the test that you just provisioned. It may be a few minutes before the test executes and data is collected.
You are welcome to post your experiences and questions here.