You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Juan Gomez <ju...@kumo.com.co> on 2014/05/06 22:58:26 UTC

Total number of Vms?

Hello everyone,

How can i quickly count the total number of VMs that exist in my whole cluoudstack environment including all the zones ?

Thank You




Email asegurado por Check Point


Re: Total number of Vms?

Posted by Rafael Weingartner <ra...@gmail.com>.
That is not quite true.
It will just list the VMs that are not inside a project.
So, it will not be an accurate value of the number of VMs deployed.


On Thu, May 8, 2014 at 2:35 AM, Sanjay Tripathi
<sa...@citrix.com>wrote:

> Hi Juan,
>
> If you want to use API, then use "listVirtualMachines" API with
> "listAll=true" parameter and in the API resource, first thing you'll get is
> the count of total VMs present in your setup.
>
> --Sanjay
>
> -----Original Message-----
> From: Juan Gomez [mailto:juan.gomez@kumo.com.co]
> Sent: Wednesday, May 7, 2014 5:58 AM
> To: <us...@cloudstack.apache.org>
> Subject: Re: Total number of Vms?
>
> Thank you all for the help , it seems that the easyest way is querying the
> dataabase
>
> Enviado desde mi iPhone
>
> > El 6/05/2014, a las 18:39, "Pierre-Luc Dion" <pd...@cloudops.com>
> escribió:
> >
> > Their is also the ruby gem: cloudstack_ruby_client if its for a script.
> > It provide the total instance count  automatically when calling
> > list_instance
> >
> > Le mardi 6 mai 2014, Ahmad Emneina <ae...@gmail.com> a écrit :
> >
> >> make sure to include in your query some additional clauses; and
> type='User'
> >> and removed is null... something along those lines.
> >>
> >>
> >> On Tue, May 6, 2014 at 3:07 PM, rammohan ganapavarapu <
> >> rammohanganap@gmail.com <javascript:;>> wrote:
> >>
> >>> Can't you query databse? "select * from user_vm;" some thing like this?
> >>>
> >>>
> >>>> On Tue, May 6, 2014 at 1:58 PM, Juan Gomez
> >>>> <juan.gomez@kumo.com.co<javascript:;>>
> >>> wrote:
> >>>
> >>>> Hello everyone,
> >>>>
> >>>> How can i quickly count the total number of VMs that exist in my
> >>>> whole cluoudstack environment including all the zones ?
> >>>>
> >>>> Thank You
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> Email asegurado por Check Point
> >
> >
> > --
> >
> > Pierre-Luc Dion
> > Architecte de Solution Cloud | Cloud Solutions Architect 855-OK-CLOUD
> > (855-652-5683) x1101
> > - - -
> >
> > *CloudOps*420 rue Guy
> > Montréal QC  H3J 1S6
> > www.cloudops.com
> > @CloudOps_
> >
> >
> >
> > Email asegurado por Check Point
> >
>
> Email asegurado por Check Point
>



-- 
Rafael Weingärtner

RE: Total number of Vms?

Posted by Sanjay Tripathi <sa...@citrix.com>.
Hi Juan,

If you want to use API, then use "listVirtualMachines" API with "listAll=true" parameter and in the API resource, first thing you'll get is the count of total VMs present in your setup.

--Sanjay

-----Original Message-----
From: Juan Gomez [mailto:juan.gomez@kumo.com.co] 
Sent: Wednesday, May 7, 2014 5:58 AM
To: <us...@cloudstack.apache.org>
Subject: Re: Total number of Vms?

Thank you all for the help , it seems that the easyest way is querying the dataabase 

Enviado desde mi iPhone

> El 6/05/2014, a las 18:39, "Pierre-Luc Dion" <pd...@cloudops.com> escribió:
> 
> Their is also the ruby gem: cloudstack_ruby_client if its for a script.
> It provide the total instance count  automatically when calling 
> list_instance
> 
> Le mardi 6 mai 2014, Ahmad Emneina <ae...@gmail.com> a écrit :
> 
>> make sure to include in your query some additional clauses; and type='User'
>> and removed is null... something along those lines.
>> 
>> 
>> On Tue, May 6, 2014 at 3:07 PM, rammohan ganapavarapu < 
>> rammohanganap@gmail.com <javascript:;>> wrote:
>> 
>>> Can't you query databse? "select * from user_vm;" some thing like this?
>>> 
>>> 
>>>> On Tue, May 6, 2014 at 1:58 PM, Juan Gomez 
>>>> <juan.gomez@kumo.com.co<javascript:;>>
>>> wrote:
>>> 
>>>> Hello everyone,
>>>> 
>>>> How can i quickly count the total number of VMs that exist in my 
>>>> whole cluoudstack environment including all the zones ?
>>>> 
>>>> Thank You
>>>> 
>>>> 
>>>> 
>>>> 
>>>> Email asegurado por Check Point
> 
> 
> --
> 
> Pierre-Luc Dion
> Architecte de Solution Cloud | Cloud Solutions Architect 855-OK-CLOUD 
> (855-652-5683) x1101
> - - -
> 
> *CloudOps*420 rue Guy
> Montréal QC  H3J 1S6
> www.cloudops.com
> @CloudOps_
> 
> 
> 
> Email asegurado por Check Point
> 

Email asegurado por Check Point

Re: Total number of Vms?

Posted by Juan Gomez <ju...@kumo.com.co>.
Thank you all for the help , it seems that the easyest way is querying the dataabase 

Enviado desde mi iPhone

