librenms-working-groups

MariaDB [librenms]> select * from device_groups;
+----+-------------+------+---------------------------------------------------+--------+
| id | name        | desc | pattern                                           | params |
+----+-------------+------+---------------------------------------------------+--------+
| 10 | USA-HT_ALL  |      | %ipv6_addresses.ipv6_compressed ~ "xxxx:xxxx:9:%" | NULL   |
| 11 | USA-HT_CORE |      | %devices.location ~ "%CORE%"                      | NULL   |
+----+-------------+------+---------------------------------------------------+--------+


MariaDB [librenms]> select * from device_group_device;
+-----------------+-----------+
| device_group_id | device_id |
+-----------------+-----------+
|              10 |         1 |
|              10 |         2 |
|              10 |         3 |
|              10 |         4 |
|              10 |         5 |
|              10 |         6 |
|              10 |         7 |
|              10 |        62 |
|              10 |        84 |
|              10 |       283 |
|              10 |       284 |
|              11 |         1 |
|              11 |         2 |
|              11 |         3 |
|              11 |         4 |
|              11 |         5 |
|              11 |         6 |
|              11 |         7 |
|              11 |        62 |
|              11 |       190 |
+-----------------+-----------+