Script to collect OS license data from the instances

get_license_data.sh

#!/bin/bash

# Header row for the CSV output
echo "project_id,instance_name,license"

# for every project in the list get the required details. Remove CSV header from the gcloud output. Add the project id to the beginning of each row
for project in  $(gcloud projects list --format="value(projectId)")
do
        # Because of the nested structure you get ']] at the end of the output. Use sed to remove it
        gcloud compute instances list --format="csv[no-heading](name,disks.licenses.basename())" --project $project | sed s/\']]//g | sed "s/^/$project,/"
done