zap51 commented on issue #6821:
URL: https://github.com/apache/cloudstack/issues/6821#issuecomment-1275603005
@weizhouapache
Here's the output of the query. Some information is redacted FYI.
> select * from user_ip_address join projects on
user_ip_address.account_id=projects.project_account_id where projects.removed
is not null;
```
+------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+------------+--------------+-----+------+--------------------------------------+-----------------------+--------------------+-----------+---------------------+---------------------+----------+
| id | uuid | account_id | domain_id |
public_ip_address | data_center_id | source_nat | allocated |
vlan_db_id | one_to_one_nat | vm_id | state | mac_address |
source_network_id | network_id | physical_network_id | is_system | vpc_id |
dnat_vmip | is_portable | display | removed | created | rule_state |
forsystemvms | id | name | uuid | display_text
| project_account_id | domain_id | created | removed
| state |
+------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+------------+--------------+-----+------+--------------------------------------+-----------------------+--------------------+-----------+---------------------+---------------------+----------+
| 1463 | 26527c7b-a846-4654-bd6d-8ae89c31ce40 | 1265 | 962 |
x.x.x.x | 7 | 1 | 2022-09-19 05:12:31 |
7 | 0 | NULL | Allocated | 379 | 219 |
NULL | 211 | 0 | 248 | NULL | 0 |
1 | NULL | NULL | NULL | 0 | 299 | NULL |
1cdf779b-23d8-40c4-be80-e69d8b24c95f | user-name-6536279 |
1265 | 962 | 2022-09-16 08:38:03 | 2022-09-21 12:53:24 | Disabled |
| 1499 | 9e4b3356-e0ae-4c5b-9edb-9ab576b757e4 | 1265 | 962 |
x.x.x.x | 7 | 1 | 2022-09-16 08:52:16 |
7 | 0 | NULL | Allocated | 391 | 219 |
NULL | 211 | 0 | 230 | NULL | 0 |
1 | NULL | NULL | NULL | 0 | 299 | NULL |
1cdf779b-23d8-40c4-be80-e69d8b24c95f | user-name-6536279 |
1265 | 962 | 2022-09-16 08:38:03 | 2022-09-21 12:53:24 | Disabled |
+------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+------------+--------------+-----+------+--------------------------------------+-----------------------+--------------------+-----------+---------------------+---------------------+----------+
```
Thanks
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
