Can you explain "does not work"
--
Chiradeep
> On Jun 16, 2014, at 10:02 PM, "ilya musayev" <ilya.mailing.li...@gmail.com>
> wrote:
>
> Thanks Chiradeep and Wei
>
> Unfortunately neither gave me what i needed, so i wrote this SQL script:
>
> SELECT b.name, count(*) FreeIPCount
> FROM cloud.user_ip_address a, cloud.networks b
> WHERE b.id=a.source_network_id
> AND a.state = "Free"
> and b.name is not null
> group by b.name;
>
> Chiradeep, for some reason list virtualmachines calls in cloudmonkey does not
> always work, especially if you have a very large environment with several
> thousand VMs. I'd think it has something to do with how cloudmonkey buffers
> the output, but i dont know enough about its inner working.
>
>> On 6/16/14, 12:56 PM, Chiradeep Vittal wrote:
>> used=$(cloudmonkey list virtualmachines
>> networkid=f5119c7a-a5b8-47aa-bf26-d0f41dfa2d6b | grep ipaddress | wc -l)
>> space=$(cloudmonkey list networks id=f5119c7a-a5b8-47aa-bf26-d0f41dfa2d6b
>> | grep cidr | awk -F":" '{print $2}' | awk -F "/" '{print $2}')
>>
>> space=${space%\",}
>> let space="32 - $space"
>> let space=³2**$space - 1²
>>
>>
>>
>> let avail="$space - $used -1²
>> echo ³Available IPs = $avail"
>>
>>
>>
>>
>> From: ilya musayev <ilya.mailing.li...@gmail.com>
>> Reply-To: "dev@cloudstack.apache.org" <dev@cloudstack.apache.org>
>> Date: Monday, June 16, 2014 at 3:21 PM
>> To: "dev@cloudstack.apache.org" <dev@cloudstack.apache.org>
>> Subject: [API]How to check how many IPs are available in guest network
>>
>>
>> Is there a way to check how many guest IPs are available in specific
>> guest network?
>>
>> Current cloudstack reporting is not granular enough, i could not find a
>> command that says listAvailableIPs or something similar.
>>
>> Any help is appreciated.
>>
>> Thanks,
>> ilya
>
