https://community.dynatrace.com/t5/DQL/DQL-JOIN-How-to-Join-from-dt-entity-process-group-instance-to-dt/m-p/267662#M1614 <P>DQL JOIN: How to Join from dt.entity.process_group_instance to dt.entity.host_group</P><P>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.</P><P>It would be useful to have a document which shows how to join (which fields to use) between the dt.entity types.</P> Thu, 16 Jan 2025 17:25:28 GMT D_Miller 2025-01-16T17:25:28Z https://community.dynatrace.com/t5/DQL/DQL-JOIN-How-to-Join-from-dt-entity-process-group-instance-to-dt/m-p/267662#M1614 <P>DQL JOIN: How to Join from dt.entity.process_group_instance to dt.entity.host_group</P><P>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.</P><P>It would be useful to have a document which shows how to join (which fields to use) between the dt.entity types.</P> Thu, 16 Jan 2025 17:25:28 GMT https://community.dynatrace.com/t5/DQL/DQL-JOIN-How-to-Join-from-dt-entity-process-group-instance-to-dt/m-p/267662#M1614 D_Miller 2025-01-16T17:25:28Z https://community.dynatrace.com/t5/DQL/DQL-JOIN-How-to-Join-from-dt-entity-process-group-instance-to-dt/m-p/267693#M1617 <P>Do you mean something like this?</P> <LI-CODE lang="markup">fetch dt.entity.process_group_instance | fieldsAdd host = belongs_to[dt.entity.host] | fieldsAdd entityAttr(host, "hostGroupName", type: "dt.entity.host")</LI-CODE> Thu, 16 Jan 2025 21:00:45 GMT https://community.dynatrace.com/t5/DQL/DQL-JOIN-How-to-Join-from-dt-entity-process-group-instance-to-dt/m-p/267693#M1617 Tiit_Hallas 2025-01-16T21:00:45Z