topic Re: Build a Dashboard Displaying Workloads per Node in Kubernetes in Dashboarding

Build a Dashboard Displaying Workloads per Node in Kubernetes

Gyanendra — Thu, 19 Dec 2024 14:20:56 GMT

I want to create a dashboard that lists all the workloads running on a specific node. For example, if Node A has 5 pods running on it, the metric should display this information. Could someone please suggest if this is achievable?

I tried, but when I select the node metric, it doesn’t have dimensions for workload names or pod names. Similarly, when I select the pod (workload) metric, it doesn’t have dimensions for the node. As a result, I’m unable to achieve the desired outcome.

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Theodore_x86 — Thu, 19 Dec 2024 15:49:25 GMT

Hello.

Cannot think of a way to do this in a dashboard. You can only add the link to the Kubernetes node page in your dashboards.

A nice new idea would be to add the "Pin to dashboard" button for the pod list page. If it was present you could filter with Node and then pin the list to dashboard.

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Peter_Youssef — Thu, 19 Dec 2024 18:55:43 GMT

Hi @Gyanendra

You can refer to a similar case as attached below:

https://community.dynatrace.com/t5/Alerting/Show-Container-name-on-Kubernetes-container-restart-alerts/m-p/265760#M5288
Also you can refer to the topology model through the monitored environment for further correlation.

Hoping it adds value,

BR,

Peter

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Peter_Youssef — Thu, 19 Dec 2024 19:00:56 GMT

Hi @Gyanendra

PFA alternative solution :

Ensure the K8s technology is supported.
The MZ configurations are accurate.
No issues with monitoring signal flow into Dynatrace.

Ref:

https://docs.dynatrace.com/docs/observe/infrastructure-monitoring/container-platform-monitoring/kubernetes-monitoring/monitor-prometheus-metrics
https://www.youtube.com/watch?v=Qxt3XAMJNhA
Ensure the metrics are fed with the monitoring data as expected through Metrics or data explorer.

Support:

Hoping it helps.

BR,

Peter

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

PacoPorro — Fri, 20 Dec 2024 13:13:54 GMT

try with

fetch dt.entity.kubernetes_node, from: -30m | fields id, node.id = id, node.name = entity.name,cluster.id = clustered_by[dt.entity.kubernetes_cluster] | filter in(id, classicEntitySelector("type(KUBERNETES_NODE),toRelationship.isClusterOfNode(type(KUBERNETES_CLUSTER),appEnabled(true))")) | lookup [ fetch dt.entity.kubernetes_cluster, from: -30m | fields id, cluster.name = entity.name, cluster.cluster_id = kubernetesClusterId ], sourceField:cluster.id, lookupField:id, fields:{cluster.name,cluster.cluster_id}, executionOrder:leftFirst | lookup [ timeseries values = sum(dt.kubernetes.pods), by:{dt.entity.kubernetes_node}, from: -2m | fields pod.count = toLong(arrayFirst(values)), matchedId = dt.entity.kubernetes_node ], sourceField:id, lookupField:matchedId, fields:{pod.count}, executionOrder:leftFirst

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Gyanendra — Fri, 20 Dec 2024 13:37:44 GMT

can we run this query in old DT (classic)? If yes, then where? I guess in Data explorer we can't run this command.

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Peter_Youssef — Fri, 20 Dec 2024 15:01:48 GMT

Hi @Gyanendra

You can run the provided inputs in the latest Dynatrace.

BR,

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Gyanendra — Thu, 26 Dec 2024 08:37:04 GMT

Got it, thanks

Re: Build a Dashboard Displaying Workloads per Node in Kubernetes

Peter_Youssef — Thu, 26 Dec 2024 09:14:35 GMT

Hi @Gyanendra

As of now you have all possible alternatives either DQL 😀"code level" 😉 or UI 😊.

Keep up the good work.