topic Generate a report that contains OS versions in Open Q&A

Generate a report that contains OS versions

SrikanthSamraj — Fri, 21 Jun 2024 08:31:25 GMT

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

Re: Generate a report that contains OS versions

Mohamed_Hamdy — Fri, 21 Jun 2024 13:27:22 GMT

Hello @SrikanthSamraj,

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

Re: Generate a report that contains OS versions

SrikanthSamraj — Tue, 25 Jun 2024 12:09:24 GMT

Thanks for the response @Mohamed_Hamdy I wish if this option of looking out for osVersion is included in /api/v1/oneagents..

Re: Generate a report that contains OS versions

Maheedhar_T — Mon, 01 Jul 2024 19:28:44 GMT

Hey @SrikanthSamraj ,
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.

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

Re: Generate a report that contains OS versions

SrikanthSamraj — Tue, 02 Jul 2024 15:11:34 GMT

Thanks much @Maheedhar_T. I'm yet to get my access enabled to use the latest version of Dynatrace SaaS with Grail enabled.

Re: Generate a report that contains OS versions

SrikanthSamraj — Mon, 22 Jul 2024 10:39:02 GMT

@Maheedhar_T - 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"

Re: Generate a report that contains OS versions

SrikanthSamraj — Mon, 22 Jul 2024 11:10:46 GMT

Got this, after inferring below one,

https://community.dynatrace.com/t5/Dashboarding/Dynatrace-Notebook-entity-name/m-p/215299

Re: Generate a report that contains OS versions

Maheedhar_T — Mon, 22 Jul 2024 11:39:27 GMT

Hi @SrikanthSamraj ,
You can increase the limit by providing

| 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.