> El 6/05/2014, a las 18:39, "Pierre-Luc Dion" <pd...@cloudops.com> escribió:
> 
> Their is also the ruby gem: cloudstack_ruby_client if its for a script.
> It provide the total instance count  automatically when calling
> list_instance
> 
> Le mardi 6 mai 2014, Ahmad Emneina <ae...@gmail.com> a écrit :
> 
>> make sure to include in your query some additional clauses; and type='User'
>> and removed is null... something along those lines.
>> 
>> 
>> On Tue, May 6, 2014 at 3:07 PM, rammohan ganapavarapu <
>> rammohanganap@gmail.com <javascript:;>> wrote:
>> 
>>> Can't you query databse? "select * from user_vm;" some thing like this?
>>> 
>>> 
>>>> On Tue, May 6, 2014 at 1:58 PM, Juan Gomez <juan.gomez@kumo.com.co<javascript:;>>
>>> wrote:
>>> 
>>>> Hello everyone,
>>>> 
>>>> How can i quickly count the total number of VMs that exist in my whole
>>>> cluoudstack environment including all the zones ?
>>>> 
>>>> Thank You
>>>> 
>>>> 
>>>> 
>>>> 
>>>> Email asegurado por Check Point
> 
> 
> -- 
> 
> Pierre-Luc Dion
> Architecte de Solution Cloud | Cloud Solutions Architect
> 855-OK-CLOUD (855-652-5683) x1101
> - - -
> 
> *CloudOps*420 rue Guy
> Montréal QC  H3J 1S6
> www.cloudops.com
> @CloudOps_
> 
> 
> 
> Email asegurado por Check Point
> 

Email asegurado por Check Point

Re: Total number of Vms?

Posted by Pierre-Luc Dion <pd...@cloudops.com>.
Their is also the ruby gem: cloudstack_ruby_client if its for a script.
It provide the total instance count  automatically when calling
list_instance

Le mardi 6 mai 2014, Ahmad Emneina <ae...@gmail.com> a écrit :

> make sure to include in your query some additional clauses; and type='User'
> and removed is null... something along those lines.
>
>
> On Tue, May 6, 2014 at 3:07 PM, rammohan ganapavarapu <
> rammohanganap@gmail.com <javascript:;>> wrote:
>
> > Can't you query databse? "select * from user_vm;" some thing like this?
> >
> >
> > On Tue, May 6, 2014 at 1:58 PM, Juan Gomez <juan.gomez@kumo.com.co<javascript:;>>
> wrote:
> >
> > > Hello everyone,
> > >
> > > How can i quickly count the total number of VMs that exist in my whole
> > > cluoudstack environment including all the zones ?
> > >
> > > Thank You
> > >
> > >
> > >
> > >
> > > Email asegurado por Check Point
> > >
> > >
> >
>


-- 

Pierre-Luc Dion
Architecte de Solution Cloud | Cloud Solutions Architect
855-OK-CLOUD (855-652-5683) x1101
- - -

*CloudOps*420 rue Guy
Montréal QC  H3J 1S6
www.cloudops.com
@CloudOps_

Re: Total number of Vms?

Posted by Ahmad Emneina <ae...@gmail.com>.
make sure to include in your query some additional clauses; and type='User'
and removed is null... something along those lines.


On Tue, May 6, 2014 at 3:07 PM, rammohan ganapavarapu <
rammohanganap@gmail.com> wrote:

> Can't you query databse? "select * from user_vm;" some thing like this?
>
>
> On Tue, May 6, 2014 at 1:58 PM, Juan Gomez <ju...@kumo.com.co> wrote:
>
> > Hello everyone,
> >
> > How can i quickly count the total number of VMs that exist in my whole
> > cluoudstack environment including all the zones ?
> >
> > Thank You
> >
> >
> >
> >
> > Email asegurado por Check Point
> >
> >
>

Re: Total number of Vms?

Posted by Rafael Weingartner <ra...@gmail.com>.
actually, you can and that would work.


On Tue, May 6, 2014 at 7:07 PM, rammohan ganapavarapu <
rammohanganap@gmail.com> wrote:

> Can't you query databse? "select * from user_vm;" some thing like this?
>
>
> On Tue, May 6, 2014 at 1:58 PM, Juan Gomez <ju...@kumo.com.co> wrote:
>
> > Hello everyone,
> >
> > How can i quickly count the total number of VMs that exist in my whole
> > cluoudstack environment including all the zones ?
> >
> > Thank You
> >
> >
> >
> >
> > Email asegurado por Check Point
> >
> >
>



-- 
Rafael Weingärtner

Re: Total number of Vms?

Posted by rammohan ganapavarapu <ra...@gmail.com>.
Can't you query databse? "select * from user_vm;" some thing like this?


On Tue, May 6, 2014 at 1:58 PM, Juan Gomez <ju...@kumo.com.co> wrote:

> Hello everyone,
>
> How can i quickly count the total number of VMs that exist in my whole
> cluoudstack environment including all the zones ?
>
> Thank You
>
>
>
>
> Email asegurado por Check Point
>
>

Re: Total number of Vms?

Posted by Rafael Weingartner <ra...@gmail.com>.
i would say to you to try Cloudmonkey, I think there you can create
something easy to count the total of VMs including projects, zones and etc..


On Tue, May 6, 2014 at 5:58 PM, Juan Gomez <ju...@kumo.com.co> wrote:

> Hello everyone,
>
> How can i quickly count the total number of VMs that exist in my whole
> cluoudstack environment including all the zones ?
>
> Thank You
>
>
>
>
> Email asegurado por Check Point
>
>


-- 
Rafael Weingärtner