Use this dialog to configure a new dynamic group, or to make changes to an existing one. These groups can be used as your primary view of your devices, or simply quick-reference views that group your devices into meaningful sections.

To create dynamic groups:

  1. In the WhatsUp Gold console, right-click on the Device View, then select New Dynamic Group. The Dynamic Group dialog appears.

    - or -

    From the WhatsUp Gold console menu, select File > New > New Dynamic Group. The Dynamic Group dialog appears.

  2. Enter the appropriate information into the following fields:
    • Group name. Enter a name for the dynamic group. This name appears on the device list.
    • Description. (Optional) Enter additional information about the dynamic group.
    • SQL Filter. Enter the SQL query statement that retrieves the list you want from the database. For the dynamic group to appear in your device list, the first line must be 'SELECT DISTINCT nDeviceID'.
  3. Click OK to add the group to the device list.

For the dynamic group to appear in your device list, the first line must be 'SELECT DISTINCT nDeviceID'.

If you do not know how to formulate SQL queries, you can cut and paste filter entries from existing dynamic groups, then edit them to read data from other tables. We have also provided several sample queries for you to create some very interesting dynamic groups.

Note: You can learn more about the database structure by downloading the database schema file on the WhatsUp Gold support page.