# Get the list of hosts that have oneagents which are no longer supported via DQL

**URL:** <https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431>\
**Category:** Open Q&A\
**Tags:** oneagent, hosts-classic\
**Created:** [July 2, 2024, 8:07pm UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431 "2024-07-02T20:07:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maheedhar\_T](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/maheedhar_t/32/155_2.png) [@Maheedhar\_T](https://community.dynatrace.com/u/Maheedhar_T)\
**Post date:** [July 2, 2024, 8:07pm UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/1 "2024-07-02T20:07:29Z")

</div>

Is there a way we can get the list of all the hosts which have outdated oneagent versions which are no longer supported by Dynatrace using a DQL ?

---

<div class="post-metadata">

**Author:** ![p\_devulapalli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/p_devulapalli/32/41590_2.png) [@p\_devulapalli](https://community.dynatrace.com/u/p_devulapalli)\
**Post date:** [July 2, 2024, 11:55pm UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/2 "2024-07-02T23:55:17Z")

</div>

Please try

fetch dt.entity.host  
| fieldsAdd entity.type, lifetime, tags, osType, hypervisorType, state, cpuCores, memoryTotal, ipAddress, osVersion, installerVersion, osArchitecture, networkZone, monitoringMode

You can filter out the versions based on the support

> **[OneAgent release notes](https://docs.dynatrace.com/docs/whats-new/oneagent)**
>
> Release notes for Dynatrace OneAgent

---

<div class="post-metadata">

**Author:** ![Maheedhar\_T](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/maheedhar_t/32/155_2.png) [@Maheedhar\_T](https://community.dynatrace.com/u/Maheedhar_T)\
**Post date:** [July 3, 2024, 6:24am UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/3 "2024-07-03T06:24:15Z")

</div>

Hi&nbsp;[@p\_devulapalli](https://community.dynatrace.com/user/21657)&nbsp;,  
Thanks for the reply but I would like to use it dynamically. I am planning to use this in a dashboard so it would help if the query is Dynamic instead of us needing to change the version manually again and again.

---

<div class="post-metadata">

**Author:** ![GerardJ](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/gerardj/32/154_2.png) [@GerardJ](https://community.dynatrace.com/u/GerardJ)\
**Post date:** [July 3, 2024, 8:25am UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/4 "2024-07-03T08:25:49Z")

</div>

Hi&nbsp;[@Maheedhar\_T](https://community.dynatrace.com/user/76275)&nbsp;  
To monitor this we use the “Dynatrace Tenant Review” dashboard that you can find [here](https://github.com/dynatrace-oss/CustomerSuccess)  
There is a section on “Unsopprted OneAgents”

---

<div class="post-metadata">

**Author:** ![p\_devulapalli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/p_devulapalli/32/41590_2.png) [@p\_devulapalli](https://community.dynatrace.com/u/p_devulapalli)\
**Post date:** [July 3, 2024, 8:46am UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/5 "2024-07-03T08:46:09Z")

</div>

Below are more details about the dashboard shared by&nbsp;[@GerardJ](https://community.dynatrace.com/user/66575)

[https://community.dynatrace.com/t5/Videos/Dynatrace-Tips-amp-Tricks-Episode-16-Dynatrace-Tenant-Review/td-p/221840](https://community.dynatrace.com/topic/221840)

---

<div class="post-metadata">

**Author:** ![Maheedhar\_T](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/maheedhar_t/32/155_2.png) [@Maheedhar\_T](https://community.dynatrace.com/u/Maheedhar_T)\
**Post date:** [July 3, 2024, 11:47am UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/6 "2024-07-03T11:47:28Z")

</div>

This kind of helps. Is there a list of such useful dashboards anywhere in the documentation?  
Regards,  
[@Maheedhar\_T](https://community.dynatrace.com/user/76275)

---

<div class="post-metadata">

**Author:** ![GerardJ](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/gerardj/32/154_2.png) [@GerardJ](https://community.dynatrace.com/u/GerardJ)\
**Post date:** [July 3, 2024, 1:49pm UTC](https://community.dynatrace.com/t/get-the-list-of-hosts-that-have-oneagents-which-are-no-longer-supported-via-dql/46431/7 "2024-07-03T13:49:28Z")

</div>

Unfortunately, as far as I know, there’s no such thing in the documentation.  
Most of the resources I’ve found here and there come from the community and its invaluable dynamights like in this kind of post :&nbsp;[Solved: Pro Tips – My summary of great tips - Dynatrace Community](https://community.dynatrace.com/topic/203346)
