[Engine-devel] How to get the number of all running VMs

------=_Part_304743_92154911.1369661742498 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: 7bit Hi All, I need to get the number of All running VMs of the oVirt-engine. My thought is first get all hosts with "up" status and then traverse each host and count the VM with state "Running" . Does this method feasible,and is there any easier way to count the running VMs of oVirt-engine? Best Regards ------=_Part_304743_92154911.1369661742498 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: 7bit <div style="line-height:1.7;color:#000000;font-size:14px;font-family:arial"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:arial"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:arial"><span style="line-height: 1.7;">Hi All,</span><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "> I need to get the number of All running VMs of the oVirt-engine.</div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "> My thought is first get all hosts with "up" status and then <span style="line-height: 1.7; ">traverse each host and count the </span></div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "><span style="line-height: 1.7; "> VM with </span><span style="line-height: 1.7; ">state </span><span style="line-height: 1.7; ">"Running" </span><span style="line-height: 1.7; ">.</span></div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "><span style="line-height: 1.7; "><br></span></div><div><span style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "> Does this method </span>feasible,and is there any easier way to count the running VMs of oVirt-engine?</div><div><br></div><div> Best Regards</div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "><span style="line-height: 1.7; "><br></span></div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "><span style="line-height: 1.7; "> </span></div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; "> </div></div></div></div><br><br><span title="neteasefooter"><span id="netease_mail_footer"></span></span> ------=_Part_304743_92154911.1369661742498--

------=_Part_12676489_1802186867.1369663357141 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message -----
From: "Edgar" <shweng@163.com> To: engine-devel@ovirt.org Sent: Monday, May 27, 2013 4:35:42 PM Subject: [Engine-devel] How to get the number of all running VMs
Hi All, I need to get the number of All running VMs of the oVirt-engine. My thought is first get all hosts with "up" status and then traverse each host and count the VM with state "Running" .
Does this method feasible,and is there any easier way to count the running VMs of oVirt-engine?
Best Regards
you can use the webadmin, but not sure there is an easy way to see total count if there are more than one pages of results, just enter in the search: Vms: status != down and status != imagelocked and status != suspended you can use get the same with rest api: http://localhost:8700/api/vms?search=%22status%20!=%20down%20and%20status%20... and parse the result or by using the db: select count(*) from vm_dynamic where status not in (0,15,13);
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
state </span><span style=3D"line-height: 1.7; " data-mce-style=3D"lin= e-height: 1.7;">"Running" </span><span style=3D"line-height: 1.7; " da= ta-mce-style=3D"line-height: 1.7;">.</span><div style=3D"color: rgb(0, 0, 0= ); font-family: arial; font-size: 14px; line-height: 1.7; " data-mce-style= =3D"color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"= <span style=3D"line-height: 1.7; " data-mce-style=3D"line-height: 1.7;"><b= r></span></div><div><span style=3D"color: rgb(0, 0, 0); font-family: arial;= font-size: 14px; line-height: 1.7; " data-mce-style=3D"color: #000000; fon= t-family: arial; font-size: 14px; line-height: 1.7;"> Does this metho= d </span>feasible,and is there any easier way to count the running VMs= of oVirt-engine?</div><div><br></div><div> Best Regards</div></div></=
------=_Part_12676489_1802186867.1369663357141 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: times new roman, new york, times, se= rif; font-size: 12pt; color: #000000"><div><br></div><div><br></div><hr id= =3D"zwchr"><blockquote style=3D"border-left:2px solid #1010FF;margin-left:5= px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-de= coration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-= mce-style=3D"border-left: 2px solid #1010FF; margin-left: 5px; padding-left= : 5px; color: #000; font-weight: normal; font-style: normal; text-decoratio= n: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From= : </b>"Edgar" <shweng@163.com><br><b>To: </b>engine-devel@ovirt.org<b= r><b>Sent: </b>Monday, May 27, 2013 4:35:42 PM<br><b>Subject: </b>[Engine-d= evel] How to get the number of all running VMs<br><div><br></div><div= style=3D"line-height:1.7;color:#000000;font-size:14px;font-family:arial" d= ata-mce-style=3D"line-height: 1.7; color: #000000; font-size: 14px; font-fa= mily: arial;"><div style=3D"line-height:1.7;color:#000000;font-size:14px;fo= nt-family:arial" data-mce-style=3D"line-height: 1.7; color: #000000; font-s= ize: 14px; font-family: arial;"><div style=3D"line-height:1.7;color:#000000= ;font-size:14px;font-family:arial" data-mce-style=3D"line-height: 1.7; colo= r: #000000; font-size: 14px; font-family: arial;"><span style=3D"line-heigh= t: 1.7;" data-mce-style=3D"line-height: 1.7;">Hi All,</span><div style=3D"c= olor: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; = " data-mce-style=3D"color: #000000; font-family: arial; font-size: 14px; li= ne-height: 1.7;"> I need to get the number of All running VMs of the o= Virt-engine.</div><div style=3D"color: rgb(0, 0, 0); font-family: arial; fo= nt-size: 14px; line-height: 1.7; " data-mce-style=3D"color: #000000; font-f= amily: arial; font-size: 14px; line-height: 1.7;"> My thought is = first get all hosts with "up" status and then <span style=3D"line-heig= ht: 1.7; " data-mce-style=3D"line-height: 1.7;">traverse each host and coun= t the </span></div><div style=3D"color: rgb(0, 0, 0); font-family: ari= al; font-size: 14px; line-height: 1.7; " data-mce-style=3D"color: #000000; = font-family: arial; font-size: 14px; line-height: 1.7;"><span style=3D"line= -height: 1.7; " data-mce-style=3D"line-height: 1.7;"> VM with </s= pan><span style=3D"line-height: 1.7; " data-mce-style=3D"line-height: 1.7;"= div></div></div></blockquote><div>you can use the webadmin, but not sure th= ere is an easy way to see total count if there are more than one pages of r= esults,<br></div><div>just enter in the search:<br></div><div>Vms: status != =3D down and status !=3D imagelocked and status !=3D suspended</div><div><b= r></div><div>you can use get the same with rest api:<br></div><div><a href= =3D"http://localhost:8700/api/vms?search=3D%22status%20!=3D%20down%20and%20= status%20!=3D%20imagelocked%20and%20status%20!=3D%20suspended%22">http://lo= calhost:8700/api/vms?search=3D%22status%20!=3D%20down%20and%20status%20!=3D= %20imagelocked%20and%20status%20!=3D%20suspended%22</a></div><div>and parse= the result<br></div><div><br></div><div><br></div><div>or by using the db:= <br></div><div>select count(*) from vm_dynamic where status not in (0,15,13= );</div><blockquote style=3D"border-left:2px solid #1010FF;margin-left:5px;= padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decor= ation:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce= -style=3D"border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5= px; color: #000; font-weight: normal; font-style: normal; text-decoration: = none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div style= =3D"line-height:1.7;color:#000000;font-size:14px;font-family:arial" data-mc= e-style=3D"line-height: 1.7; color: #000000; font-size: 14px; font-family: = arial;"><div style=3D"line-height:1.7;color:#000000;font-size:14px;font-fam= ily:arial" data-mce-style=3D"line-height: 1.7; color: #000000; font-size: 1= 4px; font-family: arial;"><div style=3D"line-height:1.7;color:#000000;font-= size:14px;font-family:arial" data-mce-style=3D"line-height: 1.7; color: #00= 0000; font-size: 14px; font-family: arial;"><div style=3D"color: rgb(0, 0, = 0); font-family: arial; font-size: 14px; line-height: 1.7; " data-mce-style= =3D"color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"=
<div style=3D"color: rgb(0, 0, 0); font-family: arial; font-size: 14px; li= ne-height: 1.7; " data-mce-style=3D"color: #000000; font-family: arial; fon= t-size: 14px; line-height: 1.7;"><span style=3D"line-height: 1.7; " data-mc= e-style=3D"line-height: 1.7;"> </span></div><div style=3D"color:= rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; " dat= a-mce-style=3D"color: #000000; font-family: arial; font-size: 14px; line-he= ight: 1.7;"><br></div></div></div></div><br><div><br></div><span title=3D"n= eteasefooter"><br>_______________________________________________<br>Engine= -devel mailing list<br>Engine-devel@ovirt.org<br>http://lists.ovirt.org/mai= lman/listinfo/engine-devel<br></span></div></blockquote><div><br></div></di= v></body></html> ------=_Part_12676489_1802186867.1369663357141--

