topic Re: Host Availability % for more than 500 hosts in Dynatrace API

Host Availability percentage for more than 500 hosts

JyotiSingh — Tue, 20 Aug 2024 13:31:55 GMT

How can I extract host availability for more than 500 host in excel from Dynatrace Saas/managed.

Is there any API that can help to extract this data?

Re: Host Availability % for more than 500 hosts

erh_inetum — Fri, 05 Jul 2024 18:40:07 GMT

The easiest way is getting the data from data Explorer using this metric: builtin:host.availability.state
Then, enabling flag "Advance mode" and removing :limit(x)
Finally, exporting the data to csv.

Hope it helps.

Regards,
Elena

Re: Host Availability % for more than 500 hosts

Malaik — Sun, 07 Jul 2024 05:43:50 GMT

Hi @JyotiSingh

In top of what Elena is saying, you can also use Dynatrace API to read the same metric:

https://docs.dynatrace.com/docs/shortlink/api-metrics-v2-get-all

Re: Host Availability % for more than 500 hosts

ChadTurner — Mon, 08 Jul 2024 14:12:55 GMT

@JyotiSingh , @erh_inetum and @Malaik are correct. The API will give you the RAW Json in which you can then ingest it into excel and massage the data as you see fit to provide a proper format as needed.

Re: Host Availability % for more than 500 hosts

JyotiSingh — Mon, 08 Jul 2024 18:47:40 GMT

Thanks this was the easiest solution & it worked for me.