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

Spliting the ProcessGroup/Process Metric result based on Hosts

Aravindhan
Frequent Guest

Team,

As we are trying to built the tabulating information to split the process count based on the hosts where we unable to find the exact metric to capture it. Though we have tried to build the code also in data explorer. Please advise us on this.

Thanks

5 REPLIES 5

Julius_Loman
DynaMight Guru
DynaMight Guru

You need to use the count aggregation and just a generic process group instance-based metric with the parents transformation:

builtin:tech.generic.cpu.usage
:filter(and(or(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),entityName.startsWith(~"Dummy~")")))))
:parents
:splitBy("dt.entity.host")
:count
:auto
:sort(value(avg,descending))
:limit(100)

This will filter the metric for processes with a given name, then with :parents you add a new dimension (host) and then you can split by it.

This will only work if you see multiple process group instances, e.g.

Julius_Loman_0-1669723870905.png

or on the classic page:

Julius_Loman_1-1669723905711.png

If multiple OS processes are in a single process group instance, then it's not possible to display that on dashboard.

Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner

Thanks @Julius_Loman,

If the CPU Usage is the metrics, yes this will be feasible. Will it be applicable for the Process count as per the process group. Tried with that, still it got failed.

builtin:tech.generic.count:splitBy():sort(value(auto,descending)):limit(100)

Where the dt.entity.host was not supported for filter.

its a single OS process in Process group.

Looking for your advise.

Thanks,

Aravindhan Vellaichamy

My solution will provide you with the count of process group instances per host as I used count aggregation.

Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner

Hi Julius,

Understand that the process group-based CPU usage has been plotted from the given script. But the lookout is, "Process count per process-group" split by "Host".

Will it be possible

Thanks,

Aravindhan Vellaichamy

Can you give an example of the output you want to achieve?

Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner