 |
 |
Add SQL Instance dialog
The Add SQL Instance dialog appears when Add | Subsystem | SQL or Add With Events | Subsystem | SQL is selected on the What search properties tab (Searches page or the Purge Options page in the Purge Job wizard). This dialog allows you to search for actions that have occurred in all SQL instances being audited or a selected SQL instance, database and/or object.
From this dialog, specify a SQL instance, database or object and click the Add button to add it to the list box located across the bottom of the dialog. Once you have made your selection(s), click the OK button to save your selection and close the dialog. If you selected the All SQL Instances option, simply click the OK button to save your selection and close the dialog.
The following information/controls are included on this dialog:
Select one of the following options to define the scope of the search:
When the This Object option is selected in the Scope section, the following controls will become available to specify the SQL instance, SQL database and/or SQL Server object to be included in the search definition. When you select This Object, you MUST fill in at least one of the following fields. After specifying the SQL instance, database and/or object to be included, click the Add button to add it to the SQL list box.
Enter the name of the SQL instance or click the browse button to the far right to select from a list. Clicking 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 SQL instances.
Enter the name of the SQL database to be used or click the browse button to the far right to select from a list. Clicking 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 SQL databases.
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 SQL Server objects.
The SQL Instance list box located at the bottom of the dialog displays a list of all the SQL instances, databases and/or objects included in the search definition (or excluded when the Exclude the Above Selection(s) check box is checked). Its contents are based on the entries specified above, when using the This Object scope.
Use the buttons above this list box to add, remove and update entries:
A data grid is added to this dialog when the Add With Events tool bar option is selected. This data grid displays a list of the SQL instances, databases and objects that have an event in the Change Auditor database. The following information is displayed:
Select an entry in the data grid and click the Add button to add it to the SQL list box.
Exclude the Above Selection(s)
Select the Runtime Prompt option to prompt for the SQL instance whenever the search is run. That is, when the Run tool bar button is used, the Add SQL Instance dialog appears allowing you to select the SQL instance to be included in the search.
| |
|
Add SQL Data Level Object
The Add SQL Data Level Object dialog appears when Add | Subsystem | SQL Data Level or is selected on the What search properties tab (Searches page or the Purge Options page in the Purge Job wizard). This dialog allows you to search for specific database objects.
From this dialog, specify an application, database, table, or transaction ID and click the Add button to add it to the list box located across the bottom of the dialog. Once you have made your selections, click OK to save your selection and close the dialog.
The following information/controls are included on this dialog:
| |
|
Add Users, Computers or Groups dialog
The Add Users, Computers or Groups dialog appears when you click Add With Events on the Who search properties tab (Searches page or the Purge Options page in the Purge Job wizard). This dialog contains a list of all the users, computers and groups that have an event associated with it in the Change Auditor database.
To select an item from this list, select one or more items from the data grid located at the top of the dialog and click the Add button to add the item(s) to the selection list, located at the bottom of the dialog. Once you have selected all of the items to be included in your search, click the OK button to save your selections and close the dialog.
The following information is displayed on this dialog:
Click this button to display the Add Who dialog where you can enter a wildcard expression to be used to search for a user (Domain\User Name) or group (Domain\Group Name).
By default, the wildcard expression will be used to search for a user. To search for a group, select the Group option.
| |
|
Add Where dialog
The Add Where dialog appears when the Add | Add Wildcard Expression command is clicked on the Where search properties tab (Searches page or the Purge Options page in the Purge Job wizard). This dialog also appears when the Add Wildcard Expression button is used on the Add Agents, Domains, Sites dialog.
From this dialog specify a wildcard expression to be used to search for an agent, domain or site, then click OK to save your selection and close the dialog.
In the left-hand field, use the drop-down control to select the comparison operator to be used:
Use the * wildcard character to match any string of zero or more characters. For example, entering LIKE *local will find all agents that end in 'local'.
This option is selected by default and the search will be conducted on the agent's NetBIOS name.
Select this option to conduct the search on the domain name.
