9:02 a.m.
------=_Part_12676489_1802186867.1369663357141
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
----- Original Message -----
From: "Edgar" <shweng(a)163.com>
To: engine-devel(a)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...
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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel
------=_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" &lt;shweng(a)163.com&gt;<br><b>To:
</b>engine-devel(a)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;"=
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></=
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--