topic Re: extract hosts in excel or csv in Open Q&A

extract hosts in excel or csv

mahima_goel — Thu, 02 Apr 2020 14:33:22 GMT

I want to extract all the list of hosts in a excel or csv file for a Saas

Re: extract hosts in excel or csv

justin_hogue — Mon, 16 Oct 2023 14:29:12 GMT

Hello,

One way to do this would be to utilize the Environment API v1. Under Topology & Smartscape you can grab a list of all available hosts in your environment and then download a json file for the given output. You can then convert that json data into a table in excel.

Here is a link that explains how to convert the json data in exel that might be useful.

https://community.dynatrace.com/spaces/482/dynatrace-open-qa/questions/233359/audit-log-api-how-to-convert-jason-data-to-excel.html

Hope this helps!

Re: extract hosts in excel or csv

mahima_goel — Thu, 02 Apr 2020 15:21:52 GMT

Is this mean I don't have permissions?

Re: extract hosts in excel or csv

justin_hogue — Thu, 02 Apr 2020 15:29:23 GMT

Did you authorize with an API token that has the correct permissions?

Re: extract hosts in excel or csv

justin_hogue — Thu, 02 Apr 2020 15:34:32 GMT

To do this you'll need to go to Settings > Integration > Dynatrace API. You'll then need to generate a token with the following permission: Access problem and event feed, metrics, and topology. Then copy the generated token and use it to authorize that API by clicking the lock icon and adding the copied token into the box labeled Value. After that authorize the token and then try to execute that API again.

Re: extract hosts in excel or csv

mahima_goel — Thu, 02 Apr 2020 16:00:20 GMT

Did as you said, but still receiving same error

Re: extract hosts in excel or csv

ChadTurner — Thu, 02 Apr 2020 20:48:31 GMT

Hey, You will need to create an API token like this one:

You will need to copy that token code an authorize the API:

Then make sure you select Try it out!

Let me know if you get an error and we can work through it.