Taking Report from Dynatrace console for oneagent versions

[sundarv1]

How to take excel report from dynatrace console which shows host and oneagent version installed in the host

[Peter_Youssef]

Hello @sundarv1 

If you have access to env API v2 

• use the attached API

• Required scope: entities.read
• then save the JSon and extract it through excel as simple as that.

BR, 

Peter.

[sundarv1]

I do not have access to API. How to take it from console?

[Peter_Youssef]

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.

[sundarv1]

Thanks Peter

How to add oneagent version and OS Version to the tabular format so that we can extract this fields

[sundarv1]

Peter

How to enter the criteria - to get the output for which agent version is less than equal to 1.291.

[Peter_Youssef]

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.

[sundarv1]

How to display installer version in the result?. We want the installer version to be extracted in an excel sheet

[Peter_Youssef]

Hi @sundarv1 

It's easy, as follows

In Excel

Hoping it adds value

BR, 

Peter

[sundarv1]

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?

[sundarv1]

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.

[p_devulapalli]

Hi @sundarv1 , if you are fine with DQL , below query will get you the version 

fetch dt.entity.host
| fieldsAdd installerVersion

[sundarv1]

How do i use DQL?  I have access only to Dynatrace console.

[p_devulapalli]

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 

[sundarv1]

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

[PacoPorro]

Here you have a screenshot on how to download the output.

[PacoPorro]

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

[sundarv1]

We are using managed instance, not the saas to use dql

[sundarv1]

we are using managed inztance not the saas instance to use the DQL