ADO - User Experience Wizard

The following example illustrates the configuration process for creating an ADO – User Experience monitor to monitor the Microsoft SQL Server database type.

Properly-installed OLE DB providers can be selected for monitor configuration. OLE DB providers that are not installed on the ipMonitor host machine are displayed under Unavailable Database Types. Contact your vendor to obtain the correct OLE DB provider for your database type and install it before you continue.

  1. Log in to ipMonitor as an administrator.
  2. Click Configuration in the toolbar.
  3. Click Add/Edit a Device or Monitor.
  4. Locate and select a device to monitor.
  5. Click Add > Add New Monitor.
  6. Click Database Experience.
  7. In the Step 1: Select Database Type screen, select an available database type from the list, and then click Next.

    Select the Other database type to manually configure the ADO - User Experience monitor to test other data sources such as SAP DB, FrontBase, FoxPro, and LDAP.

  8. In the Step 2: Data Source Location screen, enter the IP address of the SQL server you want to monitor.
  9. Select any additional options, and then click Next.

    Option Description
    Use TCP/IP instead of Named Pipes

    Forces ipMonitor to use TCP/IP instead of a named pipe to connect to a Microsoft SQL Server database. Enter the IP address and port of the server database in the Server Address field.

    For example, xxx.xxx.xxx.xxx,1433 where 1433 is the default port number for SQL Servers.

    Use Data Encryption Forces ipMonitor to encrypt the data transmitted between the ipMonitor host machine and the database you are querying.
    Specify a Microsoft SQL Server instance Connects to a named SQL Server instance. Enter the instance name in the Server Address field.
  10. In the Step 3: Assign login credential screen, select a credential to use while monitoring, and then click Next.

    Depending on the data source configured for the ADO monitor, some form of authentication to the data source will be required to connect and log in.

  11. In the Step 4: Select Database screen, select the database you will use in the monitor, and then click Next.

    Depending on the database type, this step may not be displayed.

  12. In the Step 5: Select Database table screen, select the database table to be used in the monitor.
  13. Select any additional options, and then click Next.

    Option Description
    Show only User Tables Displays only user-created tables in the Tables list.
    Show both User and System Tables Displays both user-created tables and system tables in the Tables list.
  14. In the Step 6: Generate SQL Query screen, enter or select an SQL query statement.

    ipMonitor uses an SQL statement to query the database. You can supply your own SQL statement or have ipMonitor generate an SQL statement automatically based on your selected table columns.

  15. Select any additional options, and then click Next.

    Option Description
    Automatically generate an SQL statement from selected columns

    Lists the columns in the database table. The list displays the data type and length of each column, and whether the column is allowed to contain a null value.

    Select the check boxes next to the columns you want to include in the automatically- generated SQL statement.

    Manually supply an SQL Statement Enter your own SQL statement in a text box.
  16. In the Step 7: Analysis of results screen, enter your test parameters.

    ipMonitor matches the results of the SQL query to the test parameters that you set up to determine whether the monitor should pass or fail.

  17. Select any additional options, and then click Next.

    Option Description
    Maximum Rows to Retrieve Represents the maximum number of rows that the query will be permitted to return to the ADO - User Experience monitor for analysis. The default value is set to 300.
    Examine the number of Retrieved Rows based on a numeric equation

    When selected, select an operator and number that will be used to test the number of rows returned by the query. Supported numeric tests include:

    Pass if the number of rows is:
    • <: less than X
    • >: greater than X
    • <=: less than or equal to X
    • >=: greater than or equal to X
    • ==: equal to X
    • !=: not equal to X
    Examine Row Content to perform textual or numeric analysis

    Performs textual or numeric analysis on the data contained in the specified column.

    If the query result set returns more than one row, each row in the result set is examined sequentially from the first to last. All configured tests are performed on the column you select.

    The test passes if any condition you select is met.

    Examine Column When you select the column to examine, note that column 1 is the first column. Counting is 1-based, not 0-based. The data in the selected column can be a string or a number.
    Column Will

    Determines whether numeric and text comparison methods are available, including regular expression and string matches. The comparison passes if the content of the column adheres to any method listed below.

    • RegEx match: Enter a regular expression to match.
    • RegEx non-match: Enter a regular expression not to match.
    • Substring search: Search for a case-sensitive substring
    • == : Exact match
    • != : Non-match
    Preview

    Displays the data contained within the selected columns. Rows highlighted in red indicate a fail scenario.

    Clicking Stretch Table in the preview window expands the table to fit the selected content.

    If you chose to view a large number of columns, some content may be truncated unless you expand the resulting preview table.

  18. In the Step 8: Name Monitor screen, enter a descriptive name for the new monitor.
  19. Select any additional options.

    Option Description
    Creative Monitor Enabled After the monitor is created, it begins querying the database with the selected configuration options. This option is enabled by default.
    Store Monitor Statistics for Recent Activity and Historical Reports ipMonitor begins to record test results, which are used to generate recent activity and historical reports. This option is disabled by default.
    Create Exits the wizard and access the new monitor in edit mode. You can make any final modifications to the monitor in this mode, including setting Timing and Notification parameters.
  20. Complete the wizard.