It returns nothing, just a blank like.
I will be upgrading our CloudStack instances this week to see if the
issue still persists with 4.3.0, but i dont believe it will change my
result.
On 6/16/14, 10:14 PM, Chiradeep Vittal wrote:
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
