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

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 ?

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

Hi @p_devulapalli ,
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.

Hi @Maheedhar_T 
To monitor this we use the “Dynatrace Tenant Review” dashboard that you can find here
There is a section on “Unsopprted OneAgents”

Below are more details about the dashboard shared by @GerardJ

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

This kind of helps. Is there a list of such useful dashboards anywhere in the documentation?
Regards,
@Maheedhar_T

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 : Solved: Pro Tips – My summary of great tips - Dynatrace Community