16 Jan 2025 05:25 PM
DQL JOIN: How to Join from dt.entity.process_group_instance to dt.entity.host_group
I'm struggling to find a way of doing this. I'm look to run daily reports of DT Agents version following an Agent update. To track which teams have not restarted their processes.
It would be useful to have a document which shows how to join (which fields to use) between the dt.entity types.
Solved! Go to Solution.
16 Jan 2025 09:00 PM
Do you mean something like this?
fetch dt.entity.process_group_instance
| fieldsAdd host = belongs_to[dt.entity.host]
| fieldsAdd entityAttr(host, "hostGroupName", type: "dt.entity.host")