Uly.me

cloud engineer

Home/Archives for list

GCP List of SQL Instances

Here’s how to list SQL instances within your GCP project.

gcloud sql instances list --project your-project-id

Output:

NAME             DATABASE_VERSION         LOCATION       TIER              PRIMARY_ADDRESS  PRIVATE_ADDRESS  STATUS
database1        SQLSERVER_2017_STANDARD  us-central1-a  db-n1-standard-1  -                10.10.10.11    RUNNABLE
database2        SQLSERVER_2017_STANDARD  us-central1-c  db-n1-standard-1  -                10.10.10.12    RUNNABLE

GCP List of Projects

Here’s another way to list projects in a shared VPC.

gcloud compute shared-vpc list-associated-resources your-shared-host

Output:

project1  PROJECT
project2  PROJECT
project3  PROJECT
...

AWS List Machine Images

Here’s how to list AWS AMI (machine images) owned by yourself.

aws ec2 describe-images \
--query "Images[*].[Name,PlatformDetails]" \
--owners self \
--profile default \
--region us-east-1 \
--output text

Output:

icecast-0.1     Linux/UNIX
jekyll-0.3      Linux/UNIX
docker-0.1      Linux/UNIX

Specifying owners as self only display images owned by you.

Filter Output of LSBLK

Here’s one way to display block devices, mountpoints and size using lsblk.

lsblk -a -p -n -d -e 230 -o NAME,MOUNTPOINT,SIZE

Here are the options.

  • -a = list all empty devices
  • -p = print full device paths
  • -d = do not print holder devices or slaves
  • -e = exclude devices as by a comma-separate list
  • -o = specify which columns to print, e.g. NAME,MOUNTPOINT,SIZE

The output.

/dev/sda             30G
/dev/sdb /data       50G

Here’s the man page.

GCP SSL Certificates

Here’s how to create a regional SSL Certificate.

gcloud compute ssl-certificates create my-ssl-cert \
--description "describe ssl certificate" \
--domains=domain1.com,domain2.com \
--certificate=cert.pem \
--private-key=private.key \
--region=us-central1

List the SSL certificates.

gcloud compute ssl-certificates list --project=project-id

Describe the SSL certificate.

gcloud compute ssl-certificates describe my-ssl-cert \
--region=us-central1 \
--project=project-id

Delete SSL certificate.

gcloud compute ssl-certificates delete my-ssl-cert \
--region=us-central1 \
--project=project-id