mysql> SELECT * FROM endpoint;
+----------------------------------+----------------------------------+-----------+----------------------------------+-------------------------------------------+-------+---------+-----------+
| id                               | legacy_endpoint_id               | interface | service_id                       | url                                       | extra | enabled | region_id |
+----------------------------------+----------------------------------+-----------+----------------------------------+-------------------------------------------+-------+---------+-----------+
| 1bf9ee74b6994a5d9531abb1651d1212 | 6077d348c8d94efdb9c39eb0ecf57264 | public    | 3e6828489c7d41eea3d7c0a622a37635 | http://10.16.100.142:9292                 | {}    |       1 | RegionOne |
| 2e9bb72ea1fd472182b557d84aebc8aa | 6f63819a9ef14f7a8988a984e312c4a8 | admin     | 2d82e2413ba245df8539bac98c9b75df | http://10.16.100.31:80/swift              | {}    |       1 | RegionOne |
| 3a9ec16f07c5463aa512fa39c185ef58 | 7a6441e8218c433a936967d2ce25bab2 | internal  | 1aa7b470b6d84688bac4249f3fea0a5a | http://10.16.100.83:8776/v2/$(tenant_id)s | {}    |       1 | RegionOne |
| 3fdd0936b1314bb8b2566ed466726212 | 7a6441e8218c433a936967d2ce25bab2 | admin     | 1aa7b470b6d84688bac4249f3fea0a5a | http://10.16.100.83:8776/v2/$(tenant_id)s | {}    |       1 | RegionOne |
| 4721068f646243c48b46414cc59b9a28 | 31f3126cc28e4885ac7ae905163960b5 | admin     | 2814fe91385f43138755c64073fc5601 | http://10.16.100.114:9696                 | {}    |       1 | RegionOne |
| 631c88db6c624f6181f92293e89ea99b | 6077d348c8d94efdb9c39eb0ecf57264 | admin     | 3e6828489c7d41eea3d7c0a622a37635 | http://10.16.100.142:9292                 | {}    |       1 | RegionOne |
| 686747ce3c49431c82918971a27418b5 | 6077d348c8d94efdb9c39eb0ecf57264 | internal  | 3e6828489c7d41eea3d7c0a622a37635 | http://10.16.100.142:9292                 | {}    |       1 | RegionOne |
| 7dfa5461938842019f07e61b79319f45 | 8df3d7bccb9c4a37913f83ba271fac1b | public    | 4a9be0289a4a4dea8f60da3bc5886458 | http://10.16.100.78:8000/v1               | {}    |       1 | RegionOne |
| 8736c7ac763749c3a37c4aaa05ae3f92 | 016e7ef49f594a58b487bf5a7aad8683 | admin     | 5322df4fc21e45338eba7105ac1907f2 | http://10.16.100.78:8004/v1/$(tenant_id)s | {}    |       1 | RegionOne |
| 8b7a5e23a41542cd9cdd4d34e85b27f1 | afe0f6f120c54cd0a7b8e12141c32228 | internal  | b9d29087b1ba43a984573649465528e2 | http://10.16.100.77:8774/v2/$(tenant_id)s | {}    |       1 | RegionOne |
| 8d1a40fdbc934838a8b4b7709a626fb8 | 8df3d7bccb9c4a37913f83ba271fac1b | admin     | 4a9be0289a4a4dea8f60da3bc5886458 | http://10.16.100.78:8000/v1               | {}    |       1 | RegionOne |
| 946492c5171245fb9d43215118c74758 | 016e7ef49f594a58b487bf5a7aad8683 | public    | 5322df4fc21e45338eba7105ac1907f2 | http://10.16.100.78:8004/v1/$(tenant_id)s | {}    |       1 | RegionOne |
| 9e3245fe83f94ab595783bc8f45be795 | 016e7ef49f594a58b487bf5a7aad8683 | internal  | 5322df4fc21e45338eba7105ac1907f2 | http://10.16.100.78:8004/v1/$(tenant_id)s | {}    |       1 | RegionOne |
| a4f12ae7180a4175a76106eb329b5c10 | afe0f6f120c54cd0a7b8e12141c32228 | public    | b9d29087b1ba43a984573649465528e2 | http://10.16.100.77:8774/v2/$(tenant_id)s | {}    |       1 | RegionOne |
| c50ac7ae16464c71bd8b55ebc5b92809 | 31f3126cc28e4885ac7ae905163960b5 | public    | 2814fe91385f43138755c64073fc5601 | http://10.16.100.114:9696                 | {}    |       1 | RegionOne |
| ca0eaa240ea54f9b9730f4a60c71adda | 6f63819a9ef14f7a8988a984e312c4a8 | public    | 2d82e2413ba245df8539bac98c9b75df | http://10.16.100.31:80/swift/v1           | {}    |       1 | RegionOne |
| d5625875d2534425bea5b68f47c317e8 | 7a6441e8218c433a936967d2ce25bab2 | public    | 1aa7b470b6d84688bac4249f3fea0a5a | http://10.16.100.83:8776/v2/$(tenant_id)s | {}    |       1 | RegionOne |
| df53399585f34b55bdd16c6472048df1 | 6f63819a9ef14f7a8988a984e312c4a8 | internal  | 2d82e2413ba245df8539bac98c9b75df | http://10.16.100.31:80/swift/v1           | {}    |       1 | RegionOne |
| e1432c5cdeca45fca8802a2625c7fc61 | 31f3126cc28e4885ac7ae905163960b5 | internal  | 2814fe91385f43138755c64073fc5601 | http://10.16.100.114:9696                 | {}    |       1 | RegionOne |
| e2fa5bb3826d4001974e5d1fa71645ab | 8df3d7bccb9c4a37913f83ba271fac1b | internal  | 4a9be0289a4a4dea8f60da3bc5886458 | http://10.16.100.78:8000/v1               | {}    |       1 | RegionOne |
| e6205b85b18e410b90bb7ac2b5b9c2fb | 3ea53aafc2e94867b88167170cbc0db8 | public    | 525c5d837edc4f4284114243f4926b49 | http://10.16.100.83:8776/v1/$(tenant_id)s | {}    |       1 | RegionOne |
| f299fb4bdad8476e875af1cfc9902208 | afe0f6f120c54cd0a7b8e12141c32228 | admin     | b9d29087b1ba43a984573649465528e2 | http://10.16.100.77:8774/v2/$(tenant_id)s | {}    |       1 | RegionOne |
| f349322a4ad442398068071d8844ed5d | 3ea53aafc2e94867b88167170cbc0db8 | admin     | 525c5d837edc4f4284114243f4926b49 | http://10.16.100.83:8776/v1/$(tenant_id)s | {}    |       1 | RegionOne |
| f47988d2b25b4e93930dfb960a707800 | 886b1fe8b6ef4c63b4180e4fd244b1db | admin     | a7f165d1f2564c24a68243f74e58e2fe | http://10.16.100.110:35357/v2.0           | {}    |       1 | RegionOne |
| f7b21c4268054e1f95211cf4fa6f8755 | 3ea53aafc2e94867b88167170cbc0db8 | internal  | 525c5d837edc4f4284114243f4926b49 | http://10.16.100.83:8776/v1/$(tenant_id)s | {}    |       1 | RegionOne |
| fae2e8473b5f4c7aa96fa5236cb0c317 | 886b1fe8b6ef4c63b4180e4fd244b1db | public    | a7f165d1f2564c24a68243f74e58e2fe | http://10.16.100.110:5000/v2.0            | {}    |       1 | RegionOne |
| fc30d9972e8245c9bb7426a1c2f90d26 | 886b1fe8b6ef4c63b4180e4fd244b1db | internal  | a7f165d1f2564c24a68243f74e58e2fe | http://10.16.100.110:5000/v2.0            | {}    |       1 | RegionOne |
+----------------------------------+----------------------------------+-----------+----------------------------------+-------------------------------------------+-------+---------+-----------+
27 rows in set (0.00 sec)