Hi everyone,

First time poster and new to CloudPlatform. It's obviously a great product but there's definitely a learning curve, especially for someone who didn't architect the solution in the first place.

Here's my problem: I currently find myself unable to track IP addresses. When I login to a user account, click on "Network" and then click on the network assigned to the account, I see an option "View IP addresses" however all I see after clicking on that button is a blank page. I asked about it to the person who worked on putting the solution together and he didn't go into much details but replied it had something to do with a design choice we made. I didn't ask for much more details because I figured that choice wasn't going to change either way.

So, I started thinking there must be a way to get this information from the Mysql database. After all, when I focus on a specific instance, I can click on "NICs" and see its assigned IP. The MySQL query which seems to make sense is:

select * from user_ip_address where state = 'Free' and public_ip_address like '%XX.XX.XX%';

The query works, except an IP which was previous allocated still shows as such. I logged in as admin, located the account under "User accounts" and initiated a "Update resource count". The process completed based on the following ouput:

2013-05-06 16:57:31,299 DEBUG [cloud.alert.AlertManagerImpl] (CapacityChecker:null) Executing capacity updates for public ip and Vlans
2013-05-06 16:57:31,309 DEBUG [cloud.alert.AlertManagerImpl] (CapacityChecker:null) Done capacity updates for public ip and Vlans
2013-05-06 16:57:31,309 DEBUG [cloud.alert.AlertManagerImpl] (CapacityChecker:null) Executing capacity updates for private ip
2013-05-06 16:57:31,316 DEBUG [cloud.alert.AlertManagerImpl] (CapacityChecker:null) Done executing capacity updates for private ip

However when I run the SQL query, I still see the IP marked as "Allocated". I'm assuming somewhere there's another "garbage collection" process which would mark the IP as free. My question is: how do I manually trigger that process?