cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Host Availability % for more than 500 hosts

JyotiSingh
Newcomer

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?

4 REPLIES 4

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

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

Malaik
DynaMight Champion
DynaMight Champion

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

 

 

Sharing Knowledge

ChadTurner
DynaMight Legend
DynaMight Legend

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

-Chad

Featured Posts