The following scenarios explain how to use the What tab to create custom SQL searches.
NOTE: Selecting the Private folder will create a search that only you can run and view, whereas selecting the Shared folder will create a search which can be run and viewed by all Change Auditor users. |
2 |
3 |
Click New to enable the Search Properties tabs across the bottom of the Searches page. |
5 |
6 |
On the Add SQL Instance dialog, select All SQL Instances. |
7 |
Click OK to save your selection and close the dialog. |
2 |
3 |
Click New to enable the Search Properties tabs across the bottom of the Searches page. |
5 |
6 |
On the Add SQL Instance dialog, select This Object. |
7 |
When the This Object option is selected, you must fill in at least one of the following fields to define the SQL objects to include in the search: |
• |
Instance - Enter the name of the SQL instance or click the browse button to the far right to select from a list. Selecting the browse button will display the Select a SQL Instance and Database dialog which provides a list of SQL instances and associated databases from which you can select the instance and database to be used. If you leave this field blank, Change Auditor will search for SQL events based on the entries made in the DB and/or Object fields for all audited SQL instances. |
• |
DB - Enter the name of the SQL database to be used or use the browse button to the far right to select from a list. Selecting the browse button will display the Select a SQL Instance and Database dialog which provides a list of SQL instances and associated databases from which you can select the instance and database to be used. If you leave this field blank, Change Auditor will search for SQL events based on the entries made in the Instance and/or Object fields for all audited SQL databases. |
• |
Object - Enter a SQL Server object to be included in the search definition. If you leave this field blank, Change Auditor will search for SQL events based on the entries made in the Instance and/or DB fields for all audited SQL Server objects. |
NOTE: Select the Exclude the Above Selection(s) check box if you want to search for changes to all SQL instances EXCEPT those listed in the ‘what’ list. |
NOTE: Select the Runtime Prompt check box on this dialog to prompt for a SQL instance every time the search is run. |
8 |
Once you have selected the SQL instance, database and/or object to be included in the search, click OK to save your selection and close the dialog. |
2 |
3 |
Click New to enable the Search Properties tabs across the bottom of the Searches page. |
5 |
6 |
On the Add SQL Instance dialog, select an instance from the list and click the Add button to add it to the selection list at the bottom of the page. |
7 |
Click OK to save your selection and close the dialog. |
The following scenarios explain how to use the What tab to create custom SQL Data Level searches.
2 |
3 |
Click New to activate the Search Properties tabs across the bottom of the Searches page. |
5 |
NOTE: Select the Exclude the Above Selection(s) check box if you want to search for changes to all SQL Data Level events EXCEPT those that match the specified criteria. |
7 |
Click OK to save your selection and close the dialog. |
2 |
3 |
Click New to activate the Search Properties tabs across the bottom of the Searches page. |
5 |
6 |
Once you have specified the facility or event class, click Add to add it to the Selection list at the bottom of the dialog. |
NOTE: Select the Exclude the Above Selection(s) check box if you want to search for changes to all SQL Extended Events events EXCEPT those that match the specified criteria. |
7 |
Click OK to save your selection and close the dialog. |
Performance Statistics - Queries in Ad Hoc Statement Compiled |
|
Performance Statistics - Queries in Stored Procedure Compiled |
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center