On 05/27/2013 04:35 PM, Edgar wrote:
Hi All, I need to get the number of All running VMs of the oVirt-engine. My thought is first get all hosts with "up" status and then traverse each host and count the VM with state "Running" .
you can use ovirt-shell (3.3+) for this, just run 'summary' command: [oVirt shell (connected)]# summary hosts-active : 0 hosts-total : 0 storage_domains-active: 0 storage_domains-total : 0 users-active : 1 users-total : 1 vms-active : 0 vms-total : 3
Does this method feasible,and is there any easier way to count the running VMs of oVirt-engine?
Best Regards
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
-- Michael Pasternak RedHat, ENG-Virtualization R&D

On 05/27/2013 06:35 PM, Michael Pasternak wrote:
On 05/27/2013 04:35 PM, Edgar wrote:
Hi All, I need to get the number of All running VMs of the oVirt-engine. My thought is first get all hosts with "up" status and then traverse each host and count the VM with state "Running" .
you can use ovirt-shell (3.3+) for this, just run 'summary' command:
[oVirt shell (connected)]# summary
hosts-active : 0 hosts-total : 0 storage_domains-active: 0 storage_domains-total : 0 users-active : 1 users-total : 1 vms-active : 0 vms-total : 3
btw, you can script it (see [1]), just do 'summary | grep vms-active' [1] http://www.ovirt.org/CLI#Scripting
Does this method feasible,and is there any easier way to count the running VMs of oVirt-engine?
Best Regards
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
-- Michael Pasternak RedHat, ENG-Virtualization R&D
participants (3)
-
Edgar
-
Michael Pasternak
-
Omer Frenkel