Writing a Bash Script for GCP to Fetch Data | GSuite Solved

script to fetch the GCP project details as mention below.

projectid, name, projectnumber, date&time, folderpath, projectowner, folderpath, costcentre, label.

I have written belwo script and it is working for- projectid, name, projectnumber, date&time.

#!/bin/bash

> project_data.csv

gcloud projects list --format="value(project_id, name, project_number, project_owner, tag, createTime.date(tz=LOCAL))" >whole_project_details.txt

echo project_id, project_name, project_number, project_owner, project_tag, project_time >project_data.csv

while read project_details

do

project_id=`echo $project_details | awk '{print $1}'`

project_name=`echo  $project_details | awk '{print $2}'`

project_number=`echo $project_details | awk '{print $3}'`

project_time=`echo $project_details | awk '{print $4}'`

project_owner=`echo $project_details | awk '{print $5}'`

project_tag=`echo $project_details | awk '{print $6}'`

echo $project_id, $project_name, $project_number, $project_owner, $project_tag, $project_time  >> project_data.csv

done < whole_project_details.txt

But not able to fetch date of - owner, folderpath, label, costcentre.

please help me. Thank you in advance.

Best Answer from: sathyaram_s