get_gcp_vm_os.sh

echo Project Name,Disk Name,Source Image
for projectname in `gcloud projects list --format json | jq -r '.[].projectId'`; do
  gcloud compute disks list -q --project $projectname --format json | \
  jq -r '.[] | ["\(.name)", "\(.sourceImage)"] | @tsv' | \
  while IFS=$'\t' read -r diskname sourceimage; do
    os=`echo $sourceimage | awk -F "/" '{print $NF}'`;
    echo $projectname,$diskname,$os;
  done;
done