Skip to content

Instantly share code, notes, and snippets.

@mpontillo
Created December 19, 2016 20:04
Show Gist options
  • Save mpontillo/dfb3b06cc86e60fc0cc816ba6716a23f to your computer and use it in GitHub Desktop.
Save mpontillo/dfb3b06cc86e60fc0cc816ba6716a23f to your computer and use it in GitHub Desktop.
$ sudo maas-region dbshell
maasdb=# SELECT r.gateway_ip, metric, source.cidr source, dest.cidr destination
FROM maasserver_staticroute r
JOIN maasserver_subnet source ON source.id = r.source_id
JOIN maasserver_subnet dest on dest.id = r.destination_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment