##
* get all tenant info
```sql
select CAST(id as CHAR) as tenant_id, name, kind, status from tenants where id in ('1372813089196161284', '1372813089191661281', '1372813089208281461', '1372813089209214792', '1372813089208251600', '1372813089209216104', '', '1372813089209218526', '1372813089197751283', '1372813089194331289', '1372813089208221667', '1372813089208431301', '1372813089191271282', '1372813089209061633', '1372813089208281546', '1372813089209121503', '1372813089209062317', '1372813089200631285', '1372813089189921287', '1372813089208221493', '1372813089209091403', '1372813089209222887', '1372813089194211283', '1372813089208881847', '1372813089200031287', '1372813089208791698', '1372813089209212300', '1372813089195441286', '1311265642040528896', '1372813089198891281', '1372813089209181630', '1372813089209214865', '1372813089209218379', '1372813089209212799', '1372813089208221464', '1372813089209228886', '1372813089197721283', '1372813089209213994', '1372813089208251389', '1372813089208341736', '1372813089204111291', '1372813089209001498', '1372813089206001286', '1372813089207801283', '1372813089208281511', '1372813089209215098', '1372813089208521813', '1372813089208521357', '1372813089208881580', '1372813089209216901', '1372813089197841286', '1372813089205401281', '1372813089208461447', '1372813089209216184', '1372813089206991281', '1372813089209121447', '1372813089207381282', '1372813089209181586', '1372813089209214590', '1372813089205701281', '1372813089209228506', '1372813089201471287', '1326455380288475136', '1372813089191091284', '1372813089188871292', '1372813089209213568', '1372813089190191282', '1372813089189201287', '1372813089203271293', '1372813089208221779', '1372813089209215550', '1372813089208761321', '1372813089190491281', '1372813089208281312', '1372813089208311964', '1372813089208221803', '1372813089209215669', '1372813089209212842', '1372813089205491282', '1372813089193221283', '1372813089209211720', '1372813089207561288', '1372813089209031581', '1372813089208221406', '1372813089209218013', '1372813089203451282', '1372813089208311888', '1372813089208311369', '1372813089209220586', '1372813089209225520', '1372813089187041280', '1372813089188151296', '1372813089208311734', '1372813089209220154', '1372813089209218064', '1372813089208221640', '1372813089208401307', '1372813089209219190', '1372813089201321287', '1372813089209227983', '1372813089209223476', '1372813089207501285', '1372813089205191286', '1372813089190911285', '1372813089202131285', '1372813089208311440', '1372813089187611288', '1372813089208881819', '1372813089198981282', '1372813089209223465', '1372813089195471292', '1372813089209061879', '1372813089191061283', '1372813089188721287', '1372813089209214140', '1372813089208251343', '1372813089208821887', '1372813089209218683', '1372813089209181624', '1372813089208311975', '1372813089200871286', '1372813089209215499', '1372813089192111281', '1372813089209031895', '1372813089208191571', '1372813089208671350', '1372813089192471291', '1372813089209212816', '1372813089192111289', '1372813089208821527', '1372813089208221443', '1372813089208911307', '1372813089191601283', '1372813089188691285', '1372813089203271300', '1372813089202371285', '1372813089208191722', '1372813089190731293', '1372813089208281359', '1372813089209218394', '1372813089209213374', '1372813089208821420', '1372813089193341282', '1372813089209216864', '1372813089209218375', '1372813089208851780', '1372813089208611456', '1372813089208311537', '1326795615585177600', '1372813089202341283', '1372813089209001464', '1372813089209222795', '1372813089188271295', '1372813089208821884', '1372813089187701282', '1372813089208491502', '1372813089209061345', '1', '1372813089209223780', '1372813089187641281', '1372813089193131282', '1372813089209223013', '1372813089198261283', '1372813089209223151', '1372813089208461324', '1372813089208521817', '1372813089208491804', '1372813089209218374', '1372813089209216306', '1372813089208221702', '1372813089208521826', '1372813089204561282', '1372813089209212394', '1372813089187791286', '1372813089200631282', '1372813089205971284', '1372813089208191693', '1372813089208161328', '1372813089199491284', '1372813089209221149', '1323142873301913600', '1372813089209215427', '1372813089208822262', '1372813089208401352', '1372813089189951285', '1372813089208311389', '1372813089208221800', '1372813089209219376', '1372813089192651285', '1351015692840734720', '1372813089208311516', '1372813089195651296', '1372813089209213103', '1372813089208851590', '1372813089209215171', '1369898587852378112', '1372813089209061657', '1372813089204711289', '1372813089208521398', '1372813089208161325', '1372813089209216946', '1372813089198261287', '1372813089199011282', '1372813089189681281', '1372813089208281611', '1372813089198321288', '1372813089209061723', '1372813089209218501', '1372813089188361282', '1372813089208431372', '1311274104996761600', '1372813089209222869', '1372813089209031615', '1372813089193851282', '1372813089200871284', '1372813089208671316', '1372813089205941281', '1372813089187791289', '1372813089209216927', '1372813089208341412', '1372813089209032468', '1372813089209212808', '1372813089200751288', '1372813089195591282', '1372813089208611358', '1372813089208341734')
```

* get all backups resources
```
kubectl get backups -A -ojson > backup_resources.json
```

* get all clusters resources
```
kubectl get clusters -ltags.tidbcloud.com/servicetype!=devtier -l"cloud.pingcap.com/provider-type in (aws,gcp,eks,gke)" -A -ojson > clusters_resources.json
```

* get all networks resources
```
kubectl get networks -ltags.tidbcloud.com/servicetype!=devtier -l"cloud.pingcap.com/provider-type in (aws,gcp,eks,gke)" -A -ojson > network_resources.json
```

* get all VPC peering resources
```
kubectl get networkpeers  -A -ojson > peering_resources.json
```