<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi all,<br>
<br>
<b>I have a script /usr/bin/bill</b><br>
<small><small>#!/usr/bin/env ruby<br>
<br>
require 'json'<br>
<br>
j = JSON.parse(`oneacct -j -s $1 -e $2`)<br>
<br>
puts "oid,vcpus,memory,minutes_running"<br>
<br>
j['HISTORY_RECORDS']['HISTORY'].each do |h|<br>
puts "#{h['OID']},"<<<br>
"#{h['VM']['TEMPLATE']['VCPU']},"<<<br>
"#{h['VM']['TEMPLATE']['MEMORY']},"<<<br>
"#{(h['ETIME'].to_i - h['STIME'].to_i)/60}"<br>
end</small></small><br>
<br>
Output from that command:<br>
<b><small><small>oneadmin@myto-node:~$ bill "01/01/2013" "01/31/2013"</small></small></b><br>
<small><small>oid,vcpus,memory,minutes_running<br>
0,2,1024,0<br>
0,2,1024,0<br>
1,2,1024,0<br>
1,2,1024,32<br>
</small><small><small><small>.<br>
.<br>
.</small></small><br>
110,4,8096,29925<br>
111,4,8096,84<br>
112,4,8096,5939<br>
113,4,8096,22<br>
114,4,8096,<font color="#ff0000">-22637691<br>
<br>
<big><big><font color="#000000">First 4 lines were VM's running in october 2012 (for a while), last line is still running VM.<br>
<br>
<b>My questions:</b></font></big></big></font></small></small><br>
- how can I limit time frame for oneacct command (i.e. - from 1. 1. 2013 to 31.1.2013 - only running VM's in that only period)?<br>
If I use -s and -e option, it displays all machines without any limitations ...<br>
- how can I display correct figures in minutes for running machines in oneacct output?<br>
<br>
Jan<br>
<div class="moz-signature">-- <br>
<title></title>
<font size="3" face="Helvetica"><img alt="" src="cid:part1.07070903.00000000@atos.net" width="252" height="15"><br>
<b>Ján Beňadik</b><br>
<font size="2" face="Helvetica">Managed Services - Solution Design Architect<br>
mobile: +421 903 691 634<br>
fax: +421 2 6852 8380<br>
<a href="mailto://jan.benadik@atos.net">jan.benadik@atos.net</a><br>
Vinohradnicka 6, 971 01 Prievidza<br>
<a href="http://www.sk.atos.net">www.sk.atos.net</a><br>
__________________________________<br>
<br>
<img alt="" src="cid:part4.06050801.07060407@atos.net" width="261" height="58"><br>
</font></font></div>
</body>
</html>