I’ve got a usecase to have the group names that a device is a member of passed down to the alerts, specifically Pagerduty.

On the PD side, I can route incidents based on arbitrary details, and if I had group membership I could say “If device.groups contains “Network” route to XXX”, instead of having to build a unique alert check for every group.

The mocked up SQL query is SELECT group_name FROM groups WHERE group_id IN (SELECT group_id FROM group_table WHERE entity_type = 'device' AND entity_id = ?);

Any chance that information can be made available? I’m happy to write the code if needed.

---

Spencer J. Ryan | Manager, Technology and Infrastructure

Miller Canfield

T +1.313.496.7979

---