• Skip to main content

Uly.me

cloud engineer

  • Home
  • About
  • Search

format

Gcloud Table vs CSV Format

September 18, 2023

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"

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"

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

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

Filed Under: Cloud Tagged With: csv, format, gcloud, gcp, output, table

GCP Cloud Shell Format

September 18, 2023

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

gcloud config set accessibility/screen_reader False

gcloud config set accessibility/screen_reader False

Filed Under: Cloud Tagged With: cloud, format, gcp, set, shell

Mac vs Linux Date

August 17, 2023

Converting Mac and Linux Dates

Linux

#!/bin/bash
start_time=$(date +%s)
log=$(date -d @$start_time +%Y%m%d-%H%M%S) 
start=$(date -d @$start_time)
echo $start_time
echo $log
echo $start
sleep 10
stop_time=$(date +%s)
stop=$(date -d @$stop_time)
echo $stop_time
echo $stop

#!/bin/bash start_time=$(date +%s) log=$(date -d @$start_time +%Y%m%d-%H%M%S) start=$(date -d @$start_time) echo $start_time echo $log echo $start sleep 10 stop_time=$(date +%s) stop=$(date -d @$stop_time) echo $stop_time echo $stop

Mac

#!/bin/bash
start_time=$(date +%s)
log=$(date -r $start_time +%Y%m%d-%H%M%S) 
start=$(date -r $start_time)
echo $start_time
echo $log
echo $start
sleep 10
stop_time=$(date +%s)
stop=$(date -r $stop_time)
echo $stop_time
echo $stop

#!/bin/bash start_time=$(date +%s) log=$(date -r $start_time +%Y%m%d-%H%M%S) start=$(date -r $start_time) echo $start_time echo $log echo $start sleep 10 stop_time=$(date +%s) stop=$(date -r $stop_time) echo $stop_time echo $stop

Same output for both

1692292771
20230817-171931
Thu Aug 17 05:19:31 PM UTC 2023
1692292781
Thu Aug 17 05:19:41 PM UTC 2023

1692292771 20230817-171931 Thu Aug 17 05:19:31 PM UTC 2023 1692292781 Thu Aug 17 05:19:41 PM UTC 2023

Filed Under: Linux Tagged With: date, differences, format, linux, mac

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »
  • Home
  • About
  • Search

Copyright © 2023