From the SQL Collector window, you can search for SQL statements in Collectors that have specific text in the SQL text, the query plan, and/or a certain SQL classification.
To open the Find Collectors window
Select Collector | Find Collector.
The Find Collector window has two tabs to specify what text to search for. If you select multiple items, the search is combined as an AND search so that it searches for SQL statements that include all the selected items. After you have selected the search criteria, click Find to search for the SQL statements which contains all search criteria.
Check the SQL Classification type defined for the Collector.
The search results are displayed at the bottom of the Find Collectors window. It displays the Collector name and the SQL name for the SQL statements which contain the search criteria.
The Find SQL function is available in the SQL Collector window. It locates the SQL statements that contain a specified word for a particular Collector taking into account the View criteria.
To find a text string
Select SQL | Find SQL.
Enter the text you want to search for.
To continue searching for the same text string
Select SQL | Find Next SQL [Ctrl + F3].
You can generate a report with the SQL statements in the SQL Collector window. The contents of the report depend on the components you select.
To generate a report
Select Report | Monitored SQL to open the Monitored SQL Report Criteria window.
Select the components for the report.
Select All SQL or Select SQL and enter the specific SQL statement numbers.
Click OK to generate the report.
The information in the report can be Saved and Printed.
Note: A few minutes may be needed to generate a long report.
The Collector Properties window displays the name, description, creation date, file size and location, status, program version number, number of SQL monitored.
To view the properties of a Collector
Right-click and select Properties.