Using target attributes in target filter queries

[krishna-devolo]

Dear hawkBit Community,

I work at devolo AG, Germany, and we use hawkBit extensively to manage our networking devices. We rely primarily on the target attributes, such as device_type and firmware_date, to select target groups. These are modeled as target filter queries in the hawkBit management UI, and are used for auto assignment and rollouts.

Since the target attributes are stored as a long table (sp_target_attributes), these target filter queries (that match several target attributes) involve several join operations. As a result, these are quite inefficient. (We have a few million targets, so this is a big contributing factor.)

We are curious how you select different target groups using target filter queries. Do you primarily use information already contained in the sp_target table, such as installed_distribution_set and update_status? How do you use the target attributes, if at all?