# Generate a report that contains OS versions

**URL:** <https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244>\
**Category:** Open Q&A\
**Tags:** reports, hosts-classic\
**Created:** [June 21, 2024, 6:08am UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244 "2024-06-21T06:08:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![SrikanthSamraj](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@SrikanthSamraj](https://community.dynatrace.com/u/SrikanthSamraj)\
**Post date:** [June 21, 2024, 6:08am UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/1 "2024-06-21T06:08:52Z")

</div>

Hi,

I’m keen to know if there’s a way to generate a report that includes operating system version for a specific operating system in Dynatrace?

At present, using hosts page/API, I can segregate them based on OS but not OS version.

Any tips would be helpful.

Regards,

Srikanth

---

<div class="post-metadata">

**Author:** ![Mohamed\_Hamdy](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@Mohamed\_Hamdy](https://community.dynatrace.com/u/Mohamed_Hamdy)\
**Post date:** [June 21, 2024, 1:22pm UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/2 "2024-06-21T13:22:41Z")

</div>

Hello&nbsp;[@SrikanthSamraj](https://community.dynatrace.com/user/58568),

if you are using API v2 you can use, entities API, and below are samples:

Sample 1:

/api/v2/entities?entitySelector=type(host),osVersion("Windows Server 2016 Standard ver. ")&fields=+properties.osType,+properties.osVersion,+properties.monitoringMode

Sample 2:

/api/v2/entities?entitySelector=type(host)&fields=+properties.osType,+properties.osVersion,+properties.monitoringMode

you can adjust the fields based on your requirements for which info you need to export

Best Regards,

Mohamed

---

<div class="post-metadata">

**Author:** ![SrikanthSamraj](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@SrikanthSamraj](https://community.dynatrace.com/u/SrikanthSamraj)\
**Post date:** [June 25, 2024, 12:09pm UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/3 "2024-06-25T12:09:24Z")

</div>

Thanks for the response&nbsp;[@Mohamed\_Hamdy](https://community.dynatrace.com/user/4007)&nbsp; I wish if this option of looking out for osVersion is included in /api/v1/oneagents..

---

<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 1, 2024, 7:28pm UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/4 "2024-07-01T19:28:44Z")

</div>

Hey&nbsp;[@SrikanthSamraj](https://community.dynatrace.com/user/58568)&nbsp;,  
If you’re still looking for a way out and you are on the latest version of Dynatrace SaaS and Grail enabled, you can build up a query like this.

```markup
fetch dt.entity.host
| fieldsAdd osType,osVersion
| filter osVersion == "Oracle Linux Server 7.9 (kernel 3.10.0-1160.118.1.0.1.el7.x86_64)"

```

edit the filter to suit your needs.  
Happy querying.😉  
Regards,  
[@Maheedhar\_T](https://community.dynatrace.com/user/76275)

---

<div class="post-metadata">

**Author:** ![SrikanthSamraj](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@SrikanthSamraj](https://community.dynatrace.com/u/SrikanthSamraj)\
**Post date:** [July 2, 2024, 3:11pm UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/5 "2024-07-02T15:11:34Z")

</div>

Thanks much&nbsp;[@Maheedhar\_T](https://community.dynatrace.com/user/76275). I’m yet to get my access enabled to use the latest version of Dynatrace SaaS with Grail enabled.

---

<div class="post-metadata">

**Author:** ![SrikanthSamraj](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@SrikanthSamraj](https://community.dynatrace.com/u/SrikanthSamraj)\
**Post date:** [July 22, 2024, 10:39am UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/6 "2024-07-22T10:39:02Z")

</div>

[@Maheedhar\_T](https://community.dynatrace.com/user/76275)&nbsp;- I’ve got access to latest Dynatrace and Grail, when I run query a like below it did generate result as expected but it is limited to just 1000 rows. Any ways to get result for entire hosts?

fetch dt.entity.host  
| fieldsAdd entity.type, lifetime, tags, osType, hypervisorType, state, cpuCores, memoryTotal, oneAgentCustomHostName, dnsNames, ipAddress, osVersion, installerVersion, osArchitecture, bitness, osServices, paasVendorType, cloudType, networkZone, monitoringMode, standalone, autoInjection, installerPotentialProblem, logicalCpus, physicalMemory, customHostMetadata, additionalSystemInfo, logicalCpuCores, virtualCpus, isMonitoringCandidate  
| filter osType == “AIX”

---

<div class="post-metadata">

**Author:** ![SrikanthSamraj](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@SrikanthSamraj](https://community.dynatrace.com/u/SrikanthSamraj)\
**Post date:** [July 22, 2024, 11:10am UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/7 "2024-07-22T11:10:46Z")

</div>

Got this, after inferring below one,

[https://community.dynatrace.com/t5/Dashboarding/Dynatrace-Notebook-entity-name/m-p/215299](https://community.dynatrace.com/post/215299)

---

<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 22, 2024, 11:39am UTC](https://community.dynatrace.com/t/generate-a-report-that-contains-os-versions/46244/8 "2024-07-22T11:39:27Z")

</div>

Hi&nbsp;[@SrikanthSamraj](https://community.dynatrace.com/user/58568)&nbsp;,  
You can increase the limit by providing

```markup
| limit 100000

```

at the end of the DQL but based on the number of hosts you are trying to fetch it may crash the query.

I suggest you use the same DQL in a workflow to get better output.
