Data extraction for a specific host

[Sohaib]

Hello,

I wanted to know if there is a way to extract data for a specific host.

What i want is => For a specific host => List all processes and services.

Something like the smartscape view.

If there is a way to clone the smartscape view into a dashboard that would be even better.

Thanks

[Julius_Loman · Accepted solution]

For data export it's recommended to access the data using Monitored Entities v2 API. 

For putting a list of processes from a single HOST (or many hosts) on a dashboard you need to query a metric and use the Data Explorer for that. You can for example use the following query to display the memory of all processes running on a host with the given HOST ID.  Then you can display it in a table to get a list.

builtin:tech.generic.mem.usage
:filter(
  in("dt.entity.process_group_instance", 
      entitySelector("type(PROCESS_GROUP_INSTANCE),fromRelationships.isProcessOf(entityId(HOST-3800BB31B525FC56))"
  )))
:splitBy("dt.entity.process_group_instance")
:avg:auto:sort(value(avg,descending)):limit(100)

[funkymike7]

Would there be an equivalent for using the API to perform an extract as well to Excel?

[Julius_Loman]

@funkymike7 yes, you can access the Dynatrace API from Excel too, see some hints and examples here.

[techean]

@Sohaib Right now we dont have a View where you can pull out the data against host. Try posting this as product idea justifying the business case and importance, if voted can be taken for development as a feature. Did you also explore multidimensional analysis for fine tuning service view?