{"id":12804,"date":"2019-09-14T06:39:29","date_gmt":"2019-09-14T04:39:29","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-get-a-big-picture-of-k8s-pods-and-pvs-by-script\/"},"modified":"2019-09-14T06:39:29","modified_gmt":"2019-09-14T04:39:29","slug":"how-to-get-a-big-picture-of-k8s-pods-and-pvs-by-script","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-get-a-big-picture-of-k8s-pods-and-pvs-by-script\/","title":{"rendered":"How to get a big picture of K8s pods and PVs by script"},"content":{"rendered":"

A couple of weeks ago, during an internal dbi services workshop about Docker and K8s, I got an interesting question: is it possible to get a big picture of pods connected to one specific persistent volume (PV) by using kubectl command?<\/span><\/span><\/p>\n

\"\"<\/a><\/p>\n

It was an interesting question because if we go through the usual kubectl command, it doesn\u2019t provide natively the desired output. In fact, one one hand we get information about PVs and their related persistent volume claims (PVC) and one other hand Pods with their PVCs.<\/span><\/span><\/span><\/p>\n

I didn’t find out any relevant result with my google-fu so here my contribution with a bash script that provides the overall picture of pods that are tied to a specific PV. It could be helpful in any appropriate way to quickly identify stateful(set) applications like SQL Server databases (and others) and their related storage \ud83d\ude42
\n<\/span><\/p>\n

#!\/bin\/bash\n\npv=$1\n\npvcs=$(kubectl get pv --output=json | jq -r --arg PV \"$pv\" '.items[] | select (.metadata.name==$PV or $PV==\"\") | \"\\(.metadata.name)\" + \"|\" + \"\\(.spec.claimRef.namespace)\" + \"|\" + \"\\(.spec.claimRef.name)\"')\n\n for pvc in $pvcs \n do \n     p_pv=$(echo $pvc | cut -d'|' -f1)\n     p_ns=$(echo $pvc | cut -d'|' -f2)\n     p_pvc=$(echo $pvc | cut -d'|' -f3)\n  \n     echo \"====================================================\"\n     echo \"==> pv: $p_pv\"\n     kubectl get pods -n $p_ns --output=json | jq -c --arg CLAIM \"$p_pvc\" '.items[] | {Pod: .metadata.name, Namespace: .metadata.namespace, ClaimName: .spec | select ( has (\"volumes\") ).volumes[] | select( has (\"persistentVolumeClaim\") ).persistentVolumeClaim | select (.claimName==$CLAIM) }'\n done<\/pre>\n
 <\/p>\n
If you provide as input a specific PV you will get a picture of all pods tied to it otherwise all PVs and their linked pods will be shown in the output. <\/span><\/span><\/p>\n