Host Availability percentage for more than 500 hosts

[JyotiSingh]

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?

[erh_inetum · Accepted solution]

Hi @JyotiSingh ,

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

[JyotiSingh]

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

[Malaik]

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

[ChadTurner]

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