weizhouapache commented on issue #6698: URL: https://github.com/apache/cloudstack/issues/6698#issuecomment-1374122139
looks good @Hudratronium What about the following query? (copied from your log) If it returns empty, try without some of the conditions ``` SELECT user_ip_address.* FROM user_ip_address INNER JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 1 AND user_ip_address.allocated IS NULL AND user_ip_address.vlan_db_id IN (3,10,13,14) AND user_ip_address.forsystemvms = 1 AND user_ip_address.removed IS NULL AND (vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC ``` -- 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]
