topic Data extraction for a specific host in Open Q&A

Data extraction for a specific host

Sohaib — Thu, 26 May 2022 08:57:20 GMT

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

Re: Data extraction for a specific host

Julius_Loman — Tue, 24 May 2022 10:42:52 GMT

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)

Re: Data extraction for a specific host

techean — Fri, 27 May 2022 10:49:31 GMT

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

Re: Data extraction for a specific host

funkymike7 — Tue, 16 Jan 2024 21:32:21 GMT

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

Re: Data extraction for a specific host

Julius_Loman — Wed, 17 Jan 2024 07:01:51 GMT

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