<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><div><br></div><div><br></div><hr id="zwchr"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: 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<br><b>Sent: </b>Monday, May 27, 2013 4:35:42 PM<br><b>Subject: </b>[Engine-devel] How to get the number of all running VMs<br><div><br></div><div style="line-height:1.7;color:#000000;font-size:14px;font-family:arial" data-mce-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" data-mce-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" data-mce-style="line-height: 1.7; color: #000000; font-size: 14px; font-family: arial;"><span style="line-height: 1.7;" data-mce-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; " data-mce-style="color: #000000; 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; " data-mce-style="color: #000000; 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; " data-mce-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; " data-mce-style="color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"><span style="line-height: 1.7; " data-mce-style="line-height: 1.7;"> VM with </span><span style="line-height: 1.7; " data-mce-style="line-height: 1.7;">state </span><span style="line-height: 1.7; " data-mce-style="line-height: 1.7;">"Running" </span><span style="line-height: 1.7; " data-mce-style="line-height: 1.7;">.</span><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; " data-mce-style="color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"><span style="line-height: 1.7; " data-mce-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; " data-mce-style="color: #000000; 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></div></div></div></blockquote><div>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,<br></div><div>just enter in the search:<br></div><div>Vms: status != down and status != imagelocked and status != suspended</div><div><br></div><div>you can use get the same with rest api:<br></div><div><a href="http://localhost:8700/api/vms?search=%22status%20!=%20down%20and%20status%20!=%20imagelocked%20and%20status%20!=%20suspended%22">http://localhost:8700/api/vms?search=%22status%20!=%20down%20and%20status%20!=%20imagelocked%20and%20status%20!=%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="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:arial" data-mce-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" data-mce-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" data-mce-style="line-height: 1.7; color: #000000; font-size: 14px; font-family: arial;"><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; " data-mce-style="color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; " data-mce-style="color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"><span style="line-height: 1.7; " data-mce-style="line-height: 1.7;"> </span></div><div style="color: rgb(0, 0, 0); font-family: arial; font-size: 14px; line-height: 1.7; " data-mce-style="color: #000000; font-family: arial; font-size: 14px; line-height: 1.7;"><br></div></div></div></div><br><div><br></div><span title="neteasefooter"><br>_______________________________________________<br>Engine-devel mailing list<br>Engine-devel@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/engine-devel<br></span></div></blockquote><div><br></div></div></body></html>