23 Oct 2024 02:37 PM
How to take excel report from dynatrace console which shows host and oneagent version installed in the host
23 Oct 2024 03:07 PM
Hello @sundarv1
If you have access to env API v2
BR,
Peter.
23 Oct 2024 03:10 PM
I do not have access to API. How to take it from console?
23 Oct 2024 03:24 PM
Hi @sundarv1
From Data explorer and Metrics, both are accessible you can filter and split by and the data will be displayed in Tabular format then save it and extract it in Excel.
KR,
Peter.
23 Oct 2024 03:32 PM
Thanks Peter
How to add oneagent version and OS Version to the tabular format so that we can extract this fields
23 Oct 2024 03:46 PM
Peter
How to enter the criteria - to get the output for which agent version is less than equal to 1.291.
23 Oct 2024 03:54 PM
Hi @sundarv1
You can follow the attached example
you can specify installer version if you need and re-formulate the advanced formula as per your requirements.
KR,
Peter.
23 Oct 2024 04:20 PM
How to display installer version in the result?. We want the installer version to be extracted in an excel sheet
23 Oct 2024 05:21 PM
Thanks. Does this query will bring host installer version in the output and also to excel. Can we add the tag field to this output?
24 Oct 2024 03:11 AM
1. How to write an query which will extract all the hosts and its version. Currently we need to specificy the version in the query
2. Additionally in the output it is displaying - Host and Availability. it is not displaying oneagent version.
24 Oct 2024 04:43 AM
Hi @sundarv1 , if you are fine with DQL , below query will get you the version
fetch dt.entity.host
| fieldsAdd installerVersion
24 Oct 2024 05:45 AM
How do i use DQL? I have access only to Dynatrace console.
24 Oct 2024 05:54 AM
Hi @sundarv1 , I understand you are on managed, so DQL/Notebooks may not be available to you , will see if there is a alternate way to get this data
24 Oct 2024 02:11 PM
Thanks. Does this query will bring host installer version in the output and also to excel. Can we add the tag field to this output?
Appreciate your support
24 Oct 2024 03:55 PM
Here you have a screenshot on how to download the output.
24 Oct 2024 03:58 PM
And regarding how to obtain tags with dql, please check:
https://community.dynatrace.com/t5/DQL/Extract-TAG-values-from-hosts-tags-in-DQL/m-p/216140
But if you want something simply , you can try
fetch dt.entity.host
| fieldsAdd installerVersion, tags
24 Oct 2024 04:17 PM
We are using managed instance, not the saas to use dql
24 Oct 2024 04:16 PM
we are using managed inztance not the saas instance to use the DQL