Get Kubernetes Pod status

[ashokpjana]

have the cluster name and namespace details. Can I get the below details through DQL?

• Pods stuck in Pending/Unschedulable state
• Pods in CrashLoopBackOff or Failed state
• Nodes in NotReady/Unhealthy state
• Pod scheduling failures”

[p_devulapalli · Accepted solution]

@ashokpjana Example DQL for Pod state

fetch dt.entity.cloud_application_instance
| fieldsAdd id, cloudApplicationInstancePhase,currentCondition,
  cluster.id = clustered_by[dt.entity.kubernetes_cluster],
  namespace.id = belongs_to[dt.entity.cloud_application_namespace],
  workload.id = instance_of[dt.entity.cloud_application],
  node.id = runs_on[dt.entity.kubernetes_node]
| filter cloudApplicationInstancePhase == "PENDING"