Uly.me

cloud engineer

Cloud

Gcloud Table vs CSV Format

Differences using gcloud table vs CSV format.

Table format

gcloud compute snapshots list \
--filter="sourceSnapshotSchedulePolicy ~ $POLICY AND sourceDisk~$disk$" \
--format="table(sourceDisk.basename(),name,creationTimestamp,sourceSnapshotSchedulePolicy.basename())" \
--sort-by "~creationTimestamp" \
--project="$PROJECT"

CSV format

gcloud compute snapshots list \
--filter="sourceSnapshotSchedulePolicy ~ $POLICY AND sourceDisk~$disk$" \
--format="csv[separator=','](sourceDisk.basename(),name,creationTimestamp,sourceSnapshotSchedulePolicy.basename())" \
--sort-by "~creationTimestamp" \
--project="$PROJECT"

Output to file

gcloud compute snapshots list \
--filter="sourceSnapshotSchedulePolicy ~ $POLICY AND sourceDisk~$disk$" \
--format="csv[separator=','](sourceDisk.basename(),name,creationTimestamp,sourceSnapshotSchedulePolicy.basename())" \
--sort-by "~creationTimestamp" \
--project="$PROJECT" > output.csv

GCP Cloud Shell Format

If you are getting funky formatting in GCP Cloud Shell, run this to set the format.

gcloud config set accessibility/screen_reader False

GCP VM Licenses

Here’s the command to display VM OS licenses.

#!/bin/bash
ts=$(date +%Y%m%d-%H%M%S)
log="gcp-licenses-logs-$ts"
>$log
while read -r project; do
    echo "Project: $project" | tee -a $log
    gcloud compute instances list --project $project --format="table[no-heading](name,zone.basename())" > instances.list
    while read -r instance zone; do
        gcloud compute instances describe $instance \
        --project $project \
        --zone $zone \
        --format="table[no-heading](name,zone.basename(),disks[0].licenses[0].basename())" | tee -a $log
    done < instances.list 
done < projectIds.txt