---
title: "Groups"
slug: "configure-define-systrack-groups"
updated: 2026-02-23T11:34:06Z
published: 2026-02-23T11:34:06Z
canonical: "documentation.lakesidesoftware.com/configure-define-systrack-groups"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Groups

SysTrack Groups provide a convenient way for you to organize systems you wish to reference as a group. After defining a group you can then use it throughout the various analytical tools.

There are two types of SysTrack groups that can be created: Dynamic groups based on a SQL query, and static groups in which we select specific systems.

1. Ensure that the Detail Level slider is set high enough that the Groups category is visible, and click **Groups** on the navigation pane.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/groups_1Cloud.png)
2. Click the **Add Group** button.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/group_addCloud.png)
3. Using the resulting dialog box:
  1. Enter a user-defined name for the new group.
  2. Select the group type. A **Dynamic Group** is a set of systems resulting from a user defined SQL query; the members of the group may vary over time. A **Static Group** is a group of implicitly specified systems.

> [!NOTE]
> **NOTE**: Group types cannot be changed once they are created.
  3. Click **OK**.
4. If you are adding a **Dynamic Group**:
  1. With the **Group** selected, enter a SQL query in the **Group Definition** field.

The first example below creates a dynamic group that selects systems using a Windows 10 operating system.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/group_definitionCloud.png)

To create rules for specific groups, enter **SELECT WGUID FROM [RPT_GROUP_*GROUPNAME*]** where **GROUPNAME** is the full name, including any spaces, of the desired group. The SQL shown in the second example below will return the **All Systems** group. Group names can be found in the RPT_Group view as well as on the **Configure > Groups** page.

![input field with example SQL for selecting a specific group](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/dynamicgroupSQL.png)

> [!NOTE]
> **NOTE:**The **Test SQL** button will remain inactive if the query is not properly formatted.
  2. Enter the maximum number of rows to include in the SQL test (step c) in the **Limit test to** field. The default number of rows for a test is 100.
  3. Click the **Test SQL**button. If your query is valid it will return results shown in the example below, and you can click the **OK** button.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/test_group_SQL.png)
  4. If your query does not pass the test because it is not valid, edit the query and repeat the test (steps a and b).
  5. If your query is valid, click the **Save Changes** button in the top right corner.
5. If you are adding a **Static Group**:
  1. With the new **Static Group**selected, select and drag the system or systems from the **Available Systems** pane that you want to include in the group list to the **Systems in Group** list.
  2. Use the Filter icon or the **Search value** field to narrow the list of systems.
6. The check box next to **Prevent selection of systems already assigned to a group** when selected, will make systems inactive (unselectable) in the **Available Systems** pane that are already assigned to a group.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/static_groupCloud.png)
7. Click **Save Changes** to save the **Static Group**.
