Dynamic Group Properties: Advanced SQL

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.

Note: Dynamic groups in the web interface: Dynamic groups do not follow group access rights. Anyone with the ability to view the device group that a dynamic group is in can access that dynamic group. However, only devices the user has the ability to view appear in the group.

Validating your filter code

Keep in mind that as you configure your rules, the SQL filter is displayed at the bottom of the Builder dialog. When you are satisfied with the filter code that is displayed, click the Validate button to test the filter. If it runs as you expect, click OK to save the configured SQL filter and to add the new Dynamic Group to your Device List. If the code does not run as you expect, but you would still like to save the filter code so that you may edit it at a later time, click OK. You can then select the Dynamic Group from the Device List and right-click, then select Properties to edit the group filter code.

If you do not know how to formulate SQL queries, you can use the WhatsUp Gold Dynamic Group Builder, or cut and paste filter entries from existing dynamic groups, then edit them to read data from other tables.

WhatsUp Gold is pre-configured with dynamic group examples, which you can see in the Devices view, under Device Groups. For more information on these groups, see Using Dynamic Groups.

In addition to the pre-configured dynamic groups, we have provided several sample filters 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.